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
putting
> 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.

James





More information about the Ukfreebsd mailing list