focus a <select> option dinamically

[joangarnet]

Hi everybody!

I have a script that edits some information from mysql in a form .to then update or delete it.
One of the text fields is a <select> (loaded dynamically) and I want to focus on a specific value of the list.
I know theres a way to achieve it with javascript, but maybe you can tell me a better way with php.

I show you the code:

---

<select name="id_instrum_edit" class="caja_admin">
<option value="nada">Select if necessary</option>
<?php
$db=mysql_connect($server,$login,$pass);

mysql_select_db($bbdd,$db);
$sql_cat= "SELECT * from ".$table4." ORDER BY 'id_sampler'";
$result_cat=mysql_query($sql_cat);
while($row=mysql_fetch_array($result_cat)){
echo"<option value='".$row["id_sampler"]."'>".$row["nombre"]."</option>";
}
echo"</select><p>";

---

Thank you!
🙂

[Anon]

hey Joan,

on which one do you want to focus ? I could tell you how to do it in HTML with PHP (to generate the html-code). But please tell which entry should be selected.

regards ali

[sgs-techie]

well .... assuming the value u want to focus is in a variable $focus_val , the code will go like this :

-----prev code as such ------
while($row=mysql_fetch_array($result_cat)){
echo"<option value='".$row["id_sampler"]."'";
//here comes the change
if($row["id_sampler"]==$focus_val ) echo " selected";
echo ">".$row["nombre"]."</option>";
}

Hope this helps u !!!

[joangarnet]

I'm sorry,
As you said I wanted to focus in a variable, so I think the code you've just written is exactly what I was looking for
🙂
ThanX ali
ThanX SGS