I am trying to select a event to delete. I only come up with the last one. Here is my code. Why isnt it working?
$connection = @mysql_connect("$server", "$user", "$password") or die("Couldn't Connect.");
$db = @mysql_select_db(primcpt_content, $connection) or die("Couldnt select database.");
$sql = "SELECT * FROM events ORDER by id";
$result =@($sql,$connection) or die("Couldn't ececute query.");
while ($row = mysql_fetch_array($result)) {
$id = $row['id'];
$topic = $row['topic'];
$date = $row['date'];
$display_text="<strong>Please Choose a event to delete</strong> <br>
<a href='d_up_events.php?page=sure&id=$id'>$id: $date<br>
$topic</a>";
}
Thanks in advance 🙂l
