In a jam...Need Help with simple php script

[kuau]

I figured it out, thanks.

[Nile]

Please post your solution.

[kuau]

I don't really know what I am doing in php, but this did what I wanted it to do.


<?php

include ('db-connectdb.php');

$query = " SELECT id FROM `events` where id > 570 ";

$dateList = array();

while ($row = mysql_fetch_array($result))
{
$date = array();

$id = $row['id' ];

$query = " SELECT id, StartDate, StartTime, PublishDate
FROM `events`
WHERE id = $id ";

$result2 = @mysql_query($query,$connection) or die("Couldn't execute $query query.");
$row2 = mysql_fetch_array($result2);

$id = $row2['id' ];
$StartDate = $row2['StartDate' ];
$StartTime = $row2['StartTime' ];
$PublishDate = $row2['PublishDate'];

$query = "UPDATE `eventsnew` SET StartDate = '$StartDate', StartTime = '$StartTime', PublishDate = '$PublishDate' WHERE id = '$id' ";

$result3 = @mysql_query($query,$connection) or die("Couldn't execute $query query.");

mysql_free_result($result2);
unset($row2);

array_push($dateList, $date);

}
?>