Javascript/PHP: Script to set selected <SELECT> option not working

Question

I have a select statement running which pulls data into $row.

$result = mysql_query("Select * FROM Recipes WHERE rID = $sent_rID");   
$fields_num = mysql_num_fields($result);
$error = mysql_error($link);
$row = mysql_fetch_array($result);

Next I have my SELECT block

<select name='department' id='department'>
<option value='Deli'>Deli</option>
<option value='Meat'>Meat</option>
<option value='Seafood'>Seafood</option>
</select>

Finally I have the following SCRIPT block

<SCRIPT LANGUAGE='javascript'>
DepartmentSelect($row[rDepartment]);
</SCRIPT>

And here is DepartmentSelect()

<script type="text/javascript">
function DepartmentSelect(itemToSelect)
{
// Get a reference to the drop-down
var myDropdownList = document.inputForm.department;

// Loop through all the items
for (iLoop = 0; iLoop< myDropdownList.options.length; iLoop++)
{    
    if (myDropdownList.options[iLoop].value == itemToSelect)
     {
       // Item is found. Set its selected property, and exit the loop
       myDropdownList.options[iLoop].selected = true;
       break;
     }
 }
}
</script>

I have verified multiple times that all of the values are good, but for some reason the combobox refuses to show the right value. Any ideas?

Edit: The SCRIPT block occurs within a php echo, so it is pulling the correct value.

Please don't use mysql_* functions in new code. They were removed from PHP 7.0.0 in 2015. Instead, use prepared statements via PDO or MySQLi. See Why shouldn't I use mysql_* functions in PHP? for more information. — Madara's Ghost
– Madara's Ghost, Commented Jun 13, 2012 at 19:11
Thanks for the information! I'll certainly look into it and update as soon as possible. — Justin Mathieu
– Justin Mathieu, Commented Jun 13, 2012 at 19:29

Brandon Ryall-Ortiz · Accepted Answer · 2012-06-13 19:29:25Z

1

You need to add quotes.

Your code would output:

DepartmentSelect(Deli)

Rather do this:

<SCRIPT LANGUAGE='javascript'>
DepartmentSelect('<?=$row["rDepartment"];?>');
</SCRIPT>

answered Jun 13, 2012 at 19:29

Brandon Ryall-Ortiz

706 bronze badges

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

1 Comment

Justin Mathieu Over a year ago

Worked! Everything was in an echo block already, but throwing apostrophe's around $row[rDepartment] made all the difference.

mgraph · Accepted Answer · 2012-06-13 19:10:35Z

0

try:

<SCRIPT LANGUAGE='javascript'>
DepartmentSelect(<?php echo $row[rDepartment]; ?>);
</SCRIPT>

or:

<SCRIPT LANGUAGE='javascript'>
DepartmentSelect(<?php echo $row["rDepartment"]; ?>);
</SCRIPT>

answered Jun 13, 2012 at 19:10

mgraph

15.3k4 gold badges43 silver badges76 bronze badges

1 Comment

Justin Mathieu Over a year ago

Ah sorry, I should have added that this the script block occurs within a php echo, so it is pulling the correct value.

Collectives™ on Stack Overflow

Javascript/PHP: Script to set selected <SELECT> option not working

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related