user avatar
user avatar
user avatar
mickmackusa
Moderator
  • Member for 4 years, 2 months
  • Last seen this week
  • Brisbane, Australia
9 votes
Accepted

How to Use IN Clause in Joomla Query

8 votes
Accepted

SQL Injections using Jfactory::getDBO and setQuery() with LIKE condition

5 votes
Accepted

with insert on duplicate key update - updating multiple rows at once

4 votes
Accepted

How to write a query with GROUP BY and ORDER BY using Joomla's query methods?

4 votes

How to check if specific table names exist in a database?

4 votes
Accepted

Issues to be aware of when calling `concatenate()`, `regexp()`, `rand()`, and `castAsChar()` in sql queries

4 votes
Accepted

(RuntimeException $e) vs (JDatabaseExceptionExecuting $e) for SQL exception handling

4 votes
Accepted

How to separate database results into 2 columns?

4 votes

using the sourcerer plugin the code written in php disappears

4 votes

Randomly render one of the modules in a given position

4 votes
Accepted

loadAssocList() is not working properly when assigning a column name as the key parameter

4 votes
Accepted

Joomla extension update 3.x and 4.x

3 votes

Redirect if userid is not found in a database table

3 votes

Dynamically adding Page URL and Page Title into html Link

3 votes

How to create a custom script to force the download of a .csv file that is generated in real time?

3 votes
Accepted

Get the Joomla database connection to a connection variable

3 votes

Upgrade component under development without reuploading files

3 votes
Accepted

How to replace   with a space?

3 votes

What does sql_select="e.*" do?

3 votes
Accepted

How can I get the names of the columns with their corresponding row values as a list to use in a field (select list) of a form in Joomla MySQL

3 votes
Accepted

SQL syntax error in query with subquery using JDatabase

3 votes
Accepted

How to show multidimensional data in my CanvasJS chart?

3 votes
Accepted

Latest articles structured data markup

3 votes
Accepted

Select query with FOR UPDATE

3 votes
Accepted

Use addScriptOptions for multiple modules on same page

3 votes
Accepted

Json encoding being escaped

2 votes

Check if INSERT query was successful or failed because of a duplicate UNIQUE KEY

2 votes
Accepted

How to rewrite SQL-query with CASE/WHEN to Joomla-based "format"

2 votes

Correct ways to verify update query is successful under conditions

2 votes
Accepted

How to use convert_tz in a joomla query?

1
2 3 4 5
7