MyBB Community Forums

MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > Simple Select and Order by 2 Columns (MyBB Database Class)
Full Version: Simple Select and Order by 2 Columns (MyBB Database Class)
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

RyanDiamond

2013-10-17, 08:14 PM
I'm trying to select all teams in the league and order them by their wins, and then by their amount of ties. It's only letting me put in 1 order clause.. any help?

This is what I currently have that orders by JUST wins.. the column for ties is 'record_ties'.

Thanks![/php]

$db->simple_select("teams", "*", "`league` = '".$db->escape_string($_GET[id])."'", array("order_by" => "record_wins", "order_dir" => "DESC"));

Matt

2013-10-18, 07:53 AM
You can just pass it in as a string.

$db->simple_select("teams", "*", "`league` = '".$db->escape_string($_GET[id])."'", array("order_by" => "record_wins DESC, record_ties DESC"));

Also, I'd change:

$db->escape_string($_GET[id])

to:

intval($mybb->input['id'])

All POST and GET data is available in $mybb->input, some common parameters are pre-sanitised too. Using $_POST and $_GET directly is kinda messy, just make sure you've globalised $mybb in your function.

Happy Friday! Smile
MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > Simple Select and Order by 2 Columns (MyBB Database Class)