steve at softgreen.co.uk
Wed Nov 13 16:07:15 GMT 2002
If the id is a number (as I assume it would be) then it should not be
'quoted' ... so:
if ($result = mysql_query("SELECT * FROM db WHERE name LIKE '$name%' OR
id = $id", $db));
blah blah blah
Robin Garbutt wrote:
> can you use 'LIKE' and '=' in the same sql query?
> if ($result = mysql_query("SELECT * FROM db WHERE name LIKE '$name%' OR id =
> '$id'", $db));
> blah blah blah
> as the id don't seem to be querying...
> any suggestions?
> Robin Garbutt
> Portfolio Art & Design Ltd
> Tel - +44 (0) 1204 383822
> Fax - +44 (0) 1204 383866
> Mob - +44 (0) 7811 185490
> e-mail - Rob at portfoliodesign.net
> For further information please visit us at :-
> The contents of this e-mail are confidential to the ordinary user of the
> e-mail address to which it was addressed and may also be privileged. If you
> are not the addressee of this e-mail you may not copy, forward, disclose or
> otherwise use it or any part of it in any form whatsoever. If you have
> received this e-mail in error please e-mail the sender.
> ------ FreeBSD UK Users' Group - Mailing List ------
More information about the Ukfreebsd