[Resolved] Verify Data Not entered

lyndonlegend

Okay. I have a players table layed out as follows:
PLAYERID (autoincrement)
Lastname
Firstname
address
city
state
zip

I want to add a player, but ensure the player does not exist under a different id. I have the following coded:
$con= mysql_connect($host,$usrnm,$passwrd)
or die("Connection failed!!! <br>");

$varselect=mysql_select_db($database)
or die("Database selection failed!!!");

$query = mysql_query("SELECT lastname, firstname FROM players WHERE
lastname = $POST[lastname]' AND firstname = '$POST[firstname]'");

$numrows = mysql_num_rows($query);

if ($numrows == 1) {
echo "PERSON EXISTS!.. Don't perform insert.";
}
else
if ($numrows == 0)
{

$query2=mysql_query("INSERT INTO players VALUES('NULL',
'".$lastname."',
'".$firstname."',
'".$address."',
'".$city."',
'".$state."',
'".$zip."',
'".$dob."',
'".$primaryteam."',
'".$secondaryteam."',
'".$sex."',
'".$siblings."',
'".$homephone."',
'".$workphone."',
'".$cellphone."',
'".$email."');");
}

$varquery=mysql_query($query2);

if (!$varquery)
{
die( "Query execution failed!!!<br>" . mysql_error() );
}
else
{ (this here loads into a table stating player added on the screen and shows what was inserted).

However I get an error stating 'Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/reedsbu/public_html/insert_player.php on line 35
Query execution failed!!!'

Any ideas?

nemonoman

There error tells you that this queryresult:
$query = mysql_query("SELECT lastname, firstname FROM players WHERE
lastname = $POST[lastname]' AND firstname = '$POST[firstname]'");

doesn't exist because somt thing in the query caused the query to fail... likely the MISSING SINGLE QUOTE from
lastname = $_POST[lastname]'

Which should be:
lastname = '$_POST[lastname]'

lyndonlegend

Thanks. That fixed that error. Now I get to the second query and am told the "Query execution failed!!! Query was empty.

nemonoman

mysql_query runs the query and puts the result into $query2
$query2=mysql_query("INSERT INTO players VALUES('NULL',
'".$lastname."',
'".$firstname."',
'".$address."',
'".$city."',
'".$state."',
'".$zip."',
'".$dob."',
'".$primaryteam."',
'".$secondaryteam."',
'".$sex."',
'".$siblings."',
'".$homephone."',
'".$workphone."',
'".$cellphone."',
'".$email."');");
}

$query2 is the result, now.

So this command

$varquery=mysql_query($query2);

fails.

remove the line:
$varquery=mysql_query($query2);

You've already run the query2

lyndonlegend

I removed the code you suggested, but the query to insert the data still fails and therefore you don't get it to show on the next screen that you inserted data. I tried it as follows and got the error 'Query 2 execution failed!!!' :

<html>
<head>
<title>PLAYER REGISTERED</title>
</head>
<body background="http://www.reedsburgpolars.com/images/grayice.gif" link="3300CC" alink="000000" vlink="FF0000">
<?php
$host="localhost";
$usrnm="XXXXXX";
$passwrd="XXXXXX";
$database="XXXXXX";
$tablename="players";
$firstname = $POST["firstname"];
$lastname = $POST["lastname"];
$address=$POST["address"];
$city=$POST["city"];
$state=$POST["state"];
$zip=$POST["zip"];
$dob=$POST["dob"];
$sex=$POST["sex"];
$siblings=$POST["siblings"];
$homephone=$POST["homephone"];
$workphone=$POST["workphone"];
$cellphone=$POST["cellphone"];
$email=$_POST["email"];

$con= mysql_connect($host,$usrnm,$passwrd)
or die("Connection failed!!! <br>");

$varselect=mysql_select_db($database)
or die("Database selection failed!!!");

$query = mysql_query("SELECT lastname, firstname FROM players WHERE
lastname = '$POST[lastname]' AND firstname = '$POST[firstname]'");

$numrows = mysql_num_rows($query);

if ($numrows == 1) {
echo "PERSON EXISTS!.. Don't perform insert.";
}
else
if ($numrows == 0)
{

if (!$query2)
{
die( "Query 2 execution failed!!!<br>" . mysql_error() );
}
else
{
echo "<table border=\"0\" align=\"center\" cellspacing=\"1\"
cellpadding=\"5\" width=\"800\">";
echo " <tr> ";
echo " <td colspan=\"2\"> ";
echo " <center><b>".mysql_affected_rows()."
record entered into the table</b></center>";
echo " </td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"400\"> ";
echo " <div align=\"right\">Lastname: </div>";
echo " </td>";
echo " <td width=\"400\">".$lastname."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"400\"> ";
echo " <div align=\"right\">Firstname: </div>";
echo " </td>";
echo " <td width=\"400\">".$firstname."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"400\"> ";
echo " <div align=\"right\">Address:</div>";
echo " </td>";
echo " <td width=\"400\">".$address."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"400\"> ";
echo " <div align=\"right\">City:</div>";
echo " </td>";
echo " <td width=\"400\">".$city."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"400\"> ";
echo " <div align=\"right\">State:</div>";
echo " </td>";
echo " <td width=\"400\">".$state."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"400\"> ";
echo " <div align=\"right\">Zip:</div>";
echo " </td>";
echo " <td width=\"400\">".$zip."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"400\"> ";
echo " <div align=\"right\">Date of Birth:</div>";
echo " </td>";
echo " <td width=\"400\">".$dob."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"400\"> ";
echo " <div align=\"right\">Primary Team:</div>";
echo " </td>";
echo " <td width=\"400\">".$primaryteam."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"400\"> ";
echo " <div align=\"right\">Secondary Team:</div>";
echo " </td>";
echo " <td width=\"400\">".$secondaryteam."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"400\"> ";
echo " <div align=\"right\">Sex:</div>";
echo " </td>";
echo " <td width=\"400\">".$sex."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"400\"> ";
echo " <div align=\"right\">Siblings Playing Hockey:</div>";
echo " </td>";
echo " <td width=\"400\">".$siblings."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"400\"> ";
echo " <div align=\"right\">Home Phone:</div>";
echo " </td>";
echo " <td width=\"400\">".$homephone."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"400\"> ";
echo " <div align=\"right\">Work Phone:</div>";
echo " </td>";
echo " <td width=\"400\">".$workphone."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"400\"> ";
echo " <div align=\"right\">Cell Phone:</div>";
echo " </td>";
echo " <td width=\"400\">".$cellphone."</td>";
echo " </tr>";
echo " <tr> ";
echo " <td width=\"400\"> ";
echo " <div align=\"right\">E-mail:</div>";
echo " </td>";
echo " <td width=\"400\">".$email."</td>";
echo " </tr>";
echo "</table>";
}
?>
<center>
<table border="0">
<tr>
<td><a href="http://www.reedsburgpolars.com/ryhareg.html"><img src="http://www.reedsburgpolars.com/images/register.bmp"></img</a>
</td>
<td><a href="http://www.reedsburgpolars.com/index.html"><img src="http://www.reedsburgpolars.com/images/home.bmp"></img</a>
</td>
</tr>
</table>
</body>
</html>

nemonoman

Now you must debug yourself. Probably the variables being inserted doesn't match the column setup of your table.