[Resolved] error message for no apparent reason!

[tuf-web_co_uk]

hey i have this script

function valid($email) {

if (eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+([\.][a-z0-9-]+)+$",$_POST["email"]))
{
    $evalid=1;
}

else
{
    $evalid=2;
}

}

if (isset($submit)) {

if ( !$username && !$password && !$password2 && !$email && !$fname && !$lname && !$city && !$bgcolor && !$fontface && !$fontsize && !$link && !$active && !$visited && !$hover && !$linksize && !$linkface ) {

echo "you have not enter all of the required details";
echo " <a href=javascript:history.back();>go back</a>";
exit;	

}

else {
$sql = "SELECT * from custom WHERE username='$username'";
$result = mysql_query($sql) or die("could not select records 144");
$results = mysql_num_rows($result);

	if ($results != 0) {

	echo "that username has already been taken, please go back and try again";
	echo " <a href=javascript:history.back();>go back</a>";
	exit;

	}

	else {

		if ($password != $password2) {

		echo "your passwords do not match, please go back and try again";
		echo " <a href=javascript:history.back();>go back</a>";
		exit;

		}

		else {

		valid($email);

			if ($evalid == 2) {

			echo "that email address is not valid please go back and try again";
			echo " <a href=javascript:history.back();>go back</a>";
			exit;

			}

			else {

			$sql = "INSERT INTO custom (username, password, email, lname, fname, city, bgcolor, fontsize, fontface, fontcolor, link, active, visited, hover, linksize, linkface) VALUES ('$username', MD5('$password'), '$email', '$lname', '$fname', '$city', '$bgcolor', '$fontsize', '$fontface', '$fontcolor', '$link', '$active', '$visited', '$hover', '$linksize', '$linkface')";
			$query = mysql_query($sql) or die ("could not create record 180");
			$result = mysql_affected_rows($query);

				if ($result != 1) {

				echo "unknown error, please try again";
				echo " <a href=javascript:history.back();>go back</a>";
				exit;

				}

				else {

				echo "user account created<br>";
				echo "thank you for joining theutherfish.coms customization program<br><br>";
				echo "<a href=login.php>login</a>";

				}

			}

		}

	}

}

}

and when i run it, it gives me the error message

Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource in /home2/theuther/public_html/users/register.php on line 186

i'm not quite sure why this is doing this, because although it is saying this the records are still being added to the database

anyhelp would be great

thanks Jon 🙁

[stolzyboy]

well if it works for you, then simply put an @ in front of the function to suppress the error

@mysql_affected_rows

[tuf-web_co_uk]

thanks for that reply it got rid of the error message 😃

but now i get another error message because the variable

$result != 1

code --

@ $result = mysql_affected_rows($query);

				if ($result != 1) {

				echo "unknown error, please try again";
				echo " <a href=javascript:history.back();>go back</a>";
				exit;

				}

so it seems that the variable needs to be there

anymore help please?!

thanks alot Jon

[stolzyboy]

this

@ $result = mysql_affected_rows($query);

needs to be this

$result = @mysql_affected_rows($query);

[tuf-web_co_uk]

sorry about that i misread it the first time,

but i still got the error message when i tried

$result = @mysql_affected_rows($query)

[stolzyboy]

paste the exact error you are getting

[tuf-web_co_uk]

unknown error, please try again go back

this comes from my code

$sql = "INSERT INTO custom (username, password, email, lname, fname, city, bgcolor, fontsize, fontface, fontcolor, link, active, visited, hover, linksize, linkface) VALUES ('$username', MD5('$password'), '$email', '$lname', '$fname', '$city', '$bgcolor', '$fontsize', '$fontface', '$fontcolor', '$link', '$active', '$visited', '$hover', '$linksize', '$linkface')";
				$query = mysql_query($sql) or die ("could not create record 180");
				$result = @mysql_affected_rows($query);

				if ($result != 1) {

				echo "unknown error, please try again";
				echo " <a href=javascript:history.back();>go back</a>";
				exit;

				}

because the number of affected rows doesnt equal 1

thanks again

Jon

[stolzyboy]

try this and if you are still getting that error, your query isn't just doing what you want it to do

$sql = "INSERT INTO custom (username, password, email, lname, fname, city, bgcolor, fontsize, fontface, fontcolor, link, active, visited, hover, linksize, linkface) VALUES ('$username', MD5('$password'), '$email', '$lname', '$fname', '$city', '$bgcolor', '$fontsize', '$fontface', '$fontcolor', '$link', '$active', '$visited', '$hover', '$linksize', '$linkface')";
$query = mysql_query($sql) or die ("could not create record 180");

if (@mysql_num_rows($query) == 0)
{
echo "unknown error, please try again";
echo " <a href=java script:history.back();>go back</a>";
exit;
}

[YappyDog]

The error is being caused by the parameter you are passing into the mysql_affected_rows() function. It is expecting a pointer to the database, not the query or query results.

Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource

I'd try your original code without the @ (so you can see any errors) and without any parameters for the mysql_affected_rows() function.

[stolzyboy]

you are connected to the database, right, cuz if you are

mysql_affected_rows() returns the number of rows affected by the last INSERT, UPDATE or DELETE query associated with link_identifier. If the link identifier isn't specified, the last link opened by mysql_connect() is assumed.

[stolzyboy]

also

Review the above carefully! mysql_affected_rows() works with connection handles returned by mysql_connect() or mysql_pconnect(), not with result handles returned by mysql_query() or mysql_db_query()

[tuf-web_co_uk]

well i tried mysql_num_rows and that still brought me the error message

i then did what yappydog said

$sql = "INSERT INTO custom (username, password, email, lname, fname, city, bgcolor, fontsize, fontface, fontcolor, link, active, visited, hover, linksize, linkface) VALUES ('$username', MD5('$password'), '$email', '$lname', '$fname', '$city', '$bgcolor', '$fontsize', '$fontface', '$fontcolor', '$link', '$active', '$visited', '$hover', '$linksize', '$linkface')";
				$query = mysql_query($sql) or die ("could not create record 180");
				$result = mysql_affected_rows();

			if ($result == 0)
			{

			echo "unknown error, please try again";
			echo " <a href=java script:history.back();>go back</a>";
			exit;

			}

and this didnt bring any errors up at all

this echoed my next piece of code which was

else {

				echo "user account created<br>";
				echo "thank you for joining theutherfish.coms customization program<br><br>";
				echo "<a href=login.php>login</a>";

				}

i then echoed $result to see that the output was and it was 1

so i guess this has worked excellent

thanks very much peeps 😃

Jon 😉