Update does not work...but no errors either

[Ryan S <genphp@xxxxxxxxx>]

 Hey,

This is my code:
==============================================================
$update_sql="update greetings_final set heading='$heading',message='$message',signature='$signature',font_size='$font_size',font_color='$font_color',bg_color='$bg_color' where  temp_cno='".$thecno."' and rand_string='".$randreference."' LIMIT 5";
echo $update_sql."<br><br>";
        $result2 = mysql_query($update_sql);
        if(mysql_affected_rows()==0){echo "Error R093d: unable to update greeting";exit;}
==============================================================
As you can see above, i have a echo to show me the exact SQL being run
and also a mysql_affected_rows check to spit out an error if no rows get updated
but for some reason.... no rows are getting updated but mysql is not echoing that error message plus
the sql is running perfectly if i copy and paste it from the echo into phpmyadmin

any ideas?

Thanks!
R


      

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php