|
Posted by shubeer on 07/13/06 19:15
> I have made the two changes you suggested but am still not receiving a
> result set. Let me repost my modified code.
>
> <?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; $row=mysql_fetch_row($res); $i++)
> {
> echo "<option value='$row[0]'>$row[0]</option>";
> }
> echo "</select>";
> ?>
Hi,
Here's how I would have written the code to build the select box:
<?php
$res=mysql_query("SELECT DISTINCT job_name AS JOB_NAME FROM
oats_jobs_users_laborCode where user='$username' order by job_name") or
die('Query failed');
echo "<select name='jobname'><option SELECTED='SELECTED'>Choose
One</option>";
foreach($row as mysql_fetch_assoc($res)) {
echo "<option value='{$row[JOB_NAME]}'>{$row[JOB_NAME]}</option>";
}
echo "</select>";
?>
also, make sure that the $username variable doesn't have a quote (') in
it or the query will fail
regards,
shubeer
Navigation:
[Reply to this message]
|