mysql related queries in JoomlaXchanger

How to sort my query's results by publish_up value?

php development mysql sorting
Updated June 10, 2019 14:10 PM

Joomla! extensions table is not unique

mysql
Updated June 03, 2019 15:10 PM

Delete query and left join with JDatabaseQuery doesn't work

mysql joomla-4
Updated June 02, 2019 08:10 AM

JCE convert unicode after save in my DB

mysql jce unicode
Updated March 12, 2019 08:10 AM

idx_XXX error after reimport from content table

mysql database
Updated March 11, 2019 13:10 PM

How to retrieve unique values before a parenthesis in JFormFieldList Filter query?

joomla-3.x component mysql jform
Updated March 11, 2019 03:10 AM

Joomla 2.5, how to use "HAVING" using Query Object

joomla-2.5 database mysql
Updated March 05, 2019 12:10 PM

Error loading module MySQL server has gone away

mysql virtuemart joomla-framework-1.x jerror
Updated March 02, 2019 07:10 AM

How to refactor two select queries on RSForm submission data?

joomla-3.x php mysql custom-module rsform
Updated March 01, 2019 10:10 AM

Filtering product query with two sets of filters. (J2Store)

joomla-3.x mysql jdatabase
Updated February 28, 2019 01:10 AM

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

joomla-3.x mysql sql bugs best-practices
Updated February 23, 2019 01:10 AM

Method for creating a subquery using JDatabase

php jdatabase mysql database
Updated February 03, 2019 17:10 PM

K2 Add tag to article if the keyword is in the article title

mysql tags k2
Updated February 03, 2019 17:10 PM

Database query outputting twice

php mysql
Updated February 03, 2019 02:10 AM

Table marked as crashed and repair failed

mysql database joomla-1.5
Updated February 02, 2019 01:10 AM

Which db table contains sku, and upc values of J2Store products?

joomla-3.x mysql
Updated January 31, 2019 20:10 PM

Installation page not shown due to MySql access denied

mysql installation linux
Updated January 12, 2019 15:10 PM

Are session variables available for mariadb mysql queries?

mysql session
Updated January 11, 2019 23:10 PM

Run UPDATE query on SELECT query result

joomla-3.x php mysql
Updated November 23, 2018 00:10 AM

SQL Error when updating custom component in Joomla 3.9

mysql custom-component jinstaller joomla-3.9
Updated November 14, 2018 19:10 PM

MySQL update select one table from another

mysql
Updated November 13, 2018 21:10 PM

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

mysql related issues & queries in JoomlaXchanger