SQL Syntax error
Posted: Fri Apr 14, 2006 1:55 pm
Will anyone tell me what's wrong with this?
In my PHP page, I have the following code.
$query_rsFamilyDtls = sprintf("SELECT * FROM children WHERE familyID = %s AND %s ORDER BY %s ASC", $colname_rsFamilyDtls,$NXTFilter_rsFamilyDtls,$NXTSort_rsFamilyDtls);
The query from above generated the query below:
SELECT * FROM children WHERE familyID = 1 AND 1=1 ORDER BY fstName ASC
In Mozilla Firefox, it is fine. However in MS IE, I received this error:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC' at line 1
In my PHP page, I have the following code.
$query_rsFamilyDtls = sprintf("SELECT * FROM children WHERE familyID = %s AND %s ORDER BY %s ASC", $colname_rsFamilyDtls,$NXTFilter_rsFamilyDtls,$NXTSort_rsFamilyDtls);
The query from above generated the query below:
SELECT * FROM children WHERE familyID = 1 AND 1=1 ORDER BY fstName ASC
In Mozilla Firefox, it is fine. However in MS IE, I received this error:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC' at line 1