problem with null fields when searching a mysql table

[garethj]

hi,

i'm having a problem with null fields when searching a mysql table.

seems like when a field within a certain row is null the row won't get returned in my search.

here's the query i'm using:

$query = "SELECT * FROM members where contract_number LIKE '%".$contract_number."%' && password LIKE '%".$password."%'
&& name LIKE '%".$name."%' && address LIKE '%".$address."%' && phone LIKE '%".$phone."%' ";

so, if the $address [or any other field] is null then the whole row won't get returned.

thanks.
g.

[bastien]

according to the sql statement, it shold not be passed back to you...if you look at your conditions, it requires that ALL fields be something (%$somevalue%)...you may need to consider using the OR operator or changing the sql in some other way to choose a particular row...