Want To Load Mysql Table Data In Combo Box In Php

[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>";
?>