default select value from mysql query in dropdown box

Question

You guys have been patient with me and very helpful so far, so I'll try another one. I have looked around on here and tried many different options of select="selected" and I just can't get the code right or something, a simple fix I'm sure for you guys. What I'm trying to do is have a drop down list that is populated from a table of countries, default to the United States. Here is the code:

<select name="cnt" id="">
<option value="">Select</option>
<?php
$rescnt=mysql_query("select * from `country` ORDER by cnt_name ASC");
while($rowcnt=mysql_fetch_array($rescnt)) {
?>
<option value="<?php echo $rowcnt['cnt_id']; ?>"><?php echo $rowcnt['cnt_name']; ?></option>
<?php } ?>
</select>

you haven't got the selected attribute printed anywhere in the example above. — kalpaitch
– kalpaitch, Commented Mar 9, 2013 at 15:07
You are using an obsolete database API and should use a modern replacement. — Quentin
– Quentin, Commented Mar 10, 2013 at 21:46

kainaw · Accepted Answer · 2013-03-10 21:44:48Z

1

Assuming the cnt_id for the United States is 'US', the option line should be:

<option value='<?php echo $rowcnt['cnt_id']; ?>'<?php if($rowcnt['cnt_id']=='US') echo ' selected'; ?>><?php echo...

edited Mar 10, 2013 at 21:44

answered Mar 9, 2013 at 15:08

kainaw

4,3621 gold badge23 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tony Crouch Over a year ago

I tried this but I get this error: Parse error: syntax error, unexpected T_VARIABLE, expecting '(' in /home/content/44/10329144/html/admin/additem.php on line 258

kainaw Over a year ago

I added parenthesis around the if clause. I assume that is what caused the error. Without knowing what is on line 258, it is hard to tell.

Collectives™ on Stack Overflow

default select value from mysql query in dropdown box

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related