Code: Select all
<select name='userid'>";
$resultsa = mysql_query ("SELECT id, firstname, lastname FROM admin ORDER BY firstname")or die(mysql_error());
while ($rowa = mysql_fetch_object($resultsa))
{
$resultsb = mysql_query ("SELECT userid, raceid FROM diary WHERE raceid = '$id' AND userid = '$rowa->id' AND pitno IS NULL")or die(mysql_error());
$num_rowsb = mysql_num_rows($resultsb);
if ($num_rowsb == 0) { $submit = no;}
if ($submit == "no")
{
while ($rowb = mysql_fetch_object($resultsb))
{
echo "<option value='$rowb->userid'>$rowa->firstname $rowa->lastname</option>";
}}mysql_free_result($resultsb);
} mysql_free_result($resultsa);
echo "</select>";
if ($submit == "no") { echo " No race bookings yet";}
if ($submit == NULL) { echo "<input type='submit' value='Select & Continue'>";}
echo "</form>";It's completely contradictory. Can anyone help tell me why $submit is getting a result at all?