gaffafoote Posted May 9, 2007 Share Posted May 9, 2007 Hi there. I am pulling information from my database and populating some forms with this information. This is in the aim of letting the user UPDATE information. If the user then changes their mind about changing the values and leaves them the same, the query then tries to update the fields with the same values as they already contain. This then causes my scripts to stop yet mysql_error is not bringing back any information. § $query = "UPDATE fp_tags SET tag1='$tag1', tag2='$tag2', tag3='$tag3' WHERE page_id='$tid'"; $result = @mysql_query ($query) OR DIE(mysql_error()); echo '<p>'.mysql_error() .'<br /><br />This error relates to this query: ' .$query. Yours with bleary eyes, Gareth Quote Link to comment https://forums.phpfreaks.com/topic/50579-updating-the-same-values-to-db/ Share on other sites More sharing options...
btherl Posted May 9, 2007 Share Posted May 9, 2007 Try "echo $query;", and take a look at it. Also try adding this: ini_set('display_errors', 1); That'll make sure php tells you why it is stopping. If you're still having trouble, post your entire script here and we'll take a look Quote Link to comment https://forums.phpfreaks.com/topic/50579-updating-the-same-values-to-db/#findComment-248792 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.