|
Posted by Jim S on 07/13/06 13:24
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>";
?>
Navigation:
[Reply to this message]
|