display the data into listbox

•

What is DaniWeb IT Discussion Community?

You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 423,531 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,324 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Thread Tools Display Modes

Views: 1061 | Replies: 2

•

Join Date: Nov 2007

Posts: 96

Reputation: kings is an unknown quantity at this point

Rep Power: 1

Solved Threads: 2

kings

Offline

Junior Poster in Training

display the data into listbox

Feb 29th, 2008

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<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>
<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..

Last edited by MattEvans : Feb 29th, 2008 at 4:54 am. Reason: Added code tags

•

Join Date: Nov 2007

Location: Bangalore, India

Posts: 3,098

Reputation: nav33n has a spectacular aura about

Rep Power: 8

Solved Threads: 240

nav33n

Offline

Posting Sensei

Re: display the data into listbox

Feb 29th, 2008

You are getting the listbox and the values but you can see it, because you don't have the value between <option></option>.
Ie.,

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
echo '<option value='.$myrow['$industrytype'].'>'.$myrow['$industrytype'].'</option>';
echo '<option value='.$myrow['$industrytype'].'>'.$myrow['$industrytype'].'</option>';

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.

*PM asking for help will be ignored*