[tjdrico]

What about:

PHP Code:

$q = "SELECT u.username, CONVERT(p.".$vboptions['uttpoints_pointsfield'].", SIGNED) AS cash FROM " . TABLE_PREFIX . $vboptions['uttpoints_pointtable']." AS p LEFT JOIN " . TABLE_PREFIX . "user AS u ON u.userid=p.userid ORDER BY p.".$vboptions['uttpoints_pointsfield']." DESC LIMIT 5"; 


Maybe your version of mySQL handles the +0 differently. The CONVERT() function should be the same though I think. I'm not sure about older versions of mySQL - this manual is for 4.0.9

Oh, I just read that "The CAST() and CONVERT() functions were added in MySQL 4.0.2. " so if you're on mySQL 3 then it'll still be unhappy. =) I'll look some more.