Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2002091

[PHP-DB] Re: assist with SORT array From: Bartosz Matosiuk (madsiuk <email protected>)
Date: 09/09/02

I'm sorry if I haven't undersood your post well, but my english is not very
good. Anyway what I understood is that you want to sort the result by the
name of restaurant. So mayby it would be a better idea not to sort the
result array, but sort the query:
SELECT name FROM restaurants WHERE id=$rest_id ORDER BY name;
Using that statement you will receive array with sorted restaurants names.

Terry Romine <eatrom <email protected>> wrote in message
news:A068A388-C432-11D6-899A-0050E405DA44 <email protected>
> I have a head scratcher.. prob just a glitch on my side, but somehow I
> am confused with the results.
>
> I have a php script pulling from a mysql database for id/names which is
> getting choices through a check box form. All of that works just fine,
> but I wanted to display the results sorted by title. My snippet of code
> is:
>
> // $restaurants = array() of ids back from form
> for($i=0;$i<sizeof($restaurants);$i++) {
> $rest_id = $restaurants[$i];
> $sql="select name from restaurants where id=$rest_id";
> $result=mysql_query($sql) or die($sql . mysql_error());
> while($row=mysql_fetch_object($result)) {
> $rest_name .= ucwords(stripslashes($row->name)) . ";";
> }
> }
> $rest_array=explode(";",$rest_name);
>
> $rest_sort=sort($rest_array); // <-- the problem line
>
> die("checking: $rest_name<br><br> size =
> ".sizeof($rest_array) . " sorted: " . sizeof($rest_sort));
>
> the results come back with 6 in the $rest_array but only 1 in the
> $rest_sort array! How is that??
>
> checking: Hi-Ho Tavern;Village Inn;Speak Easy;Duane's House Of
> Pizza;Atomic Coffee;
> size = 6 sorted: 1
>
> What I am trying to accomplish is an array('Atomic Coffee', 'Duane's
> House Of Pizza','Hi-Ho Tavern','Speak Easy','Village Inn')
>
> Help??
>
> Terry Romine
> Web Developer
> JumpInteractive.com
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php