<html>
<head></head>
<body>
<?php
$hostname="localhost";
$username="jesus_jesus";
$password="jesus";
$dbid="jesus_jesus";
$link=mysql_connect($hostname,$username,$password);
mysql_select_db($dbid) or die("unable to connect");
$result=mysql_query("select jid,industrytype from career");
if($result)
{
echo '<select>';
while($myrow = mysql_fetch_array($result))
{
echo '<option value="',$myrow['$industrytype'],'"></option>';
}
echo "</select>";
}
?>
</body>
</html>in this code i'm getting only the listbox.not to able to retrive the data from the database..
i'm having two column jobid and industrytype in the table career.i want to display the industry type in listbox.
Problem:
in this code i'm getting only the listbox.not to able to retrive the data from the database..
