Re: Right syntax for max value??
| From: | John Nichel | Date: | Tue, 14 Jun 2005 16:12:20 +0000 |
| Subject: | Re: Right syntax for max value?? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-216950@lists.php.net to get a copy of this message | ||
twistednetadmin wrote:
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?
Not a php question, and you can't do this in MySQL 3.x
--
John C. Nichel
ÜberGeek
KegWorks.com
716.856.9675
john@kegworks.com