Hi there!
I have a small problem.
I have search page where user can find snowboards with manufacter or model...or both.
My problem is with search result. Searchresult works fine if user select manufacter AND model but if user select only the manufacter, then the searchresult returns empty page. If user select only the manufacter it should return all the models with selected manufacter. And if user don's select anything it should return all the snowbaords in database.
You can try the search at:
Here is my resultpage PHP code:
<?php
$db = mysql_connect("host", "username", "password");
mysql_select_db("lumilaudat",$db);
print "Manufacter(s) you select:<br>";
for($i=0;$i<count($manufacter);$i++){
print "$manufacter[$i]<br>";
}
print "<br>You select following models:<br>";
for($e=0;$e<count($model);$e++){
list($board, $boardmodel) = split( '[_]', $model[$e]);
print "$board, $boardmodel<br>";
}
if ($id) {
$result = mysql_query("SELECT * FROM laudat WHERE id=$id",$db);
$myrow = mysql_fetch_array($result);
printf("<TABLE CELLPADDING=2 CELLSPACING=2 border=1><tr><td><b><font color=black face=verdana size=2>Manufacter:</b></td><td><font color=black face=verdana size=2>%s<br></td><td rowspan=11>%s</td></tr>", $myrow["Merkki"], $myrow["kuva"]);
printf("<td><b><font color=black face=verdana size=2>Model:</b></td><td><font color=black face=verdana size=2> %s\n<br></td></tr>", $myrow["Malli"]);
printf("<td><b><font color=black face=verdana size=2>Lenght:</b></td><td><font color=black face=verdana size=2> %s\n<br></td></tr>", $myrow["Pituus"]);
printf("<td><b><font color=black face=verdana size=2>Usage:</b></td><td><font color=black face=verdana size=2> %s\n<br></td></tr>", $myrow["Kayttotarkoitus"]);
printf("<td><b><font color=black face=verdana size=2>Made from:</b></td><td><font color=black face=verdana size=2> %s\n<br></td></tr>", $myrow["Rakenne"]);
printf("<td><b><font color=black face=verdana size=2>Shape:</b></td><td><font color=black face=verdana size=2> %s\n<br></td></tr>", $myrow["Muoto"]);
printf("<td><b><font color=black face=verdana size=2>Width nose:</b></td><td><font color=black face=verdana size=2> %s\n<br></td></tr>", $myrow["Leveys_nose"]);
printf("<td><b><font color=black face=verdana size=2>Width keski:</b></td><td><font color=black face=verdana size=2> %s\n<br></td></tr>", $myrow["Leveys_keski"]);
printf("<td><b><font color=black face=verdana size=2>Width tail:</b></td><td><font color=black face=verdana size=2> %s\n<br></td></tr>", $myrow["Leveys_tail"]);
printf("<td><b><font color=black face=verdana size=2>Weight range:</b></td><td nowrap><font color=black face=verdana size=2> %s - %s\n kg<br></td></tr>", $myrow["Paino_min"], $myrow["Paino_max"]);
printf("<td><b><font color=black face=verdana size=2>Price:</b></td><td><font color=black face=verdana size=2> %s\n mk<br></td></tr></table>", $myrow["Hinta"]);
print "<br><br><A href=javascript:history.go(-1)><font face=Tahoma size=2>Back</font></A>";
}
else
{
for($e=0;$e<count($model);$e++){
list($board, $boardmodel) = split( '[_]', $model[$e]);
$result = mysql_query("SELECT * FROM laudat
WHERE Malli LIKE '$boardmodel' AND Merkki LIKE '$board'
ORDER BY Merkki",$db);
$myrow = mysql_fetch_array($result);
strcmp($result, '');
$number = mysql_numrows($result);
print "<table border=1>";
print "<tr><td bgcolor=000000 width=100><b><font color=white face=verdana size=2>Manufacter</td><td bgcolor=000000 width=150><b><font color=white face=verdana size=2>Model</td><td bgcolor=000000 width=150><font color=white>Lenght</td></tr>";
$cellcolor = array('#FFFFFF','#CCCCCC');
$color = 0;
do
{
printf("<tr bgcolor=$cellcolor[$color]><td nowrap width=100><a href=\"%s?id=%s\"><b>%s</b></a></td>", $PHP_SELF, $myrow["id"], $myrow["Merkki"]);
printf("<td width=150 nowrap>%s</td>", $myrow["Malli"]);
printf("<td width=150 nowrap>%s</td></tr>", $myrow["Pituus"]);
if ("0"==$color){$color="1";}
else {$color="0";}
} while ($myrow = mysql_fetch_array($result));
print "</table>";
}
print "</table>";
}
?>
How can I do it???
