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 [EMAIL PROTECTED]
Sent: Wed, 25 Apr 2001 15:33:17 +0200
To: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
___________________________________________________________________________
Visit http://www.visto.com/info, your free web-based communications center.
Visto.com. Life on the Dot.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]