Aries, while im a big support of one of crims favourite acronymns: RTFM. Asking for small bits of code will also help you learn. Thats if you read over the code, and begin to understand what each thing/line does.
Most of it was either for a project of mine, or paid work. But yeh, i really cannot be bothered arguing anymore, and its an opinion whos code is neater. So that would be quite an unfair test. :)
$Cmarket_info = ($db->fetch_single($db->query("SELECT cm.*, u.*
FROM crystalmarket cm
LEFT JOIN users u
ON u.userid = cm.cmADDER
ORDER BY cmPRICE/cmQTY ASC
")));
Is wrong.
Doesnt need anything before the $db->query