#1
|
||||
|
||||
Order by?
How do I order this by itemname? I still don't quite understand the new coding :/
Code:
$stmt = $GLOBALS['adopts']->select("items", array(), "shop ='{$this->shopname}'"); |
#2
|
||||
|
||||
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:
__________________
Mysidia Adoptables, a free and ever-improving script for aspiring adoptables/pets site. |
#3
|
||||
|
||||
This isn't ordering by cost...
Code:
$stmt = $adopts->join("adoptables_conditions", "adoptables_conditions.id = adoptables.id") ->select("adoptables", array(), "breed = 'short'", "1 ordered by cost ASC"); |
#4
|
|||
|
|||
@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. |
#5
|
||||
|
||||
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
__________________
Mysidia Adoptables, a free and ever-improving script for aspiring adoptables/pets site. |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to order adoptables? | Lonin | Questions and Supports | 2 | 05-10-2012 01:58 PM |
order Available Adoptables list | bluez | Questions and Supports | 4 | 06-21-2011 01:59 PM |
What's New? |
What's Hot? |
What's Popular? |