PatPHP Posted August 25, 2008 Share Posted August 25, 2008 Hi Guys I programmed a small project which worked great on my test machine windows. Then I copied everything to a linux box and now I get an error if a query doesn't return anything and I run mysql_affected_rows afterwards. I thought if it doesn't return anything it mysql_affected_rows should be zero. Is this a setting in php???? Or what is the way around that? Thx pat Link to comment https://forums.phpfreaks.com/topic/121161-solved-mysql_affected_rows-error/ Share on other sites More sharing options...
PFMaBiSmAd Posted August 25, 2008 Share Posted August 25, 2008 Your query failed, either due to no connection to the database server, no database selected, or an sql syntax error and your code has no error checking logic and it blindly executed a mysql_affected_rows() statement on a non-existent result resource (a query that works but has zero rows returns a valid result resource and does not produce the error you are getting.) Link to comment https://forums.phpfreaks.com/topic/121161-solved-mysql_affected_rows-error/#findComment-624599 Share on other sites More sharing options...
PatPHP Posted August 25, 2008 Author Share Posted August 25, 2008 Hi I found the error. I had two databases opened but used the mysql_affected_rows on the wrong one which was MS Sql server. Thank you very much. Link to comment https://forums.phpfreaks.com/topic/121161-solved-mysql_affected_rows-error/#findComment-624611 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.