really annoying parse error

[jowatkins]

Can anyone spot the parse error here? I've looked and looked but can't see anything wrong with this.

$result = mysql_query("SELECT * FROM trialbasic");
$num_results = mysql_num_rows($result);
?>
<select name="chassis">
<option value ="">SELECT CHASSIS</option>
<?
for (i=0; i<$num_results; i++)
{
$row = mysql_fetch_object($result);
echo "<option value=\"$row->chassis\">$row->chassis</option>";
}
echo "</select>";

Thanks in advance

[mmilano]

it's in your "for" loop. you are not defining i as a variable

try this:

<?
for($i=0;$i<$num_results;$i++)
{
     $row = mysql_fetch_object($result); 
     echo "<option value=\"$row->chassis\">$row->chassis</option>"; 

}
?>

[jowatkins]

thanks, I knew it had to be simple, but couldn't see the wood for the trees.

[KoshNaranek]

Sorry it's german...

function kategorien_zeigen(){
    /** Liste der Hardwarekategorien (Typen) laden   **/
    $abfrageH="select * from HIS_Kategorien order by Kategorie;";
    $resultH=mysql_query($abfrageH);
    while ($row = mysql_fetch_object($resultH)){
    $Hid=$row->id;
    $Hkurz=$row->Kategorie;
    echo "<option value='$Hid'>$Hkurz</option>";
     }
}

---- so i can use it in all "actions" of my PHP-Code

...somewhere in the Code... maybe a FORM 😉

    <select name='kategorie'>
        <? kategorien_zeigen(); ?>
    </select></td>