INSERT error

abasel

I must be gettting tired as I can't see the problem here.

The following code successfully inserts the data into the table but also returns the following error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/intern/public_html/dev/actions/dd-createuser.php on line 977

$query = "INSERT into tblusers SET
accountno ='$accountno',
firstname = '$firstname',
surname = '$surname',
title = '$title',
email = '$email',
telh = '$telh',
telw = '$telw',
telm = '$telm',
telf = '$telf',
address1 = '$address1',
address2 = '$address2',
suburb = '$suburb',
city = '$city',
code = '$code',
country = '$country'";
$result = mysql_query($query) or die('Query failed. ' . mysql_error());

If the insert takes place, why do I get the error and how come the $query variable is not valid?

tomhath

What are you passing to mysql_num_rows? $query or $result?

NogDog

mysql_num_rows() is for select queries (or other queries that return rows of result data). You want to use [man]mysql_affected_rows/man for an insert query.

abasel

Thanks for that.. VIVA l'Internet :-) I don't know how I would have got as far as I have without the input of a helpful and friendly Internet community.

abasel

I now get

Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource in /home/intern/public_html/dev/actions/dd-createuser.php on line 977

$query = "INSERT into tblusers SET
			accountno ='$accountno',
			firstname = '$firstname',
			surname = '$surname',
			title = '$title',
			email = '$email',
			telh = '$telh',
			telw = '$telw',
			telm = '$telm',
			telf = '$telf',
			address1 = '$address1',
			address2 = '$address2',
			suburb = '$suburb',
			city = '$city',
			code = '$code',
			country = '$country'";
$result = mysql_query($query) or die('Query failed. ' . mysql_error());
if (mysql_affected_rows($result) == 1) {[I] .... the rest of my code[/I] }

NogDog

The optional argument to mysql_affected_rows() is a MySQL connection resource ID, not a query result resource ID. So either change it to mysql_affected_rows[$xxx] where $xxx is the result of your mysql_connect() command, or just use it without any argument (which is sufficient in 99.999% cases).