mysql related queries in JoomlaXchanger | QueryXchanger

How to construct a JOIN query with Joomla's query methods?

mysql sql
Updated October 18, 2018 15:10 PM

Get list of tables into an array

joomla-3.x php mysql database
Updated October 18, 2018 11:10 AM

If statement not executing

joomla-3.x php mysql
Updated October 11, 2018 03:10 AM

Select statement does not process WHERE conditions

mysql joomla-api
Updated October 05, 2018 21:10 PM

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

joomla-3.x mysql custom-component database jdatabase
Updated September 16, 2018 13:10 PM

How do I set the flag CLIENT_MULTI_STATEMENTS in joomla

joomla-3.x mysql
Updated September 13, 2018 00:10 AM

Joomla / PHPMyAdmin bug when “select” is in the value

joomla-3.x php mysql
Updated September 06, 2018 15:10 PM

Joomla login issue after xampp upgrade mysql to mariadb

joomla-3.x mysql xampp
Updated August 10, 2018 16:10 PM

Insert multiple rows with posted data

php mysql
Updated July 03, 2018 10:10 AM

Missing Aliases - Use SQL Query to populate from other field

joomla-3.x mysql
Updated June 28, 2018 15:10 PM

Component SQL install script works in phpmyadmin not in script

joomla-3.x development mysql installation
Updated June 25, 2018 14:10 PM

Creating a module to search the database and display the results

component development module database mysql
Updated June 22, 2018 07:10 AM

Sometimes it shows the error #1044

joomla-3.x mysql
Updated June 21, 2018 09:10 AM

Hide a value or data on table

extensions mysql module-display front-end user-groups
Updated June 19, 2018 21:10 PM

Change datetime type format in mysql to euro date format in php page

joomla-3.x php mysql
Updated June 19, 2018 05:10 AM

Get Timestamp from Database

php module joomla-3.4 mysql
Updated June 19, 2018 04:10 AM

MySQL Search Results Based on Tags

mysql tags
Updated June 16, 2018 18:10 PM

How to re-write sql for joomla JDatabase

joomla-3.x php mysql jdatabase sql
Updated May 15, 2018 14:10 PM

Keeping pdo connection open across multiple modules?

php mysql performance
Updated May 04, 2018 21:10 PM

Rows with same id in same div

joomla-3.x php mysql
Updated May 01, 2018 06:10 AM

Query not giving expected answer

joomla-3.x mysql jdatabase
Updated April 30, 2018 10:10 AM

How to change unicode character from mysql to utf8 string?

php mysql
Updated April 28, 2018 02:10 AM

Error wheng getting value from table row by two arguments in WHERE clause

mysql select
Updated April 28, 2018 00:10 AM

What is the prefered method for sharing code and SQL queries in joomla 3.9+?

joomla-3.x php mysql joomla-api custom-component
Updated April 25, 2018 04:10 AM

Php-sql result in joomla displayed in question marks

php mysql rsform
Updated April 19, 2018 09:10 AM

Update multiple columns with plus 1

joomla-3.x mysql database
Updated April 19, 2018 08:10 AM

SQL Injections using Jfactory::getDBO and setQuery()

joomla-3.x mysql jdatabase joomla3.8.5
Updated April 18, 2018 19:10 PM

How to Use IN Clause in Joomla Query

mysql joomla-api
Updated April 04, 2018 19:10 PM

Update specific row in FOREACH loop

joomla-3.x php mysql
Updated April 03, 2018 09:10 AM

passing an array from view to controller to model

joomla-3.x component mysql custom-component form-fields-types
Updated March 11, 2018 17:10 PM

Joomla : Multiple primary key defined error when installing plugin

plugin mysql installation
Updated March 08, 2018 13:10 PM

SQL WHERE clause with a variable (current article ID)

joomla-3.x mysql variable
Updated March 05, 2018 19:10 PM

Localize output of SQL query

joomla-3.x mysql database community-builder
Updated March 03, 2018 17:10 PM

Copy users from one Joomla db to a slightly newer one

joomla-3.x mysql phpmyadmin
Updated March 01, 2018 20:10 PM

How can I save multiple dynamic values using check boxes?

joomla-3.x php component mysql form
Updated February 26, 2018 08:10 AM

Need help writing a form to a table

joomla-3.x component mysql form view
Updated February 24, 2018 10:10 AM

Restore deleted user

mysql administrator user
Updated February 22, 2018 14:10 PM

Why my code doesn't work?

php mysql
Updated February 17, 2018 19:10 PM

how can I translate SQL code into something that Joomla will take?

php mysql
Updated February 12, 2018 17:10 PM

What's the proper chaining for WHERE

mysql
Updated January 29, 2018 18:10 PM

Replace all instances of previous site name in DB

joomla-3.x mysql phpmyadmin
Updated January 11, 2018 15:10 PM

How to get banners clients when exists banners with this client?

mysql com-banners
Updated December 19, 2017 17:10 PM

sum a query from database

joomla-3.x php mysql
Updated November 18, 2017 14:10 PM

making component,data not saving

joomla-3.x mysql administrator
Updated November 14, 2017 00:10 AM

Button with mysql querry

joomla-3.x mysql
Updated November 12, 2017 15:10 PM

Joomla plugin to override table prefix

joomla-3.x mysql jdatabase
Updated October 26, 2017 15:10 PM

Fabrik Cross database joins

php mysql fabrik
Updated October 22, 2017 15:10 PM

How to create all database view in joomla

joomla-3.x php mysql
Updated September 22, 2017 10:10 AM

How to debug a new installation?

joomla-3.x php mysql
Updated September 21, 2017 11:10 AM

Why my custom query only returns one result?

mysql database jfactory
Updated September 15, 2017 02:10 AM

mysql related issues & queries in JoomlaXchanger