Challenge: MySql result to drop down box
- From: Jim S <try@xxxxxxxx>
- Date: Thu, 13 Jul 2006 09:24:13 -0400
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) |
|