Mysql 3.23 does not support the subquery you are using in your sql statement. Check http://dev.mysql.com/doc/mysql/en/subqueries.html for more information. Neal -----Original Message----- From: twistednetadmin [mailto:twistednetadmin@xxxxxxxxx] Sent: Tuesday, June 14, 2005 9:44 AM To: php-general@xxxxxxxxxxxxx Subject: Right syntax for max value?? I am making a table at my homepage that automatically collects the latest news from mysql db. I have got it to work at my own server at home, but not at www.torewestre.com (my remote site) Local settings:(WinXP Pro) Apache 2.0.54, PHP 5.0.4 and MySQL 4.1.11 Remote settings:(Unix) Apache 1.3.27, PHP 4.3.4 and MySQL 3.23.54 This is the query that works on localhost: $getnewstitle = "SELECT newstitle FROM `news` WHERE news_id = ( SELECT max( news_id ) FROM news ) "; What it does: collects the newstitle from the field where PRIMARY key(news_id) is the highest auto_increment number. This works just as excpected on localhost but not on remote. Does anybody know the right syntax? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
