You could do it this way WHERE column LIKE 's%' ORDER BY column
Now you'll get all rows sorted and where column is staring with an 's' or 'S' ------------------------------------------------------------- On 28-03-02 at 17:30 Sebastian A. wrote: ------------------------------------------------------------- >When you say "ORDER BY that", is it also possible to do that via letters >such as ORDER BY 'S', because from what I understand, ORDER BY has to be a >column. > >-----Original Message----- >From: Jason Wong [mailto:[EMAIL PROTECTED]] >Sent: Thursday, March 28, 2002 3:49 PM >To: [EMAIL PROTECTED] >Subject: Re: [PHP] SQL Question > >On Thursday 28 March 2002 22:34, Sebastian A. wrote: >> How do I sort out data from mysql_fetch_row() or mysql_fetch_array? For >> example say I wanted to list all my users alphabetically. How would I do >> this? Or say I had a form and I wanted to present the content to the user >> *AFTER* they have filled it out so that they can check for mistakes. >> Mysql_fetch_row() returns all the rows in a field, so I would guess that >I >> have to sort using PHP. Can anyone provide me with an idea as to how I >> could accomplish this? > >1) This type of question should best be posted to the php-db list. > >2) Sorting should best be done from mysql using the ORDER BY clause: > > SELECT this, that, the, other > FROM table > ORDER BY that > >3) If you insist on sorting in PHP then read all the rows from your query >into an array and use one of the array sort functions -- asort() etc. > > > >-- >Jason Wong -> Gremlins Associates -> www.gremlins.com.hk > >/* >Things are more like they used to be than they are now. >*/ > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
