query
| From: | Natividad Castro | Date: | Mon, 13 May 2002 13:25:05 +0000 |
| Subject: | query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19154@lists.php.net to get a copy of this message | ||
Hi to all,
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