<?php require_once('Connections/Model.php'); ?> <?php require_once('Connections/Model.php'); ?> <?php $Mod=$_GET["Model"]; ?> <?php mysql_select_db($database_Model, $Model); $query_Model = "SELECT model.Code_Model, model.Model FROM model"; $Model = mysql_query($query_Model, $Model) or die(mysql_error()); $row_Model = mysql_fetch_assoc($Model); $totalRows_Model = mysql_num_rows($Model); mysql_select_db($database_Model, $Model); $query_Recordset1 "SELECT finition.Code_Fin, finition.Fin, finition.Code_Mod FROM finition WHERE finition.Code_Mod ".$_GET["Model"]; $Recordset1 = mysql_query($query_Recordset1, $Model) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Document sans titre</title> </head> <form id="form1" name="form1" method="get" action="Motorisation.php"> Model <select name="Model" id="Model" onchange="text.value=this.options[Model.selectedIndex].value document.location.href='Finition.php?Model='+this.options[this.selectedIndex].value; "> <?php do { ?> <option value="<?php echo $row_Model['Code_Model']?>"<?php if (!(strcmp($row_Model['Code_Model'], "$Mod"))) {echo "selected="selected"";} ?>><?php echo $row_Model['Model']?></option> <?php } while ($row_Model = mysql_fetch_assoc($Model)); $rows = mysql_num_rows($Model); if($rows > 0) { mysql_data_seek($Model, 0); $row_Model = mysql_fetch_assoc($Model); } ?> </select> Finition <select name="select"> </select> Motorisation <select name="select2"> </select> </form> </html> <?php mysql_free_result($Model); mysql_free_result($Recordset1); ?>
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question