TalkPHP - View Single Post

Alan @ CIT · 10-24-2009, 07:38 PM

You're using mysql_num_rows() in 2 places and I'm guessing that it is the second one (after the INSERT) that is causing the error?

mysql_num_rows() only works on SELECT statements, for your INSERT statement, try using mysql_affected_rows() instead - that should return 1 if the new info was inserted into the database, or -1 if there was a problem.

More info: http://uk.php.net/manual/en/function...ected-rows.php

10-24-2009, 07:38 PM	#3 (permalink)
Alan @ CIT Member of the Month The Frequenter Join Date: Apr 2005 Location: South UK Posts: 483 Thanks: 51	You're using mysql_num_rows() in 2 places and I'm guessing that it is the second one (after the INSERT) that is causing the error? mysql_num_rows() only works on SELECT statements, for your INSERT statement, try using mysql_affected_rows() instead - that should return 1 if the new info was inserted into the database, or -1 if there was a problem. More info: http://uk.php.net/manual/en/function...ected-rows.php