Jump to content


Photo

Want To Load Mysql Table Data In Combo Box In Php


  • Please log in to reply
1 reply to this topic

#1 saravanataee

saravanataee

    Member

  • Members
  • PipPip
  • 25 posts

Posted 29 December 2012 - 03:04 AM

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

#2 sowna

sowna

    Member

  • Members
  • PipPip
  • 29 posts

Posted 29 December 2012 - 04:59 AM

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





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com