Re: Stil having problems (WAS : Problem with links....)

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";