Code: Select all
$query_table = "SELECT * FROM sys_fields WHERE db_table_name = '$db_table_name' ORDER BY '$order' '$dir'";I used the same code on another table, but it didn't have a "where" statement - it worked fine.
Confused
Cheers,
Doug
Moderator: General Moderators
Code: Select all
$query_table = "SELECT * FROM sys_fields WHERE db_table_name = '$db_table_name' ORDER BY '$order' '$dir'";Why are you quoting the table name, order by column and direction?cardi777 wrote:What am I doing wrong? The issue is that "order by" isn't doing anything. No errors show either.
Code: Select all
$query_table = "SELECT * FROM sys_fields WHERE db_table_name = $db_table_name ORDER BY $order $dir";Code: Select all
SELECT * FROM sys_fields WHERE db_table_name = table_test33 ORDER BY f_pos ASC
Unknown column 'table_test33' in 'where clause'Code: Select all
SELECT * FROM sys_fields WHERE db_table_name = 'table_test33' ORDER BY 'f_pos' 'ASC'Code: Select all
$query_table = "SELECT * FROM sys_fields WHERE db_table_name = '$db_table_name' ORDER BY $order $dir";