peranha Posted January 7, 2008 Share Posted January 7, 2008 // create query $query1 = "UPDATE " . $pre . "users SET password='$passwordHash' WHERE uniqueid = '$_SESSION[uniqueid]'"; // execute query $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); I cannot see anything wrong with this, but when run, it will not update the database. Quote Link to comment https://forums.phpfreaks.com/topic/84804-solved-query-not-working/ Share on other sites More sharing options...
redarrow Posted January 7, 2008 Share Posted January 7, 2008 are you posting the varibles m8.... and are u useing mysql_real_esacpe_string() to serilize the database entrys... Quote Link to comment https://forums.phpfreaks.com/topic/84804-solved-query-not-working/#findComment-432316 Share on other sites More sharing options...
peranha Posted January 7, 2008 Author Share Posted January 7, 2008 Yes I am, I echo them out on the page, and they are there, yes i do escape them as well Quote Link to comment https://forums.phpfreaks.com/topic/84804-solved-query-not-working/#findComment-432319 Share on other sites More sharing options...
redarrow Posted January 7, 2008 Share Posted January 7, 2008 try now saw the problam <?php $query1 = "UPDATE " . $pre . "users SET password='$passwordHash' WHERE uniqueid = '$_SESSION[uniqueid]'"; $result = mysql_query($query1) or die ("Error in query: $query. ".mysql_error()); ?> Quote Link to comment https://forums.phpfreaks.com/topic/84804-solved-query-not-working/#findComment-432320 Share on other sites More sharing options...
peranha Posted January 7, 2008 Author Share Posted January 7, 2008 Thanks, Completely missed that. Quote Link to comment https://forums.phpfreaks.com/topic/84804-solved-query-not-working/#findComment-432322 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.