RE: [PHP-DB] How to select [please HELP]
| From: | Michael Rudel | Date: | Wed, 25 Apr 2001 13:41:26 +0000 |
| Subject: | RE: [PHP-DB] How to select [please HELP] | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-8873@lists.php.net to get a copy of this message | ||
... AND recordid NOT LIKE '$recordid'
I think this will do the job.
Greetinx,
Mike
Michael Rudel
- Web-Development, Systemadministration -
_______________________________________________________________
Suchtreffer AG
Bleicherstraße 20
D-78467 Konstanz
Germany
fon: +49-(0)7531-89207-17
fax: +49-(0)7531-89207-13
e-mail: mailto:mru@suchtreffer.de
internet: http://www.suchtreffer.de
_______________________________________________________________
> -----Original Message-----
> From: David Tandberg-Johansen [mailto:david@datajo.no]
> Sent: Wednesday, April 25, 2001 3:33 PM
> 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
>