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