... 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:
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
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