New to searching

Roble

I'm having trouble with my search page. It doesn't load at all... here is the code. Oh, and it doesn't give me any errors, it just doesn't show -- like I said.

<?php include("include.php"); 
if(!$submit) {
?>

<html>
<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="search.php">
<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></html><?php echo $race ?><html>'s 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 colspan="2"><center><input type="submit" value="Submit" name="submit"></center></td>
  </tr>
</table>
</form>
</html>

<?php

$handle_search = $HTTP_POST_VARS ['handle_search'];
$main_job_search = $HTTP_POST_VARS ['main_job_search'];
$support_job_search = $HTTP_POST_VARS ['support_job_search'];
$advanced_job_search = $HTTP_POST_VARS ['advanced_job_search'];
$race_search = $HTTP_POST_VARS ['race_search'];
$race_sex_search = $HTTP_POST_VARS ['race_sex_search'];
$kingdom_search = $HTTP_POST_VARS ['kingdom_search'];
$email_search = $HTTP_POST_VARS ['email_search'];
$AIM_search = $HTTP_POST_VARS ['AIM_search'];
$beta_tester_search = $HTTP_POST_VARS ['beta_tester_search'];
$importer_search = $HTTP_POST_VARS ['importer_search'];
$level_search = $HTTP_POST_VARS ['level_search'];
$tetra_master_search = $HTTP_POST_VARS ['tetra_master_search'];
$search_enabled_search = $HTTP_POST_VARS ['search_enabled_search'];
$submit = $HTTP_POST_VARS ['submit'];

}

else if(!empty($submit) || !empty($handle_search) || !empty($main_job_search) || !empty($support_job_search) || !empty($advanced_job_search) || !empty($level_search) || !empty($rank_search) || !empty($race_search) || !empty($race_sex_search) || !empty($kingdom_search) || !empty($email_search) || !empty($AIM_search) || !empty($beta_tester_search) || !empty($importer_search) || !empty($tetra_master_search)) {

$connect = mysql_connect("$user_hostname", "$user_username", "$user_password");
mysql_select_db("$user_database", $connect);

$search_query = "select * from users where (handle like '%".$handle_search."%' or main_job like '%".$main_job_search."%' or support_job like '%".$support_job_search."%' or advanced_job like '%".$advanced_job_search."%' or level like '%".$level_search."%' or rank like '%".$rank_search."%' or race like '%".$race_search."%' or race_sex like '%".$race_sex_search."%' or kingdom like '%".$kingdom_search."%' or email like '%".$email_search."%' or AIM like '%".$AIM_search."%' or beta_tester like '%".$beta_tester_search."%' or importer like '%".$importer_search."%' or tetra_master like '%".$tetra_master_search."%') ORDER BY handle ASC";
$search_res = mysql_query($search_query) or die(mysql_error().": ".$update); 

if (!$search_res) 
 {  

echo "<br>Information could not be found!";  

}

}

?>

intenz

Edit your php.ini file and change register_globals from Off to On and then restart Apache.

Roble

I'm not running my own server (Well ,I am, but my site is not on it). Only my host has powers to do such a thing.

Norman_Graham

Well, in that case, you'll have to use $POST[]; to get a hold of ALL your variables. I believe $HTTP_POST_VARS is now depreciated, or even just not functional. You want $POST.

I suggest collecting your variables at the start of the script before going any further.

HTH

Norman

intenz

Try this...

<?php include("include.php");  

if(!isset($_POST['submit'])) { 
?> 

<html> 
<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="search.php"> 
<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></html><?php echo $race; ?><html>'s 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 colspan="2"><center><input type="submit" value="Submit" name="submit"></center></td> 
  </tr> 
</table> 
</form> 
</html> 

<?php 

$handle_search = $_POST['handle_search']; 
$main_job_search = $_POST['main_job_search']; 
$support_job_search = $_POST['support_job_search']; 
$advanced_job_search = $_POST['advanced_job_search']; 
$race_search = $_POST['race_search']; 
$race_sex_search = $_POST['race_sex_search']; 
$kingdom_search = $_POST['kingdom_search']; 
$email_search = $_POST['email_search']; 
$AIM_search = $_POST['AIM_search']; 
$beta_tester_search = $_POST['beta_tester_search']; 
$importer_search = $_POST['importer_search']; 
$level_search = $_POST['level_search']; 
$tetra_master_search = $_POST['tetra_master_search']; 
$search_enabled_search = $_POST['search_enabled_search']; 
$submit = $_POST['submit']; 

} 

