#20287 [Opn->Bgs]: "order by" syntax problem

ID: 20287 Updated by: tal@php.net Reported By: otto@lanmetrix.co.za -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: Win98/MySQL PHP Version: 4.2.1 New Comment: Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Thank you for your interest in PHP. Previous Comments: ------------------------------------------------------------------------ [2002-11-06 11:05:21] otto@lanmetrix.co.za In the PHProjekt module "contacts_view.php" I wanted to sort the contacts list by "firma" and then by "nachname". I changed all instances of $sort = "nachname"; to $sort = "firma, nachname"; (note the space between arguments) When modifying or creating a contact, and then returning to the contacts list I get the error message: "You have an error in your SQL syntax near 'ASC' at line 1" I then removed the space like this: $sort = "firma,nachname"; (no space) This looks like a MySQL problem, but is it possible that PHP and/or PHProjekt handles the space character to cause the error? ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=20287&edit=1