bilis_money Posted August 23, 2006 Share Posted August 23, 2006 let say i have updated the table records successfully with these codes below.[code]$query = "UPDATE topics SET title='$$title_tmp', escription='$descrip_tmp', url='$url_tmp' WHERE title='$title_tmp'";mysql_query($query) or die("Update failed!<br>".mysql_error());[/code]ok, let say the query was executed and the mysql_error() didn't throw me an error message and means it was updated successfully.now how do i check this if it is really was successful?i know i can compare the $title_tmp both previous data and in the newly modified submitted data in the table.But i'm hoping that you have better solution ideas than this of mine.What is your style?Advance lightning THANKS 2 YOU all my PHP comrades... :) Quote Link to comment Share on other sites More sharing options...
Orio Posted August 23, 2006 Share Posted August 23, 2006 Why shouldn't it work if no error was outputed?If you really want to double check (tho I find it a waste of resources), select the rows you updated and compare with the variables...Orio. Quote Link to comment Share on other sites More sharing options...
448191 Posted August 23, 2006 Share Posted August 23, 2006 The manual (sigh..):[url=http://nl3.php.net/manual/en/function.mysql-affected-rows.php]mysql_affected_rows()[/url] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.