Reply to thread

Message: <blockquote data-quote="RastaLulz" data-source="post: 359027" data-attributes="member: 1">For one, you shouldn't be using mysql_* functions; it's depreciated as of PHP 5.5, and removed in PHP 7.Anyways, what's the point of $query1? You should already have that information from the initial query?You could accomplish what you're doing with just one query:[CODE]SELECT u.figure, u.username, u.groupid, u.rank, j.nameFROM users AS uINNER JOIN jobs AS jON j.jobid = u.groupidWHERE u.groupid = ?ORDER BY u.jobrank DESC[/CODE]</blockquote>