[RESOLVED] Combo Box Default Vales

[bschwartz]

I have combo boxes on a form, much like the FONT and SIZE boxes in this form, and I'm not sure how to enter a default value for the combo box, and have the rest of the data pull from the database.

Here is what I have, and it pulls the data fine, but enters the first value into the combo box. And I want to say "Please select a Job Number"

if ($var_job = mysql_query($job_query)){
	while ($array_job = mysql_fetch_array($var_job) ) {
	echo '<option value="'.$array_job['Job_Number'].'">'.$array_job['Job_Number'].'</option>'.
	"\r\n";
 	}}

[mrbaseball34]

I kind of do it like this:

define ("NL", "\n");
echo '        <select name="visitteam" size="8">'.NL;
while (list($id, $teamname)=mysql_fetch_row($teamquery))
{
  $str = "<option value=\"$id\"";
  if ($visitteam==$id){ 
    $str = $str." selected";
  }
  $str = $str.">$teamname</option>".NL;
    echo $str;
}
echo "      </select>".NL;

[bschwartz]

I see what you're doing there and it makes sense, but I can't get it to work with my code. Could you give me any other suggestions?
Thanks!

[mrbaseball34]

You have to know what the default value that you want, correct?
Try this:

while ($array_job = mysql_fetch_array($job_query))
{
  $str = "<option value=\"$array_job['Job_Number']\"";
  if ($defaultvalue == $array_job['Job_Number']){ 
    $str = $str." selected";
  }
  $str = $str.">$array_job['Job_Number']</option>";
    echo $str;
}

[bschwartz]

I'm getting a Parse error on this line:

  $str = "<option value=\"$array_job['Job_Number']\"";

What simple thing am I missing? 😕

[mrbaseball34]

Try this:

while ($array_job = mysql_fetch_array($job_query))
{
  $str = '<option value=\"'.$array_job['Job_Number'].'\"';
  if ($defaultvalue == $array_job['Job_Number']){ 
    $str = $str.' selected';
  }
  $str = $str.'>'.$array_job['Job_Number'].'</option>';
    echo $str;
}

[bschwartz]

Well, I finally got it working how I wanted to, and just thought I'd share that with everyone else.

if ($var_job = mysql_query($job_query)) { 
  echo '<option value="">THIS IS THE DEFAULT DROP DOWN OPTION</option>'."\r\n";
    while ($array_job = mysql_fetch_array($var_job)) { 
    echo '<option value="'.$array_job['Job_Number'].'">'.$array_job['Job_Number'].'</option>'. "\r\n"; 
    }
} 

[laserlight]

Good to hear 🙂
Remember to mark this thread as resolved using the thread tools.