> $mysql query1
 > result
 > array[cityid][cityname]
 > mysql query2
 > result
 > array[cityid][cityname]
 > now what i want to do is kick out any doubles in my array
 > and resort them alphebetically by cityname ?!

It's difficult to answer this question without knowing more about the
context and the way you have your database laid out.

In any event, sorting stuff and getting removing duplicates is probably
better achieved in your mysql query than in php.

Something like this would get you close (you'll have to figure it out
for your database as you didn't give much to go on)...

SELECT cityid, DISTINCE(cityname) FROM my_table WHERE some = 'condition'
ORDER BY cityname

Basically, use DISTINCT() to remove duplicates and use ORDER BY to set
the display order.

CYA, Dave

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

Reply via email to