Re: How to select [please HELP]

On Wed, 25 Apr 2001, David Tandberg-Johansen wrote: > 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' rewrite it like: SELECT recordid, uid, info FROM userstaff WHERE uid LIKE '$uid' AND recordid NOT 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 >