Re: How to select [please HELP]

Hi David, Perhaps you can modify your second query to the following way. SELECT recordid,uid,info FROM userstuff WHERE uid LIKE '$uid' AND recordid NOT LIKE '$recordid' -- Regards, William Lai -----Original Message----- From: David Tandberg-Johansen david@datajo.no Sent: Wed, 25 Apr 2001 15:33:17 +0200 To: php-db@lists.php.net Subject: [PHP-DB] How to select [please HELP] Hello! I am trying to select from a table where users add stuf. First I do: SELECT recordid,uid ,info FROM userstuff WHERE recordid LIKE '$recordid' Then I want to check if the user has more records in the table, based on the the first query SELECT recordid,uid,info FROM userstuff WHERE uid LIKE '$uid' AND NOT WHERE recordid LIKE '$recordid' But this query fails and I wonder if any one can give a hint on how. I tried the documentation on http://www.mysql.com but I found not anything that satisfied me. Thanks David -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net ___________________________________________________________________________ Visit http://www.visto.com/info, your free web-based communications center. Visto.com. Life on the Dot.