[prev in list] [next in list] [prev in thread] [next in thread]
List: php-windows
Subject: [PHP-WIN] Re: Stil having problems (WAS : Problem with links....)
From: Neil Smith <neil () fresh-toast ! uklinux ! net>
Date: 2003-02-28 14:59:40
[Download RAW message or body]
Hi - check your SQL : I think what you have here is a select asking for
MAX(ID) which will return one result (this is what MAX does).
So, no need to ask for WHERE id IN (SELECT(MAX(ID)) but instead ask for
SELECT id=MAX(ID).
If you wanted top n instead, ask for
SELECT id FROM data ORDER BY id DESC LIMIT 0,n
Probably. What are you actually trying to print out ?
HTH
Neil Smith.
At 13:26 28/02/2003 +0000, you wrote:
>I'm still having problems :
>
>My query :
>$q = "SELECT id, computer_id, date, domain, ip, license_key, software, wm_id
>FROM data WHERE id IN (SELECT MAX(ID) FROM data GROUP BY Computer_ID) " .
>$Where_Text . " ORDER BY Domain, Date DESC";
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic