j'imagine que cette question a ete pose plus d'une fois mais je vous serez gres de bien vouloir m'aider parceque la je suis sans issue. j'ai beau lire et relire les tuto de partout a se qui a attrait au requete sql je m'y perd totalement.
voici le liens de la page web ou sera l'engin de recherche.
http://www.scale24-25.com/kitDB-site.php
voici le code de la page
Code : Tout sélectionner
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>scale24-25.com</title>
</head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
<!--
.style4 {
font-size: 24px;
font-family: Blazed;
}
.style5 {
font-size: 14px;
font-family: Arial, Helvetica, sans-serif;
}
-->
</style>
</head>
<body>
<?php
// Make a MySQL Connection
mysql_connect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD) or die(mysql_error());
mysql_select_db(DB_DATABASE) or die(mysql_error());
?>
<p align="center"><img src="images/banners/banner.jpg" alt="banner" width="997" height="213" border="0" usemap="#Map" />
<map name="Map" id="Map">
<area shape="poly" coords="0,100,85,102,92,55,108,50,326,51,323,7,3,3" href="http://www.hobby-shop.qc.ca" alt="hobby-shop" />
<area shape="poly" coords="672,57,891,53,887,4,995,4,985,108,673,102" href="http://www.hobby-shop.qc.ca" alt="hobby-shop" />
<area shape="poly" coords="326,13,330,53,98,54,90,92,670,99,668,54,889,51,886,5" href="http://www.scale-auto-style.com" alt="" />
</map></p>
<p align="center" class="style4"><img src="images/design_web/kit_search.jpg" alt="kir-search" width="173" height="39" /></p>
<p align="center" class="style5">This section is to search if it is avaible or if it was. You can fill as many field as you want more you fill more accurate will be the result. Of course you will see in some drop down menu this mention " don't know ".<br />
we recomend you to make your search also using them because my knowledge is not as wide as I want and i have to admit i don't know everything. So if somebody know the missing information it will be appreciate to send it to me at this mail: <a href="mailto:[email protected]">[email protected]</a> thank's in advance for your help</p>
<table width="100%" border="0">
<tr>
<td width="47%" align="right"><?php // debut drop down ///
$sql = mysql_query("SELECT DISTINCT scale FROM kit ");
$options = '';
echo '<select scale="scale"><option>Scale</option>';
while($row = mysql_fetch_array($sql)) {
$thing = $row['scale'];
echo '<option>'.$thing.'</option>';
}
echo '</select>';
// fin dropdown ///?> </td>
<td width="6%">---------</td>
<td width="47%">this is the scale of the model</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align="right"><?php // debut drop down ///
$sql = mysql_query("SELECT DISTINCT manufacturer_kit FROM kit ORDER BY manufacturer_kit");
$options = '';
echo '<select manufacturer_kit="manufacturer_kit"><option>Kit manufacturer</option>';
while($row = mysql_fetch_array($sql)) {
$thing = $row['manufacturer_kit'];
echo '<option>'.$thing.'</option>';
}
echo '</select>';
// fin dropdown ///?> </td>
<td>---------</td>
<td>this is for the kit manufacturer</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align="right"><?php // debut drop down ///
$sql = mysql_query("SELECT DISTINCT manufacturer_reel FROM kit ORDER BY manufacturer_reel");
$options = '';
echo '<select manufacturer_reel="manufacturer_reel"><option>Reel manufacturer</option>';
while($row = mysql_fetch_array($sql)) {
$thing = $row['manufacturer_reel'];
echo '<option>'.$thing.'</option>';
}
echo '</select>';
// fin dropdown ///?>
<div align="right"></div></td>
<td>---------</td>
<td>this is for the reel manufacturer of the item</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align="right"><?php // debut drop down ///
$sql = mysql_query("SELECT DISTINCT engine_detail FROM kit ORDER BY engine_detail");
$options = '';
echo '<select engine_detail="engine_detail"><option><br />Engine detail</option>';
while($row = mysql_fetch_array($sql)) {
$thing = $row['engine_detail'];
echo '<option>'.$thing.'</option>';
}
echo '</select>';
// fin dropdown ///?>
<div align="right"></div></td>
<td>---------</td>
<td>this is if the kit include an engine</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align="right"><?php // debut drop down ///
$sql = mysql_query("SELECT DISTINCT year_prod_reel FROM kit ORDER BY year_prod_reel");
$options = '';
echo '<select year_prod_reel="year_prod_reell"><option>made in ... ( reel year )</option>';
while($row = mysql_fetch_array($sql)) {
$thing = $row['year_prod_reel'];
echo '<option>'.$thing.'</option>';
}
echo '</select>';
// fin dropdown ///?>
<div align="right"></div></td>
<td>---------</td>
<td>year of production of the reel item ( ex: mustang 1967 )</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td align="right"><form name="input" action="../kit_result.php" method="post">
<input type="text" name="manufacturer_kit" value="" size="40">
<br />
<input type="submit" value="Submit">
</form> </td>
<td>---------</td>
<td>type a keyword to make the search</td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td colspan="3"><div align="center">
<input type="submit" value="Submit">
</div></td>
</tr>
</table>
<p align="center" class="style5">Note: you can select one or more field to make your search. more field are filled more accurate will be the result.</p>
<p align="center" class="style5"> </p>
</body>
</html>
</body>
</html>1ere --- que dois-je mettre comme code a mon bouton submit exactement pour qu'il puissent me retourner les infos provenant de la base de donne. oui j'appel le fichier kit_result.php mais que dois je metrre a l'interieur de celui-ci.
j'aimerais bien avoir un exemple concret qui s'applique a mon probleme.
ex: si un usager selection 1/24 et honda puis clic sur sybmit. cela lui retournera tout se qu'il y a dans dans la base de donne qui est 1/24 sous la collone echelle et tout se qui sera honda dans la collone manufacturier.
votre aide serais grandements apprecier.
sincerement votre
sebastien lebeau