listbox population problem

[jaxxstorm]

I'm new to PHP, and creating a form with a listbox that is populated from a mySQL table.
I know this is fairly common, but I'm having a problem getting the listbox to populate;
Here is the code I'm using
Database connection php

<?php
$dbServer="localhost";
$username="username";
$password="password";
$database="database";
//make database connection
$conn = mysql_connect($dbServer,$username,$password);
@mysql_select_db("$database") or die("unable to select database".mysql_error());
*
?>

Listbox code

<label>Resource Required
<select name="Resource">
<option value=>--Select--</option>
<?
//get records from database(table resource)
$list=mysql_query("SELECT * FROM Resource");
*
//show records by while loop
while($row_list=mysql_fetch_array($list))
?>
<optionvalue="<? echo $row_list[Res_ID]; ?>" </option>
</select>
*

The select option is appearing with no problems, but the listbox isn't populating with the information from the database, can anybody see the problem?

[Kudose]

<?
//get records from database(table resource)
$list=mysql_query("SELECT * FROM Resource");

//show records by while loop
while($row_list=mysql_fetch_array($list)){
?>
<optionvalue="<? echo $row_list['Res_ID']; ?>" </option>
<?php } ?>
</select>

Also, you should only query and return the columns you anticipate using. Selecting everything from Resource when you only need Res_ID is wasteful.

[NogDog]

Perhaps your system does not have short open tags enabled? Try using "<?php" instead of "<?" throughout.