sql query

James 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 mailing list