elseif(isset($_POST['submit']) || !empty($handle_search) || !empty($main_job_search) || !empty($support_job_search) || !empty($advanced_job_search) || !empty($level_search) || !empty($rank_search) || !empty($race_search) || !empty($race_sex_search) || !empty($kingdom_search) || !empty($email_search) || !empty($AIM_search) || !empty($beta_tester_search) || !empty($importer_search) || !empty($tetra_master_search)) { 

$connect = mysql_connect("$user_hostname", "$user_username", "$user_password"); 
mysql_select_db("$user_database", $connect); 

$search_query = "select * from users where (handle like '%".$handle_search."%' or main_job like '%".$main_job_search."%' or support_job like '%".$support_job_search."%' or advanced_job like '%".$advanced_job_search."%' or level like '%".$level_search."%' or rank like '%".$rank_search."%' or race like '%".$race_search."%' or race_sex like '%".$race_sex_search."%' or kingdom like '%".$kingdom_search."%' or email like '%".$email_search."%' or AIM like '%".$AIM_search."%' or beta_tester like '%".$beta_tester_search."%' or importer like '%".$importer_search."%' or tetra_master like '%".$tetra_master_search."%') ORDER BY handle ASC"; 
$search_res = mysql_query($search_query) or die(mysql_error().": ".$update);  

if (!$search_res)  

 {   

echo "<br>Information could not be found!";   

} 

} 

?>

Roble

Thanks for the help, intenz, but that didn't seem too work. I'm stumped...

tekky

first off I Would eliminate all the $POST[blah] assignments and do this FIRST inthe script even before your if check for $POST

while(list($key, $val) = each($_POST))
{
     $$key=$val; //this makes it so you can use if(!isset($submit)) instead of $_POST['submit']
}

this will automatically make all your variables available from $_POST as if the registerglobals option was turned on...

and try putting this after your include....
echo "We got this far... now what next?<br>";

if you dont see that line... then I would suggest giving us a hint what include.php is doing 😉

Roble

Include.php is just a login and remember script. it is also the initial connecting script for mysql.

tekky

Originally posted by Roble
Include.php is just a login and remember script. it is also the initial connecting script for mysql.

and it works correctly on its own?

Truti

Try place:

extract($_POST);

just after the

 <?php

An other good thing to try is to increase, the php error handler sensitivity, to find the small bugs!

Do that with:
ini_set ('error_reporting', E_ALL);

Roble

Well, I've been doing some messing around with the code. Strangely, it always returns one Row affected...

tekky

Originally posted by Roble
Well, I've been doing some messing around with the code, and here is what I got. Strangely, it always returns one Row affected...

1 affected for the select or which statement?

you should use mysql_num_rows() instead of affected for SELECTS, affected is more for DELETE UPDATE kinda things...

Roble

