WHILE

[Anon]

When i see the form i see the last in the databse, Any ideas why

$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";
$result =@($sql,$connection) or die("Couldn't ececute query.");
while ($row = mysql_fetch_array($result)) {
$id = $row['id'];
$topic = $row['topic'];
$date = $row['date'];
$option_block = "<option value='$id'>$date, $topic</option>";
}
$display_text="<form name='form1' method='post' action='update.php?page=edit'>
<p><strong>Please Choose a event to Update</strong>
<select name='id'>
$option_block
</select><br>
<input type='submit' name='Submit' value='Submit'></p>
</form>";
}

[jburfield]

Yeah, your 'while' statement ends before you print anything out. You have a "}" between "$option_block = ...."
and
"$display_text=...."

-- Jason

[Anon]

I tried that and it still diddnt work I get the same thing.

$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";
$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="<form name='form1' method='post' action='update.php?page=edit'>
<p><strong>Please Choose a event to Update</strong>
<select name='$id'>
<option value='$id'>$date, $topic</option>
</select><br>
<input type='submit' name='Submit' value='Submit'></p>
</form>";
}

Any other ideas.