Re: Challenge: MySql result to drop down box

shubeer wrote:
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>";


Which will give an E_NOTICE error.
Use {$row['JOB_NAME']}.

also, make sure that the $username variable doesn't have a quote (')
in it or the query will fail


Yup, mysql_real_escape_string() it.

Grtz,
--
Rik Wasmus


.

Relevant Pages