Do you get a selection at all? A select-tag should, in xhtml (that i think
everyone should use), look like this:
<select size='1' name='mySelect'>
<option value='0' selected='selected'>First object</option>
<option value='1'>Second Object</option>
...
<option value='n'>n Object</option>
</select>
I usually use mysql_fetch_object like this:
<?php
$question = "SELECT * FROM fp_kat ORDER BY kat_name";
$result = mysql_query($question, $link_id);
echo("<select size='1' name='kat'>\n");
while ($fp_kat = mysql_fetch_object($result)) {
if ($fp_kat->kat_id == $id) {
echo("\t<option value='".$fp_kat->kat_id."'
selected='selected'>".$fp_kat->kat_name."</option>\n");
}
else {
echo("\t<option
value='".$fp_kat->kat_id."'>".$fp_kat->kat_name."</option>\n");
}
echo("</select>\n");
?>
also; have you checked that $id holds the right value? And that it is of the
same type in both the db and in the php code?
. bobo . www.elstudion.com . www.elstudion.com/bobo/ .
"Anthony Judd" <[EMAIL PROTECTED]> skrev i meddelandet
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> i have also tried:
>
> function retrieve_category()
> {
> $cat = mysql_query("SELECT category_id FROM category");
> while ($current_row = mysql_fetch_row($cat))
> {
> $row = $current_row[0]; //changed here
> if ($row == $id)
> {
> printf("<option selected>%s</option>\n",$current_row[0]);
> }
> else
> {
> printf("<option>%s</option>\n",$current_row[0]);
> }
> }
> }
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
