Order by?
How do I order this by itemname? I still don't quite understand the new coding :/
Code:
|
Well just pass ORDER BY to the whereclause, if you have a whereclause. Incase you do not have a whereclause(and thus selecting all rows), you can do the following:
PHP Code:
|
This isn't ordering by cost...
Code:
$stmt = $adopts->join("adoptables_conditions", "adoptables_conditions.id = adoptables.id") |
@Silver Kitsune
Yeah sorry about that. The new release will include a much better database class. Although I won't say that it's comprehensive or anything, but it should suffice for most of the needed queries. But anyway, the right keyword is ORDER BY not ORDERED BY. |
Oh my goodness, made a typo in that php code I wrote. Didnt realize that since I did say 'ORDER BY' at the beginning of my post, did I? XD
|
All times are GMT -5. The time now is 05:24 PM. |
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.