Here is the code I have so far. I just basically want the user to enter the stuff they want to search in some of the boxes (So all boxes don't have to be filled, but they can if the user desires to do so), and then the search searches for an appropriate match.

Example: User types in a handle ($handle_search) and then the table looks for the matches in the row handle if my mySQL table users.

<?php include("include.php");   

extract($_POST);
ini_set ('error_reporting', E_ALL);

if(!isset($submit)) {  

?>

<html> 
<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="search.php"> 
<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></html><?php echo $race; ?><html>'s 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 colspan="2"><center><input type="submit" value="Submit" name="submit"></center></td> 
  </tr> 
</table> 
</form> 
</html> 

<?php

}  

elseif(isset($submit) || !empty($handle_search) || !empty($main_job_search) || !empty($support_job_search) || !empty($advanced_job_search) || !empty($level_search) || !empty($rank_search) || !empty($race_search) || !empty($race_sex_search) || !empty($kingdom_search) || !empty($email_search) || !empty($AIM_search) || !empty($beta_tester_search) || !empty($importer_search) || !empty($tetra_master_search)) {  

$handle_search = $_POST['handle_search'];  
$main_job_search = $_POST['main_job_search'];  
$support_job_search = $_POST['support_job_search'];  
$advanced_job_search = $_POST['advanced_job_search'];  
$race_search = $_POST['race_search'];  
$race_sex_search = $_POST['race_sex_search'];  
$kingdom_search = $_POST['kingdom_search'];  
$email_search = $_POST['email_search'];  
$AIM_search = $_POST['AIM_search'];  
$beta_tester_search = $_POST['beta_tester_search'];  
$importer_search = $_POST['importer_search'];  
$level_search = $_POST['level_search'];  
$tetra_master_search = $_POST['tetra_master_search'];  
/*    $search_enabled = $_POST['search_enabled'];  */
    $submit = $_POST['submit'];

$connect = mysql_connect("$user_hostname", "$user_username", "$user_password");  

mysql_select_db("$user_database", $connect);  

$sql_query = "SELECT * FROM users";
$sql_res = mysql_query($sql) or die(mysql_error().": ".$sql_query);

$search_query = "select * from users where (handle like '%".$handle_search."%' or main_job like '%".$main_job_search."%' or support_job like '%".$support_job_search."%' or advanced_job like '%".$advanced_job_search."%' or level like '%".$level_search."%' or rank like '%".$rank_search."%' or race like '%".$race_search."%' or race_sex like '%".$race_sex_search."%' or kingdom like '%".$kingdom_search."%' or email like '%".$email_search."%' or AIM like '%".$AIM_search."%' or beta_tester like '%".$beta_tester_search."%' or importer like '%".$importer_search."%' or tetra_master like '%".$tetra_master_search."%') ORDER BY handle ASC";  

$search_res = mysql_query($search_query) or die(mysql_error().": ".$search_query);

mysql_affected_rows();

if(mysql_affected_rows()==0){
  echo "Your query has returned no results!";
} elseif(mysql_affected_rows()>0){
  echo mysql_affected_rows() . " row(s) affected.<br>" . $search_query;
}

}  

?>

Roble

No one knows how to do this? Please! I really need help with this!

Norman_Graham

Hi Roble

Check out the manual on the function extract() - it doesn't do what you think it does, and it's also unnecessary for what you want to do. Extract() is not a function for accessing global variables:

http://www.php.net/manual/en/function.extract.php

Furthermore, according to the manual entry for ini_set(), error_reporting is NOT one of the configuration options affected by this function:

http://www.php.net/manual/en/function.ini-set.php

I think you're making things more complicated for yourself than need be. Pay attention also to tekky's comment about mysql_num_rows(). The function mysql_affected_rows() is not appropriate for what you want to do, and in any case, if you want it to work you have to put the variable for the query results into the brackets, i.e. mysql_affected_rows($search_res)

HTH

Norman

Norman_Graham

Sorry - I apologise - error-reporting IS affected by ini_set. I didn't realise that the list isn't alphabetical.

Norman

Roble

No problem, Norman.

I am thinking about restarting this script. Can I have some examples (small ones) to do the following?

I want to make a search engine that searches a specified column, (in a specified table, in my mySQL database) when the submit button is pressed. What the user types in, into a text box, will then search through that column and print all the matches.

Also, I would want multiple search boxes, each for different things, that would not affect the query if they are left blank.

If any of you kind people could figure this out, I would be forever grateful! Thanks.

-Roble

Norman_Graham

Hi Roble

I've never had call to do this as yet, but you might find the following explanation of text searching and indexing in MySQL useful: http://www.mysql.com/doc/en/Fulltext_Search.html

HTH

Norm