Re: Right syntax for max value??
| From: | Sebastian Mendel | Date: | Tue, 14 Jun 2005 16:26:09 +0000 |
| Subject: | Re: Right syntax for max value?? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-216952@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 ) ";
MySQL 3.x doesnt support sub-querys
> 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?
SELECT newstitle
FROM news
ORDER BY news_id DESC
LIMIT 1
--
Sebastian Mendel
www.sebastianmendel.de
www.sf.net/projects/phpdatetime | www.sf.net/projects/phptimesheet