OnChange is Javascript. I might suggest you get yourself familiar with JQuery. JQuery makes your life a lot easier when there is a need for client browser interaction with site scripting. Richard L. Buskirk From: Tomás Corrales Lemoine [mailto:tomas@xxxxxxxxxxxxxxxxxxxx] Sent: Thursday, November 04, 2010 4:23 PM To: php-general@xxxxxxxxxxxxx Subject: How to code in PHP an onchange event in a <select>? Hi, List, I have this two files (?index.php? and ?include.php?). They both work fine, but I want to substitute the code for de onchange event in the <select> tag. Can I use PHP to code this event? How? Thanks. index.php: <?php echo '<html><body>'; include_once 'include.php'; $mysql_link = tcl_MySQL_ConnectToServer('localhost', 'user', 'password'); tcl_MySQL_OpenDataBase($mysql_link, 'production'); $query = 'SELECT DISTINCT recipe.product_id, product.description FROM recipe, product WHERE recipe.product_id = product.product_id ORDER BY product.description'; $result = tcl_MySQL_DataQuery($mysql_link, $query); tcl_FillComboBox($result, 'Product', 'product_id', 'description', 'alert(\'Alert Message\')'); tcl_MySQL_CloseConnection($mysql_link); echo '</body></html>'; ?> include.php: <?php function tcl_MySQL_CloseConnection($link) { mysql_close($link); } function tcl_MySQL_ConnectToServer($host, $user, $password) { $link = mysql_connect($host, $user, $password); if (!$link) { die('No se pudo conectar: '.mysql_error()); } echo '<h3>User '.strtoupper($user).' connected to MySQL server.</h3>'; return $link; } function tcl_MySQL_DataQuery($link, $query) { return mysql_query($query, $link); } function tcl_MySQL_OpenDataBase($link, $database) { mysql_select_db($database, $link); } function tcl_FillComboBox($result, $label, $col1, $col2, $onchange) { echo '<label>'.$label.'</label><select onchange="'.$onchange.'"><option value="">'; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo '<option value="'.$line[$col1].'">'.$line[$col2]; } echo '</select>'; } ?> -- Aeropuerto Internacional Frank País García de Holguín.
