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);				
							
}
?>