while inside a while

[Jarod]

I am trying to echo out all of the news headlines and then all of the numbers assosiating with the news which would be news order.

Here is anexaple of what i mean.
http://www.tjshafer.com/baintown/admin/news/newsorder.php
I cant seem to get this to work. Please help.

$connection = mysql_connect($server, $user, $password) or die("Couldn't Connect.");
$db = mysql_select_db($dbname, $connection) or die("Couldnt select database.");
$result = mysql_query("SELECT title, newsorder,id FROM news") or die("Couldn't ececute query.");
$result1 = mysql_query("SELECT title, newsorder,id FROM news") or die("Couldn't ececute query.");
?>
<table border="0" cellspacing="0" cellpadding="0" width="550">
<TR><TD>
<form action='newsorder.php' method='post'>
<INPUT TYPE="hidden" NAME="mode" VALUE="update">
Please select a News Order<br>
<?
while ($row = mysql_fetch_array($result)){
echo"$row[title]";?>
<select name="newsorder">
<?
while ($row = mysql_fetch_array($result1)){
echo "<option value='$row[id]'>$row[newsorder]</option>";

				}?>

</select><br><?}