[yazz_1988]

Hi guys!
For my bus finder application, so far i've gotten searching by routenumber to work (big thanks to the community here ), now i would like to extend upon that and add searching by name too. I'm semi-decent at writing queries but coding, not so much.
I have got the query to work but the coding part i am unsure about.

the query is something like this

PHP Code:

$query = "SELECT * FROM mydata WHERE stopname LIKE '%$areaname%' AND routerun = 1 GROUP BY routenumber ORDER BY routenumber"; 

This is something i would like to achieve.
The user enters "London Bridge" in the 2nd text box area and the page will output the routes with clickable links. But i only want to route numbers to be displayed.
Can this be done or is it too good to be true.

http://i.imgur.com/y2twO.png

The working example for the route number search is at this page > bus finder map .

Can you please help me out here if possible.
Thanks in advance.

[davidw199]

Well, I noticed in your ajax code, function downloadUrl is the one that gets xml data that contains all stopnames for a particular route number. The data is returned from this page
xmlgen.php?routeno=53&routerun=1

Well, in this xmlgen.php file, you can add more php code that will accepts 1 one more parameter. Let's call this parameter "areaname".

So, if areaname exists in form post, then use the query you described above and return the correct data.
And the ajax called would be something like
xmlgen.php?areaname=London%20Bridge&routerun=1

I hope this is clear enough. I don't see the code you have in xmlgen.php, so I can't tell you exactly what php code you should write, but that is the general direction that you can follow.

Dave