James at reftech.co.uk
Wed Nov 13 16:07:32 GMT 2002
> id won't be checked if a result is returned on the LIKE - i.e., a name
> matches, so $id won't be required because of the OR. If the id matches
> you're expecting that don't match LIKE $name aren't coming back try
> braces around each part of your query - WHERE (name LIKE '$name%') OR (id
> '$id') - and perhaps switching it around might help.
Experimentation doesn't bear the above out, ie, all matches will be
returned, not just the first.
More information about the Ukfreebsd