[RESOLVED] PDO: results not sorting

[mrhinman]

Assuming $field and $sortOrder are set as columns, why do my results never ORDER BY properly? I've even tried adding "ASC" and the results still come out in the wrong order.

Ideas? PS: I am VERY new to PDO.

		$gstmt = $CONN->prepare("SELECT * FROM table WHERE field = :category ORDER BY :sortorder LIMIT 0,25");
		$gstmt->execute(array(":category" => $field,":sortorder" => $sortOrder));

[Weedpacket]

You can't parameterise column names; they're not values.

At best what you'll get is "ORDER BY 'some literal string'", and the records will be ordered according to whether 'some literal string' is < or = or > 'some literal string' - in other words, no ordering at all.

[mrhinman]

Sorry, I meant values that would be in those columns... Problem remains. In fact, this return the desired results fine - but in the wrong order. I need them ordered by a particular column.

[mrhinman]

Nevermind.... I see what you meant on that and I fixed it!