iv been playing with this alsp
Code:if(!define('SALT')) define('SALT','n7g7b8necefAs5ecrEv3M72ra'); $salt = SALT; // from my understanding so far , you can't use a wild card in the select because AES_DECRYPT needs to be called inside the query. MySQL is actually doing the processing not PHP. $result = mysql_query("SELECT id,username,AES_DECRYPT('password','$sql') FROM accounts"); while($row = mysql_fetch_array($result)) { //now heres the problem Im running into. When the data is returned it looks like this : echo $row['AES_DECRYPT(password,n7g7b8necefAs5ecrEv3M72ra)']; //I really need it to come back like: $row['oassword']; }




Reply With Quote