1 reply to this topic

[saravanataee]

Dear all,
I am trying to load form data mysql table data into a combo box in php. for example i have a table called "item" and it has two fields name itemno, itemname. Each has values entered already. Now, in my form i want to have a combo box which holds the itemname field value from database table item.

I tried with the below method. But it throws me this error "( ! ) Parse error: syntax error, unexpected T_VARIABLE in C:\wamp\www\PO\index.php on line 63"

Can anyone help me to resolve this!!


<?php

$sql="select itemno from item"
$q=mysql_query($sql)
echo "<select name=\"test\">";
echo "<option size =30 ></option>";
while($row = mysql_fetch_array($q))
{
echo "<option value='".$row['itemno']."'>".$row['itemno']."</option>";
}
echo "</select>";
?>

[sowna]

seems you missing semicolon in the first two lines, please find below code which i have modified little

<?php
                  
$sql="select itemno,itemname from item";
$q=mysql_query($sql);
echo "<select name=\"test\">";
echo "<option size =30 ></option>";
while($row = mysql_fetch_array($q))
{     
echo "<option value='".$row['itemno']."'>".$row['itemname']."</option>";
}
echo "</select>";
?>