can't parse query

[joeball]

im trying to form a query, based on an array of fields and values
there are 10 values passed all the time,
they are either empty or have a value

trying to form a dynamic query
2 outcomes

1. ... WHERE fname='joe');
2. ... WHERE fname='joe' AND lname='ball' ...);

for each in searcharray[] that is NOT empty
$fields .= ($key='$value')
OR
$fields .=($key='$value' AND)

for each in searcharray that is not empty

does anyone know a good way of doing this...

Thanks Nate,
🙁

[shamly]

Try This Out

$fields = '';

for each in searcharray[] that is NOT empty
if($fields == '')
$fields = ($key='$value')
else
$fields .= ( AND $key='$value')