I could just do another query with a WHERE statement, but it seems like I shouldn't have to since I've already got the entire set.
Code: Select all
$event_query = "SELECT * FROM event";
$event_result = mysql_query($event_query)
or die ("Couldn't execute event query");
//display all rows
while ($event_row = mysql_fetch_array($event_result,MYSQL_ASSOC)) {
extract ($event_row);
echo "\$event_id: $event_id<br>
\$event_name: $event_name<br>";
}
//go back to first record in result set.
$new_event_row = mysql_data_seek($event_result,0);Thanks, Ruth