Jump to content

Archived

This topic is now archived and is closed to further replies.

bilis_money

How to verify a successful UPDATE?

Recommended Posts

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... :)

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
The manual (sigh..):

[url=http://nl3.php.net/manual/en/function.mysql-affected-rows.php]mysql_affected_rows()[/url]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.