2 Tables 1 Search

Andy_Frees

Hi,

I am trying to get a php page to give 2 sets of results from 2 tables but using a single search.

The code below returns the correct data from the first part of the query, but the second part returns the following error:

"Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/serve/database/playerdata.php on line 96"

This argument comes up twice as you can see.

Thanks for any help.

<?
// We can include this file in all our files
// this way, every file will contain all our functions
require_once("menu_fns.php");
require_once("site_fns.php");
do_html_header("");
do_html_menu("");
do_html_subheader("");

?>
<?
if (!$searchtype || !$searchterm)
{
echo "You have not entered search details. Please go back and try again.";
exit;
}

$searchtype = addslashes($searchtype);
$searchterm = addslashes($searchterm);

@ $db = mysql_pconnect( 'server', 'userid', 'password' );

if (!$db)
{
echo "<CENTER>Error: Could not connect to database. Please try again later.</CENTER>";
exit;
}

mysql_select_db("database");
$query = "select * from madc_ratings where ".$searchtype." like '%".$searchterm."%'";
$result = mysql_query($query);

$num_results = mysql_num_rows($result);

$header = mysql_fetch_array($result);

 echo "<TR><TD>";
 echo "<CENTER><FONT FACE=Arial SIZE=-3>Number of players found: '.$num_results.'</FONT></CENTER><BR>";
 echo "<Table border=0 width=100% ALIGN=CENTER>";
 echo "<TR VALIGN=middle>";
 echo "<H1>First Name: ";
 echo ($header["rfirst"]);
 echo "</H1></TR>";
 echo "<TR VALIGN=middle>";
 echo "<H1>Last Name: ";
 echo ($header["rlast"]);
 echo "</H1></TR>";
 echo "<TR VALIGN=middle>";
 echo "<H1>PDGA Number: ";
 echo ($header["rpdga"]);
 echo "</H1></TR>";
 echo "<TR VALIGN=middle>";
 echo "<H1>MADC Player Rating: ";
 echo ($header["rmadcr"]);
 echo "</H1></TR>";
 echo "<TR VALIGN=middle>";
 echo "<H1>Events Used: ";
 echo ($header["eventcount"]);
 echo "</H1></TR>";
 echo "<TR VALIGN=middle>";
 echo "<H1>PDGA Player Rating: ";
 echo ($header["pdgar"]);
 echo "</H1></TR>";
 echo "<TR VALIGN=middle>";
 echo "<H1>Rounds Used: ";
 echo ($header["prdu"]);
 echo "</H1></TR>";
 echo "<TR VALIGN=middle>";
 echo "<H1>State: ";
 echo ($header["rst"]);
 echo "</H1></TR></TABLE>";

<!--/*<?
if (!$searchtype || !$searchterm)
{
echo "You have not entered search details. Please go back and try again.";
exit;
}

$searchtype = addslashes($searchtype);
$searchterm = addslashes($searchterm);

@ $db = mysql_pconnect@ $db = mysql_pconnect( 'server', 'userid', 'password' );

if (!$db)
{
echo "<CENTER>Error: Could not connect to database. Please try again later.</CENTER>";
exit;
}

mysql_select_db("database");
$query = "select * from results where ".$searchtype." like '%".$searchterm."%'";
$result = mysql_query($query);

$num_results = mysql_num_rows($result);
echo "<TR><TD>";
echo "<CENTER>Number of records found: '.$num_results.'</CENTER>";
echo "<Table border=0 width=720 ALIGN=CENTER>";
echo "<TR VALIGN=middle>";
echo "<TD BGCOLOR=#33CCCC ALIGN=left>Event</TD>";
echo "<TD BGCOLOR=#33CCCC ALIGN=left>Date</TD>";
echo "<TD BGCOLOR=#33CCCC ALIGN=left>Place</TD>";
echo "<TD BGCOLOR=#33CCCC ALIGN=left>Div</TD>";
echo "<TD BGCOLOR=#33CCCC ALIGN=left>First Name</TD>";
echo "<TD BGCOLOR=#33CCCC ALIGN=left>Last Name</TD>";
echo "<TD BGCOLOR=#33CCCC ALIGN=left>PDGA</TD>";
echo "<TD BGCOLOR=#33CCCC ALIGN=left>R1</TD>";
echo "<TD BGCOLOR=#33CCCC ALIGN=left>R2</TD>";
echo "<TD BGCOLOR=#33CCCC ALIGN=left>R3</TD>";
echo "<TD BGCOLOR=#33CCCC ALIGN=left>R4</TD>";
echo "<TD BGCOLOR=#33CCCC ALIGN=left>Sub</TD>";
echo "<TD BGCOLOR=#33CCCC ALIGN=left>F9</TD>";
echo "<TD BGCOLOR=#33CCCC ALIGN=left>Tot</TD>";
echo "<TD BGCOLOR=#33CCCC ALIGN=left>Prize</TD>";
echo "<TD BGCOLOR=#33CCCC ALIGN=left>ERating</TD></TR>";
for ($i=0; $i < $num_results; $i++)
{
$row = mysql_fetch_array($result);
echo "<TR><TD bgcolor=#CCCCCC>";
echo ($row["event"]);
echo "</TD><TD bgcolor=#CCCCCC>";
echo ($row["edate"]);
echo "</TD><TD bgcolor=#CCCCCC>";
echo ($row["pl"]);
echo "</TD><TD bgcolor=#CCCCCC>";
echo ($row["div"]);
echo "</TD><TD bgcolor=#CCCCCC>";
echo ($row["first"]);
echo "</TD><TD bgcolor=#CCCCCC>";
echo ($row["last"]);
echo "</TD><TD bgcolor=#CCCCCC>";
echo ($row["pdgan"]);
echo "</TD><TD bgcolor=#CCCCCC>";
echo ($row["rd1"]);
echo "</TD><TD bgcolor=#CCCCCC>";
echo ($row["rd2"]);
echo "</TD><TD bgcolor=#CCCCCC>";
echo ($row["rd3"]);
echo "</TD><TD bgcolor=#CCCCCC>";
echo ($row["rd4"]);
echo "</TD><TD bgcolor=#CCCCCC>";
echo ($row["sub_tot"]);
echo "</TD><TD bgcolor=#CCCCCC>";
echo ($row["fnl9"]);
echo "</TD><TD bgcolor=#CCCCCC>";
echo ($row["tot"]);
echo "</TD><TD bgcolor=#CCCCCC>";
echo ($row["prize"]);
echo "</TD><TD bgcolor=#CCCCCC>";
echo ($row["madcr"]);
echo "</TD></TR>";
}
echo "</TABLE>";
?>*/-->

</body>
</html>

mikeatrpi

Why do you connect twice to your database? I suspect it is this line:

@ $db = mysql_pconnect@ $db = mysql_pconnect( 'server', 'userid', 'password' );

Try removing it completely, since you are connecting twice.