For some reason, I’m not getting the first row from any selection. I even verified it in PHPMyAdmin and ran the query there; it returned all the correct rows. It’s only when I run the script on a page that the first row doesn’t get returned. Anyone know why? Could it be the mysql_fetch_array ?
Here’s my script:
[CODE]
mysql_connect(“”, “”, “”) or die(mysql_error());
mysql_select_db(“DBNAME”) or die(mysql_error());
$result = mysql_query(“select * from cars where(model='”.$_POST[‘model’].”‘)”) or die(mysql_error());
$row = mysql_fetch_array( $result );
echo ‘<select>’;
while($row = mysql_fetch_array($result)){
echo “<option>”.$row[‘Trim’].”</option>”;
}
echo ‘</select>’;
Thanks for any help you may have.