Hi. I took both of your suggestions. I didn't work, but I made a handy little feature that allows you to choose an AND or an OR search 🙂 Please look over my code and tell me why it posts all of the rows on an OR search, but not a single row with an AND search. There are only two rows so far.
<?php
ini_set ('error_reporting', E_ALL);
if (!isset($subform)) {
?>
<html>
<head>
<title><< Clan Area :: Search >></title>
</head>
<body>
<font face="verdana" size="2">
<center>Here is where you can search for other clan members
to play with. If you would like to be listed in the search, go
to your <a href="configure_stats.php"><b>Stats
Configure</b></a> panel, and you can click <b>Yes
</b> under the <b>Search Enabled</b> row.</center></font>
<br>
<br>
<form name="search" method="post" action="this.php?subform=1">
<table border="1" cellpadding="2" cellspacing="0" align="center" valign="top" width="500">
<tr>
<td colspan="2"><font face="verdana" size="2"><b><center>Final Fantasy XI clan search</center></b></font></td>
</tr>
<tr>
<td><font face="verdana" size="2"><b>Information</b></font></td>
<td><font face="verdana" size="2"><b>Search for -></b></font></td>
</tr>
<tr>
<td><font face="verdana" size="2"><b>Handle:</b></font></td>
<td><input type="text" name="handle_search" maxlength="30"></td>
</tr>
<tr>
<td><font face="verdana" size="2"><b>Main Job:</b></font></td>
<td>
<SELECT NAME="main_job_search">
<OPTION VALUE="Blank">
<OPTION VALUE="Warrior">Warrior
<OPTION VALUE="Black Mage">Black Mage
<OPTION VALUE="White Mage">White Mage
<OPTION VALUE="Red Mage">Red Mage
<OPTION VALUE="Monk">Monk
</SELECT>
</td>
</tr>
<tr>
<td><font face="verdana" size="2"><b>Support Job:</b></font></td>
<td>
<SELECT NAME="support_job_search">
<OPTION VALUE="Blank">
<OPTION VALUE="Warrior">Warrior
<OPTION VALUE="Black Mage">Black Mage
<OPTION VALUE="White Mage">White Mage
<OPTION VALUE="Red Mage">Red Mage
<OPTION VALUE="Monk">Monk
</SELECT>
</td>
</tr>
<tr>
<td><font face="verdana" size="2"><b>Advanced Job:</b></font></td>
<td>
<SELECT NAME="advanced_job_search">
<OPTION VALUE="Blank">
<OPTION VALUE="Dark Knight">Dark Knight
<OPTION VALUE="Paladin">Paladin
<OPTION VALUE="Beastmaster">Beastmaster
<OPTION VALUE="Ranger">Ranger
<OPTION VALUE="Ninja">Ninja
<OPTION VALUE="Samurai">Samurai
<OPTION VALUE="Summoner">Summoner
<OPTION VALUE="Dragoon">Dragoon
</SELECT>
</td>
</tr>
<tr>
<td><font face="verdana" size="2"><b>Race:</b></font></td>
<td>
<SELECT NAME="race_search">
<OPTION VALUE="Blank">
<OPTION VALUE="Hume">Hume
<OPTION VALUE="Elvaan">Elvaan
<OPTION VALUE="Taru Taru">Taru Taru
<OPTION VALUE="Galka">Galka
<OPTION VALUE="Mithra">Mithra
</SELECT>
</td>
</tr>
<tr>
<td><font face="verdana" size="2"><b>Sex:</b></font></td>
<td>
<SELECT NAME="race_sex_search">
<OPTION VALUE="Blank">
<OPTION VALUE="Male">Male
<OPTION VALUE="Female">Female
</SELECT>
</td>
</tr>
<tr>
<td><font face="verdana" size="2"><b>Kingdom:</b></font></td>
<td>
<SELECT NAME="kingdom_search">
<OPTION VALUE="Blank">
<OPTION VALUE="Bastok">Bastok
<OPTION VALUE="Windust">Windurst
<OPTION VALUE="San DOria">San D'Oria
</SELECT>
</td>
</tr>
<tr>
<td><font face="verdana" size="2"><b>Rank:</b></font></td>
<td>
<SELECT NAME="rank_search">
<OPTION VALUE="Blank">
<OPTION VALUE="Member">Member
<OPTION VALUE="Leader">Leader
<OPTION VALUE="Elite">Elite
</SELECT>
</td>
</tr>
<tr>
<td><font face="verdana" size="2"><b>Level:</b></font></td>
<td><input type="text" name="level_search" maxlength="2"></td>
</tr>
<tr>
<td><font face="verdana" size="2"><b>E-mail:</b></font></td>
<td><input type="text" name="email_search" maxlength="30"></td>
</tr>
<tr>
<td><font face="verdana" size="2"><b>AIM:</b></font></td>
<td><input type="text" name="AIM_search" maxlength="30"></td>
</tr>
<tr>
<td><font face="verdana" size="2"><b>Beta Tester:</b></font></td>
<td>
<SELECT NAME="beta_tester_search">
<OPTION VALUE="Blank">
<OPTION VALUE="Yes PC">Yes, PC version
<OPTION VALUE="Yes PS2">Yes, PS2 version
<OPTION VALUE="No">No
</SELECT>
</td>
</tr>
<tr>
<td><font face="verdana" size="2"><b>Importer:</b></font></td>
<td>
<SELECT NAME="importer_search">
<OPTION VALUE="Blank">
<OPTION VALUE="Yes PC">Yes, PC version
<OPTION VALUE="Yes PS2">Yes, PS2 version
<OPTION VALUE="Both versions">Both versions
<OPTION VALUE="No">No
</SELECT>
</td>
</tr>
<tr>
<td><font face="verdana" size="2"><b>Playing Tetra Master:</b></font></td>
<td>
<SELECT NAME="tetra_master_search">
<OPTION VALUE="Blank">
<OPTION VALUE="Yes PC">Yes, PC version
<OPTION VALUE="Yes PS2">Yes, PS2 version
<OPTION VALUE="Both versions">Both versions
<OPTION VALUE="No">No
</SELECT>
</td>
</tr>
<tr>
<td><font face="verdana" size="2"><b>Search Type:</b></font></td>
<td>
<center>
<input type="radio" name="type_of_search" value="AND" checked><font face="verdana" size="2">AND</font>
<input type="radio" name="type_of_search" value="OR"><font face="verdana" size="2">OR</font>
</center>
</td>
</tr>
<tr>
<td colspan="2"><center><input type="SUBMIT" value="Search" name="search"></center></td>
</tr>
</table>
</form>
</body>
</html>
<?php
$_POST['handle_search'];
$_POST['main_job_search'];
$_POST['support_job_search'];
$_POST['advanced_job_search'];
$_POST['kingdom_search'];
$_POST['race_search'];
$_POST['race_sex_search'];
$_POST['level_search'];
$_POST['email_search'];
$_POST['AIM_search'];
$_POST['beta_tester_search'];
$_POST['importer_search'];
$_POST['tetra_master_search'];
$_POST['type_of_search'];
} else if($subform==1) {
$connect = MySQL_connect("localhost", "user", "pass");
MySQL_select_db("db", $connect);
// PHP Search Script
if($type_of_search=="AND"){
$ANDOR="AND";
}
else if($type_of_search=="OR"){
$ANDOR="OR";
}
$sql = mysql_query("SELECT handle, main_job, support_job, advanced_job, race, race_sex, level, email, AIM, beta_tester,
importer, tetra_master FROM users
WHERE handle LIKE '%$handle_search%' " . $ANDOR . " main_job LIKE '%$main_job_search%'
" . $ANDOR . " support_job LIKE '%$support_job_search%' " . $ANDOR . " advanced_job LIKE '%$advanced_job_search%' " . $ANDOR . " race LIKE '%$race_search%'
" . $ANDOR . " race_sex LIKE '%$race_sex_search' " . $ANDOR . " kingdom like '%$kingdom_search%' " . $ANDOR . " rank LIKE '%$rank_search%'
" . $ANDOR . " level LIKE '%$level_search%' " . $ANDOR . " email LIKE '%$email_search%' " . $ANDOR . " AIM LIKE '%$AIM_search'
" . $ANDOR . " beta_tester LIKE '%$beta_tester_search%' " . $ANDOR . " importer LIKE '%$importer_search%'
" . $ANDOR . " tetra_master LIKE '%$tetra_master_search$'") OR die (mysql_error());
while(list($handle, $main_job)=mysql_fetch_array($sql)){
echo "Handle: $handle<br />";
echo "Main Job: $main_job<br />";
}
}
?>
