Code: Select all
UPDATE schedule SET schedule.jakes = schedule_default.jakes WHERE schedule.date = '$newDatesArray[$i]' AND schedule_default.ID = '5'Moderator: General Moderators
Code: Select all
UPDATE schedule SET schedule.jakes = schedule_default.jakes WHERE schedule.date = '$newDatesArray[$i]' AND schedule_default.ID = '5'Code: Select all
$sql = "UPDATE schedule SET schedule.jakes = schedule_default.jakes WHERE schedule.date = '{$newDatesArray[$i]}' AND schedule_default.ID = '5'";Code: Select all
$queryLastDateArray = "SELECT date FROM schedule ORDER BY ID DESC LIMIT 1";
$lastDateArray = mysql_query($queryLastDateArray);
while($row = mysql_fetch_array($lastDateArray))
{
$lastDate = $row['date'];
}
$lastDatePlusOne = date("Y-m-d", strtotime("+1 day", strtotime($lastDate)));
$newDatesArray = GetDays($lastDatePlusOne, $_POST[date]);
$i = 0;
while($i < count($newDatesArray))
{
if ((date('D', strtotime($newDatesArray[$i]))) == 'Fri')
{
$insDate = "INSERT INTO schedule (date) VALUES ('$newDatesArray[$i]')";
$result = mysql_query($insDate);
$insEmp = "UPDATE schedule SET schedule.jakes = schedule_default.jakes FROM schedule, schedule_default WHERE schedule.date = '$newDatesArray[$i]' AND schedule_default.ID = '5'";
$result2 = mysql_query($insEmp);
}
$i++;
}
Code: Select all
$queryLastDateArray = "SELECT date FROM schedule ORDER BY ID DESC LIMIT 1";
$lastDateArray = mysql_query($queryLastDateArray);
if (!mysql_errno($lastDateArray)) {
while($row = mysql_fetch_array($lastDateArray))
...
} else {
$error_message = mysql_error($lastDateArray);
}