Mysql & Select Question -- Help needed
| From: | Jeff Lacy | Date: | Thu, 09 Nov 2000 06:30:05 +0000 |
| Subject: | Mysql & Select Question -- Help needed | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-24433@lists.php.net to get a copy of this message | ||
Hello World,
I have a search page that has a select on it and I would like to have the value with $age
selected on it. I don't know how to do this, though. I tried this, but it doesn't work.
Please tell me what I did wrong. Thank you so much everybody! :-)
if ($row_age = @mysql_fetch_array ($result_age))
{ do
{ $select_age .= "\t<option value=\"{$row_age["age_ix"]}\"";
if ($age == "{$row_age["age_ix"]}") { echo " selected"; } //
Problem Line?
$select_age .= ">{$row_age["age"]}\n";
} while($row_age = @mysql_fetch_array($result_age));
}
P.S. Does anyone know of the differences between SQL 7 and mysql? That would be very helpful.
Thanks again!