redarrow Posted February 7, 2007 Share Posted February 7, 2007 hi there advance thank you. If you have 2 member databases and one is encripted via md5 and the other issent how do you use a select statement to get in for example as one is encripted and the other issent. example select statement how do you get the password to be reconise as a md5 in a select statement. select * from members where name='$name' and PASSWORD('$password'); how is it done cheers. Link to comment https://forums.phpfreaks.com/topic/37493-password-problams-need-advice-please-cheers/ Share on other sites More sharing options...
Balmung-San Posted February 7, 2007 Share Posted February 7, 2007 If they're in two different databases then as far as I'm aware you can't get them both with one SELECT statement. You'd have to drag the data from one, then change databases, and get the data from that one. You'd then have to md5 the unencrypted one (why is it unencrypted anyway?), and do a comparison between the two. Link to comment https://forums.phpfreaks.com/topic/37493-password-problams-need-advice-please-cheers/#findComment-179313 Share on other sites More sharing options...
redarrow Posted February 7, 2007 Author Share Posted February 7, 2007 ok it works if the two are unencripted, so in essance if i encrept the unencrited one then it will work yes. Link to comment https://forums.phpfreaks.com/topic/37493-password-problams-need-advice-please-cheers/#findComment-179316 Share on other sites More sharing options...
Balmung-San Posted February 7, 2007 Share Posted February 7, 2007 It should. Link to comment https://forums.phpfreaks.com/topic/37493-password-problams-need-advice-please-cheers/#findComment-179317 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.