I’m trying to make a selection list where they would pick the type of model they want and that goes into the query and would come up on the page, now the form is just there and nothing happens ? Here is the code I have.
$query = “SELECT * FROM ALL_ITEMS where carmodel=’$carmodel’”;
$result = mysql_query($query)
or die (“Couldn’t execute query.”);
/* Display results in a table */
echo "
n";
echo “Civic”;
echo “Accord”;
echo “n”;
while ($row = mysql_fetch_array($result))
{
extract($row);
echo “$carmodeln”;
}
echo “n”;
echo "
n";
echo "<font size=‘10’color=’#000080’ face=‘Monotype Corsiva’>All Honda’s
";
echo “
| <font size=‘4’color=’#000080’>Cars/Autos | <font size=‘4’color=’#000080’>Trucks/Camions | Boats/Bateaux | Motorcycles/Motocyclettes | ";
| <font size=‘4’color=’#000080’>RV’s/Roulottes | <font size=‘4’color=’#000080’>Houses/Maisons | ATV's | Vans/Fourgonettes | ";
echo “<table cellspacing='5’border=‘0’>”;
echo “
while ($row = mysql_fetch_array($result))
{
extract($row);
echo "
<td width='10%'valign='top'><b>ID:$ID</b></td>n
<td width='25%'><a HREF='http://www.privatesalenb.com/images/$PICS' ><img src='/images/$PICS' width='200'height='140'></a> </td>n
<td valign='top' width='55%'><b>Model: $CARMODEL </b><br> $DESCRIPTION</td>n
</tr>n";
echo "<tr><td colspan='4'><hr></td></tr>n";
}
echo “n”;
?>
