Re: Challenge: MySql result to drop down box

"Jim S" <try@xxxxxxxx> wrote in message news:U7utg.17$OI5.7@xxxxxxxxxxx
I think I have narrowed it down to the for loop causing the problem...

Jim S wrote:
I have made the two changes you suggested but am still not receiving a
result set. Let me repost my modified code.

Try:

<?php
$res=mysql_query("SELECT DISTINCT job_name FROM
oats_jobs_users_laborCode where user='$username' order by job_name");
echo "<select name=jobname> <option default='default'>Choose
One</option>";
for ($i=0; $i <= mysql_num_rows(); $i++)
{
$row=mysql_fetch_assoc($res);
echo "<option value='$row[job_name]'>$row[job_name]</option>";
}
echo "</select>";
?>

or

<?php
$res=mysql_query("SELECT DISTINCT job_name FROM
oats_jobs_users_laborCode where user='$username' order by job_name");
echo "<select name=jobname> <option default='default'>Choose
One</option>";
while($row=mysql_fetch_assoc($res))
{
echo "<option value='$row[job_name]'>$row[job_name]</option>";
}
echo "</select>";
?>

also:

mysql_fetch_row($res) = [0] numerical indicies
mysql_fetch_assoc($res) = ['job_name'] alphanumeric indicies
mysql_fetch_array($res, type) where type is MYSQL_NUM ([0]), MYSQL_ASSOC
(['job_name']), or MYSQL_BOTH ([0] & ['job_name'])

Norm


.

Relevant Pages

  • Re: [PHP] ZIP it :o)
    ... This is Christian Haensel live from Extertal, ... and in the archives). ... I had same problem lately, wanted also to create zip files from PHP, i ... Jim Lucas ...
    (php.general)
  • [SLE] Re: Konqueror / PHP question...
    ... On Saturday 04 December 2004 20:40, Sunny wrote: ... >> When I try to open a php file in konqueror I get the script. ... >> JIM ...
    (SuSE)
  • Re: Has anyone used Form Processor Pro from MitriDAT?
    ... Microsoft MVP-FrontPage ... -- "Jim Holtan" wrote in message ... > I'm a non-PHP person on a PHP enabled server, so I'm looking for a tool that> will deal with the PHP portion. ... >> Steve Easton ...
    (microsoft.public.frontpage.programming)
  • Re: Challenge: MySql result to drop down box
    ... Let me repost my modified code. ...
    (alt.php)
  • Re: [PHP] OOP in PHP
    ... You've solved my problem, Jim. ... superclass koneksi dipanggil ... "Some men are born to greatness, some achieve greatness, ...
    (php.general)