INSERT inside for loop

[dolcezza]

I am not able to test my code from where i am now, and I am not sure why my editor is underlining this code.

Any chance someone may be willing to help me find the issue?

It's underlining the if ($time) {

but obviously that doesn't always mean it's not before or after.

for ($loop=1;$loop<=3;$loop++) {
$time = $_POST['time-'.$loop];
if ($time) {
    $scheduleinsert = "INSERT INTO schedules (eventid, time, grades, room, notes) VALUES ('$eventid', '$time', '$grades', '$room', '$notes')";
    $schedule_result=mysql_query($scheduleinsert);

Thanks, any help would be appreciated.

 

[interpim]

are you closing the if ($time) and for loops?...

[dolcezza]

yes...

for ($loop=1;$loop<=3;$loop++) {
$time = $_POST['time-'.$loop];
if ($time) {
    $scheduleinsert = "INSERT INTO schedules (eventid, time, grades, room, notes) VALUES ('$eventid', '$time', '$grades', '$room', '$notes')";
    $schedule_result=mysql_query($scheduleinsert);

}

}

[marcus]

<?php

for ($i = 1; $i <= 3; $i++) {
    $time = $_POST['time-' . $i];

    if ($time) {
        $scheduleinsert = "INSERT INTO `schedules` (`eventid`, `time`, `grades`, `room`, `notes`) VALUES ('" .
            $eventid . "', '" . $time . "', '" . $grades . "', '" . $room . "', '" . $notes .
            "')";
        $schedule_result = mysql_query($scheduleinsert);
    }
}

?>

 

Just make sure you have the other variables defined.

[dolcezza]

I changed it to the following, realizing I had to add the loop part to those variables too, but I'm still getting the same thing.

It says parse error: expecting T_string or T_variable or T_NUM_STRING on line 21

 

for ($i = 1; $i <= 3; $i++) {
    $time = $_POST['time-' . $i];
    $grades = $_POST['grades-' . $i];
    $room = $_POST['room-' . $i];
    $notes = $_POST['notes-' . $i];
if ($time) {
        $scheduleinsert = "INSERT INTO `schedules` (`eventid`, `time`, `grades`, `room`, `notes`) VALUES ('" .
            $eventid . "', '" . $time . "', '" . $grades . "', '" . $room . "', '" . $notes .
            "')";
        $schedule_result = mysql_query($scheduleinsert);
    }
}

[Ken2k7]

Where's line 21?

[dolcezza]

line 21 is the "the if (time) {"