$query = "SELECT COUNT(*) FROM fusion_players17 WHERE WSBNo = (' . mysql_real_escape_string(WSBNo) .')";
//$query = "SELECT FROM fusion_players17 WHERE WSBNo = '$WSBNo'";
$result = mysql_query($query);
if (mysql_result($result, 0, 0) > 0){
//if (mysql_result($result) >0){
// some data matched
echo "<center>";
echo "That Square Has Been Taken, Go Back And Pick Another Square";
echo "</center>";
}
else {
$sql = "INSERT INTO fusion_players17 (user_name, name, address, city, state, zip, email, password, Reg, SurvI, SurvII, BTL, Play, WSB, CPP, Marg, total, WSBNo)
VALUES ('$user_name', '$name', '$address', '$city', '$state', '$zip', '$email', '$password', '$Reg', '$SurvI', '$SurvII', '$BTL', '$Play', '$WSB', '$CPP', '$Marg', '$total', '$WSBNo')";
if (!mysql_query($sql,$connection)){
die('Error: ' . mysql_error());
Category Forum
Modifications and Requests - 9Labels
None yet
Statistics
2 participants
Notifications
You are not receiving notifications from this thread.
Related Questions