If I understand your problem correctly, it sounds like you need to get all
of the values for the two select objects (which you can do with PHP, of
course) then use JavaScript to handle the CLIENT SIDE update process between
the two objects.
If that sounds like what you're looking for, you can
Try unset after the if statement
if ($nameb == ){
$query = SELECT * FROM recipes WHERE points $pointsb;
} else {
$query = SELECT * FROM recipes WHERE name = '$nameb';
$new_nameb = $nameb;
unset($nameb);
}
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
Since you didn't include the form, I'm going to have to make a couple of
assumptions:
$nameb is the recipe field.
$pointsb is the points field.
You want to use SQL statement 1 if they select points, 2 if they select
recipies, but those aren't the only possibilities with the form. It sounds to