How to select [please HELP]
| From: | David Tandberg-Johansen | Date: | Wed, 25 Apr 2001 13:33:17 +0000 |
| Subject: | How to select [please HELP] | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-8871@lists.php.net to get a copy of this message | ||
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