Hi
I wrote the code in attachment and it works quite well. It can be viewed live here. It merely goes to a lookup table, and pulls some pre-determined values for Salute and puts them in a drop down box.
One of my students used it as template, and it returns a bunch of errors - echoing code, rather than values. The result of that can be seen here.
I've analysed it, and can't see anything that resembles an error. She is trying to pull the values of reviewer name from another table (reviewer) and place the selected value for reviewerid into the table she's updating.
The code is below.
<form enctype="multipart/form-data" method="post" action="add_reviewparts.php">
<td>
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<!---------------------------------------------------->
<tr>
<td width="117">firstname</td>
<td width="14">:</td>
<td width="357">
<?php
require ("dbcnx.php");
$get_type = mysql_query("SELECT reviewerid, firstname FROM reviewer");
/* create form containing selection list */
echo"<select name='reviewerid'>";
while ($row = mysql_fetch_array($get_type))
{
extract($row);
echo '<option value="'.$row['firstname'].'" >'.$row['firstname'].'</option>';
}
echo "</select>";
?>
</td>
</tr>
<!---------------------------------------------------->
</tr>
<tr>
<td width="117">starrating</td>
<td width="14">:</td>
<td width="357"><input name="starrating" type="text" id="type" size="5" /></td>
</tr>
<tr>
<td width="117">reviewtitle</td>
<td width="14">:</td>
<td width="357"><input name="reviewtitle" type="text" id="type" size="25" /></td>
</tr>
I'd prefer to continue with this "way of doing it" - other advice suggested I go with PDO. I'm on a time constraint, so I'd like to tidy up with what I know, rather than falling in a heap and running out of time.
I'd appreciate any advice you may be able to give.
Basil
traveller_drop2.html