Challenge: MySql result to drop down box



I think I am just missing something silly. I have tested my query and
it seems to be functioning fine. I have another similar query that runs
just before this one so the issue isn't a connection. If you have any
other questions I'd be happy to answer them.

Platform: mysql 3.x, php5

<?php
$res=mysql_query("SELECT 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; $row=mysql_fetch_assoc($res); $i++)
{
echo "<option value='<? echo $row[0];?>'><? echo $row[0];?></option>";
}
echo "</select>";
?>
.



Relevant Pages

  • Re: tempdb grows to 8G suddenly
    ... that a join predicate is missing. ... >> to someone running a query which has a join that has not been qualified ... a huge result set gets built up (in tempdb ...
    (microsoft.public.sqlserver.server)
  • Re: RM formalism supporting partial information
    ... omniscient database. ... If the user formulates a query then this will now ... If the age or occupation is missing we could ... the value-does-not-apply interpretation can always also be ...
    (comp.databases.theory)
  • Re: Understanding How Access Sorts Records
    ... Best use a query to reorder ... incomplete records being entered and as it turns out, they are missing ... the value that I would be sorting on. ...
    (comp.databases.ms-access)
  • Re: Adding blank lines in a report
    ... table that tells Access about the missing numbers. ... Create a query that contains both this table and the table containing ... Drag tblCount.CountID into the output grid. ... and use it as the RecordSource for your report. ...
    (microsoft.public.access.reports)
  • Re: Confused by mysqli
    ... When I started using MySQL with Perl back in 1998, ... fetch_assocon a query I prepared with bind variables, ... So I had it print out its eval string that it was trying to run. ... PHP will fail to run at all, because bind_result will not have enough ...
    (comp.lang.php)