query
| From: | Natividad Castro | Date: | Mon, 13 May 2002 19:46:43 +0000 |
| Subject: | query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19157@lists.php.net to get a copy of this message | ||
Hi to all,
I posted this question this morning and George tried to help, but I couldn't
make it to work.
if anybody else could help me that would greate.
I have a query
$query = mysql_query("SELECT * from 150bk where Signature like '%1%' and
150bk.ID ='$rec_id' limit 1");
which works fine, but when it gets into a record that has a different number
at the end (e.g. Castro3), it still display the record ID without data. How
can I get rid of that record? I just want to display the ones where
signature is like '%1%'( e.g. Castro1) and skip the ones (like Castro3)
Can anybody help me?
Thanks in advanced
Nato