checkboxes problem

Anon

hey, i got this script(below) where in you can search the databse, but i must search in one column, for 3 things, common uncommon and rare, when i makce the checkboxes all/common/uncommon/rare
and check uncommon and rare the script only search for rare, can someone help me change this

<?php

$db_hostname = "localhost"; // je db host
$db_database = "ricardo"; // je database
$db_user = ""; // je username
$db_password = ""; // je pass
$tabel = "magicdb"; // je eerste tabel
$volgorde = "Cardname"; // Kolomnaam waarop hij gesorteerd gaat worden
mysql_connect(localhost,);

mysql_select_db(ricardo);

?>

<HEAD>
<TITLE></TITLE>
</HEAD>
<BODY bgcolor=black text=white>
<?

if(!isset($trefwoord)){

echo "<FORM method=post>
<table border=0>
<tr>
<td colspan=2>Uitgebreid Zoeken.</td>
</tr>
<tr>
<td width=25>
Cardname
</td>
<td height=30>
<input type=text name=trefwoord >
</td>
</tr>
<tr>
<td width=25>
Rarity
</td>
<td >

            <input type=checkbox name=\"trefwoord2\" value=        ><b>All Rarities</b> 
            <input type=checkbox name=\"trefwoord2\" value=Common  >   Common 
            <input type=checkbox name=\"trefwoord2\" value=Uncommon>   Uncommon 
            <input type=checkbox name=\"trefwoord2\" value=Rare    >   Rare 

    </td> 
   </tr> 

   <tr> 
      <td height=30> 
    <input type=submit name=submit value=Zoek> 
</td> 
</tr> 
   </tr> 
  </table> 
</form>";

}

else {
?>
<FORM method=post><table border=0>
<tr>
<td height=30>Zoek op kaartnaam.</td>
</tr>
<tr>
<td height=30>
<input type=text name=trefwoord size=20>
</td>
</tr>

<table width=70% border=0> 
      <tr> 
      <td width=20%><b>Cardname</i></td> 
      <td width=20%><b>Serie</b></td> 
      <td width=20%><b>Rarity</b></td> 
      <td width=20%><b>Color</b></td> 
      <td width=20%><b>More Info</b></td> 
      </tr>

<?
$sql = "SELECT * FROM magicdb WHERE Cardname LIKE '%$trefwoord%' AND Rarity LIKE '$trefwoord2' ORDER BY Cardname";

$res = mysql_query($sql) or die(mysql_error());

$num = mysql_num_rows($res);

while($row = mysql_fetch_object($res)){

echo "<tr> 
<td width=20%>$row->Cardname</td> 
      <td width=20%>$row->Serie</a></td> 
      <td width=20%>$row->Rarity</td> 
      <td width=20%>$row->Color</td> 
      <td width=20%>$row->Info</td> 
      </tr>";  
    }  
echo "<td colspan=5><center><br>$trefwoord heeft $num  resultaten opgelevert.</center> </td></tr></table></center></p>";  
}

</td>
</tr>
</table>
</BODY>

bastien

when you have two checkboxes checked with the same name, you end up with an array that has the value of the two values like this

$trefwoord2 = "uncommon,rare"

when you want to search it will only take the last value in the array. this is your problem. there are two ways to fix this:

change the checkboxes to radioboxes and allow only one choice. easy and requires no change to existing query code.
handle the array. trickier to code but mor interesting and allows the search on multiple criteria (and cuz you're dutch (if you're not dutch, you're not much!) i'll give you a hand...)

<?
$i = count($mytrefwoord); //count the elements in the array
if ($i>1){ //if array has more than one element then explode the array
$mytrefwoord = explode(",",$trefwoord2);

for($x=0;$x<=$i;$x++){
$mytrefwoord2 = $mytrefwoord($x);
$mytrefwoord3 = $mytrefwoord3." or rarity like ".$mytrefwoord2; //expand the trefwoord2 code to allow mutiple criteria
}
$trefwoord2 = $mytrefwoord3; //assign the value of $mytrefwoord3 back to the sql variable
}
//execute the sql query and show the results
$sql = "SELECT * FROM magicdb WHERE Cardname LIKE '%$trefwoord%' AND Rarity ='$trefwoord2' ORDER BY Cardname";
$res = mysql_query($sql) or die(mysql_error());
$num = mysql_num_rows($res);
while($row = mysql_fetch_object($res)){
...rest of the code

double check the $sql by echoing it to the screen before actually executing the query to ensure i got the syntax right...

hth
bastien