Re: assist with SORT array

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@blazing-trails.com> wrote in message news:A068A388-C432-11D6-899A-0050E405DA44@blazing-trails.com... > 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 >