RE: Need correct 'order by' syntax where field does not contain NULL

2004-05-04 Thread Chris DaMour
Your first problem is the order not having backticks you have to do ORDER BY `order`, title or you'll get a sql error. But the other thing you'll run into is that null evaluates to les than any int, meaning the null rows will come before your numbered rows, however you can't just switch to

RE: PHP AND MYSQL

2004-02-02 Thread Chris DaMour
PHP has changed their superglobals, no longer can you just put a $ infront of the assigned name attribute. (You can change this in the php.ini file, but it's discouraged) Instead use $_GET['name'] Or $_POST['name'] So for $manufacturer $_POST['manufacturer'] -Original Message- From: