Ha Thanks Davie. Yeah I tried that and it wasn't working how I needed it to. Thanks though.
On Fri, Apr 15, 2011 at 4:28 AM, davie <[email protected]> wrote: > Hi > I may be a bit late on this thread but you can order on multiple > columns > SELECT * > FROM table > ORDER BY state, distance ASC > Regards Davie > > On Mar 31, 9:34 pm, Mike Wellman <[email protected]> wrote: > > This may be the wrong area for this but not sure where to turn. > > > > I trying out the code from here: > http://code.google.com/apis/maps/articles/phpsqlsearch_v3.html > > > > I split up the database so that state is in it's own column. > > > > The problem that I am dealing with is I would like my listings in the > > sidebar to Order ASC BY distance (which I got this to do) but also group > by > > state but not do the normal mysql grouping into one. > > > > For instance, this is what it is doing: > > Location 1, PA: 18.2mi > > Location 2, PA: 20.4mi > > Location 3, WV: 25.9mi > > Location 4, OH: 31.1mi > > Location 5, PA: 52.6mi > > Location 6, PA: 78.2mi > > > > What I would like it to do is: > > Location 1, PA: 18.2mi > > Location 2, PA: 20.4mi > > Location 5, PA: 52.6mi > > Location 6, PA: 78.2mi > > Location 3, WV: 25.9mi > > Location 4, OH: 31.1mi > > > > Anyone have any thoughts on this or could point me into the right > direction. > > > > I am currently trying to use temp tables in mysql to see if that might > help. > > > > Any incite would be appreciated. > > > > Thanks > > -- > You received this message because you are subscribed to the Google Groups > "Google Maps JavaScript API v3" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/google-maps-js-api-v3?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google Maps JavaScript API v3" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-maps-js-api-v3?hl=en.
