Here's the deal...on submit I am updating a MySQL 'log' table in my db.
I want to add an additional value update to a different table based on having a check box selected.
The original submit update works fine, but as the if statement is processing the update to the other table does not work...
below is the code...appreciate any input!!!
if ($submitinfo == "SUBMIT") {
$sqlinsert = "INSERT INTO log set
comments='$comments',
shoes='$shoes',
distance='$distance',
workout_type='$workout_type'";
if ($addOther == "ADD")
$sqlinsert2 = "INSERT INTO course set course_name='$otherCourse'";
if (@mysql_query($sqlinsert))
{
echo("The $workout_type of $distance miles wearing your $shoes shoes, has been added to your log. NICE JOB!");
}
else
{
echo("<p>Error adding info: " . mysql_error(). "</p>");
}
}
?>
