I have a dropdown menu populated by MySQL database, when clicked however it misses some of the database entries. This is the code for the drop down.
$sql = "SELECT distinct Make from stock";
$rsSelect = mysql_query($sql);
print "<FORM ACTION=\"result.php\">";
echo("<select name='Make'>");
echo("<option selected value=''>Make </option>");
while($row = mysql_fetch_array($rsSelect)) {
echo("<option value='".$row["Make"]."'>".$row["Make"]."</option>");
}
print "</select>";
print "<INPUT TYPE=\"SUBMIT\" VALUE=\"Test\">";
print "</FORM>";
And this is the code for the results.
// including the navbar class
include("./navbar.php");
// initiate it!
$nav = new navbar;
// set how many records to show at a time
$nav->numrowsperpage = 8;
$sql = "SELECT * FROM stock
WHERE Make = '$Make' ORDER BY Price DESC";
// the third parameter of execute() is optional
$result = $nav->execute($sql, $db, "mysql");
// handle the returned result set
$rows = mysql_num_rows($result);
for ($y = 0; $y < $rows; $y++) {
$data = mysql_fetch_object($result);
echo $data->url . "<br>\n";
if($myrow = mysql_fetch_array($result))
{
echo "<table border=1 align=center bgcolor=#330099 font color=##FFFFFF bordercolor=#000000>\n";
echo "<tr><td><bgcolor=#000000> <div align=center><font color=#FFFFFF font face=Arial Black size=+1><i>VRM</i></td><td><div align=center><font color=#FFFFFF font face=Arial Black size=+1><i>Make</i></td><td><div align=center><font color=#FFFFFF font face=Arial Black size=+1><i>Model</i></td><td>
<div align=center><font color=#FFFFFF font face=Arial Black size=+1><i>Body</i></td><td><div align=center><font color=#FFFFFF font face=Arial Black size=+1><i>Doors</i></td><td><div align=center><font color=#FFFFFF font face=Arial Black size=+1><i>Gearbox</i></td><td><div align=center><font color=#FFFFFF font face=Arial Black size=+1><i>Miles</i></td><td><div align=center><font color=#FFFFFF font face=Arial Black size=+1><i>Colour</i></td><td><div align=center><font color=#FFFFFF font face=Arial Black size=+1>
<i>Year</i></td><td><div align=center><font color=#FFFFFF font face=Arial Black size=+1><i>Price</i></td><td><div align=center><font color=#FFFFFF font face=Arial Black size=+1><i>More Info</i></td></tr>\n";
do {
printf("<tr><td><div align=center><bgcolor=#ffffff><font color=#ffffff>%s</td><td><div align=center><font color=#ffffff>%s</td><td><div align=center><font color=#ffffff>%s</td><td><div align=center><font color=#ffffff>%s</td><td><div align=center><font color=#ffffff>%s</td><td><div align=center><font color=#ffffff>%s</td><td><div align=center><font color=#ffffff>%s</td><td>
<div align=center><font color=#ffffff>%s</td><td><div align=center><font color=#ffffff>%s</td><td><div align=center><font color=#ffffff>%s</td><td><div align=center><font color=#ffffff><a href=javascript:popUp('search2.php?ID=$myrow[ID]','Details','Height=300,Width=341')>Details</a></td></tr>\n", $myrow[VRM], $myrow[Make], $myrow[Model],$myrow[Body], $myrow[Doors], $myrow[Gearbox], $myrow[Miles], $myrow[Colour], $myrow[Year], $myrow[Price], $myrow[Photo]);
}
while ($myrow = mysql_fetch_array($result));
echo "</table>\n";
}
else {
}
}
echo "<hr>\n";
// build the returned array of navigation links
$links = $nav->getlinks("all", "on");
for ($y = 0; $y < count($links); $y++) {
echo $links[$y] . " ";
}
Any reasons why its missing them ?
Nick Smith
