search result problem

[Anon]

Hi there!

You can find my problem at

<a href="http://www.cs.uta.fi/~ah66533/what/searchform.html">http://www.cs.uta.fi/~ah66533/what/searchform.html</a> here.

I have search page where user can first select the manufacter and after that second box shows all models matching that manufacter. You can also select many manufacters. The search works just fine with manufacters but models are the problem.
If I select model it doesn't affect the search result. It always returns all results that match the manufacter. Somebody please help me. The problem is at link I gave above.

-Arto-

[jc94062]

Below is a similar site, but its a Javascript forum, they may be of more help for Javascript problems.

http://forums.devshed.com/forumdisplay.php?forumid=3

[jc94062]

Missed the PHP part of that

[Anon]

Javascript works just fine but i don't know hot two take out from array noth the manufacter and model.

<?php
$db = mysql_connect("localhost", "", "");
mysql_select_db("lumilaudat",$db);

if ($manufacter == "")
{$manufacter = '%';}

if ($model == "")
{$model = '%';}

    for($i=0;$i<count($manufacter);$i++){


    $manuf = $manufacter[$i];

    $result = mysql_query("SELECT * FROM laudat
                    WHERE Merkki LIKE '$manuf'
                    ORDER BY Merkki",$db);



            $myrow = mysql_fetch_array($result);
            strcmp($result, '');
            $number += mysql_numrows($result);

}

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
{
if($number=="0"){
print "<b>There are no boards with you search options:</b><br>Manufacter:<br>";
for($x=0;$x<count($manufacter);$x++)
print "$manufacter[$x]<br>";

}
else print "There are $number snowboards with your search terms!<br><br>";

    for($t=0;$t<count($manufacter);$t++)
    {
    $manuf = $manufacter[$t];

    $result = mysql_query("SELECT * FROM laudat
                  WHERE Merkki LIKE '$manuf'
                  ORDER BY Merkki, Malli",$db);

           $myrow = mysql_fetch_array($result);
           strcmp($result, '');
           $number += mysql_numrows($result);

if($myrow != "0"){
print "<table border=1>";

print "<tr><td><b><font color=black face=verdana size=2>Manufacter</td><td><b><font color=black face=verdana size=2>Model</td><td><font color=black face=verdana size=2><b>Price</td></tr>";

$cellcolor = array('#CCCCCC','#BBBBBB');
$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=200 nowrap>%s</td>", $myrow["Malli"]);
    printf("<td width=50 nowrap>%s</td></tr>", $myrow["Hinta"]);


    if ("0"==$color){$color="1";}
    else {$color="0";}
    } while ($myrow = mysql_fetch_array($result));

}

print "</table>";

}
}
?>