Forums

md5 in adodb?

Permalink
nice to see u again~

i wonder why this query doesnt work in c5, but i tested in phpmyadmin and its work, show 2 result
$db = Loader::db();
$sql = 'SELECT link_id FROM btsmart WHERE MD5( link_id ) = "b8c37e33defde51cf91e1e03e51657da"';
$query = $db->query($sql);
while ($order = $query->fetchRow()){
//result here
}


if i change sql to this, it's work, show 2 result
$sql = 'SELECT link_id FROM btsmart WHERE link_id = "1001"';


how can i use that md5?

Tq.
fastcrash
 

This website stores cookies on your computer. These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media. To find out more about the cookies we use, see our Privacy Policy.