<html>
<head> <title></title> </head>
<body>
<?php $link = mysql_connect("localhost", "root", "maxime") or die ("Could not connect to MySQL");
mysql_select_db ("listesdeprix") or die ("Could not select database");
$query = "SELECT * FROM `bliferaft` ORDER BY `PartNumber`"; $result = mysql_query ($query) or die ("Query failed"); $i = 0; $v_PartNumber = mysql_result($result, $i,"PartNumber"); $v_Fabriquant = mysql_result($result, $i,"Fabriquant"); $v_NomModele = mysql_result($result, $i,"NomModele"); $v_Modele = mysql_result($result, $i,"Modele"); $v_Persons = mysql_result($result, $i,"Persons"); $v_Compart = mysql_result($result, $i,"Compart"); $v_Dimensions = mysql_result($result, $i,"Dimensions"); $v_Weight = mysql_result($result, $i,"Weight"); $v_DealerCost = mysql_result($result, $i,"DealerCost"); $v_GovtOem = mysql_result($result, $i,"GovtOem"); $v_X = mysql_result($result, $i,"X"); $v_Detail = mysql_result($result, $i,"Detail");
// printing HTML result
print "<table>\n"; while ($line = mysql_fetch_array($result)) { print "\t<tr>\n"; while(list($col_name, $col_value) = each($line)) { print "\t\t<td>$col_value</td>\n";
} print "\t</tr>\n"; } print "</table>\n";
?>
</body>
</html>
|