Output PHP MySQL REQUESTED DATE as XML and read it in HTML

I've been searching for tutorials all day, but I cannot find exactly what I'm looking for.

I want to store strings in MySQL such as: name: Location: Type: Price:

What I want is to retrieve some of the date and output it into xml and read it into html. I found a simple example here: http://demos.reynoldsftw.com/php-xml-jquery-ajax/theHTML.html and tons more like it but I cannot seem to find any that allow filtering as I don't want to get ALL of the da开发者_开发问答ta.

For example, a button that would set all "type" to restaurant and get only that.

Thanks!

It looks like you're looking for the WHERE clause. Basically:

SELECT LOCATION, TYPE, PRICE FROM STORES WHERE TYPE = 'restaurant'

You'd then be able to proceed exactly the same way that the tutorial does.