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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
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]
