$query = mysql_query('SELECT * FROM submissions ORDER BY (votes * id) DESC');
This gives me an error. Is there any way to do this?
$query = mysql_query('SELECT * FROM submissions ORDER BY (votes * id) DESC');
This gives me an error. Is there any way to do this?
SELECT *, (votes * id) AS x FROM submissions ORDER BY x DESC
You will have one column more but i guess i will work =|