Gossamer Forum: General: Databases and SQL: MySQL

Dec 14, 2002, 10:23 AM

alexluk88

New User (1 post)

Dec 14, 2002, 10:23 AM

Post #1 of 3

Shortcut

MySQL - ENCODE problem

Hi,

Need an urgent help!

I have a script like this:

mysql_db_query ($SQL_DB, "UPDATE admin SET
adminpassword = ENCODE($pwd, 'pass')
WHERE admin_id = '$admin_id'
");

for changing password. But it sometimes work and most of the time doesn't. When it doesn't work, the old password is not updated at all! It looks like the SQL statement is not processed. But I'm sure the problem did go through this statement as the next statement is run.

Please help...

Thanks,

Alex

Dec 14, 2002, 6:37 PM

Stealth

Veteran (17240 posts)

Dec 14, 2002, 6:37 PM

Post #2 of 3

Shortcut

Re: [alexluk88] MySQL - ENCODE problem In reply to

What is the value of $admin_id?
========================================
Buh Bye!

Cheers,
Me

Dec 16, 2002, 6:41 AM

Andy

Veteran / Moderator (18441 posts)

Dec 16, 2002, 6:41 AM

Post #3 of 3

Shortcut

Re: [alexluk88] MySQL - ENCODE problem In reply to

Add some debug info;

Code:
my $debug = 1; 

print "\$pwd is: " . $pwd . "<BR>" if $debug; 
print "\$admin_id is: " . $admin_id . "<BR>" if $debug; 

mysql_db_query ($SQL_DB, "UPDATE admin SET  
adminpassword = ENCODE($pwd, 'pass')  
WHERE admin_id = '$admin_id'  
");

See what that shows...

Also, are you grabbing any MySQL errors that may be returned?

Cheers

Andy (mod)
andy@ultranerds.co.uk