i would like to ask a question that pertains to exporting xml to be used in a google earth .kml file.
my map incorporates daily specials for local businesses. i am joining two tables to accomplish this. bdt which is a general contact information table and specials which is the daily specials table and exporting the .xml file then style with xslt.
i am manually exporting the .xml by running these querys in phpmyadmin but i cannot get the same results as i get when using the select statement that works with my html page, because I only get one row from the specials table when i join with bet.i want to get all of the records over the next 7 days and i have tried creating views as well as many other changes to no avail.
$query_today = "SELECT bdt.*, specials.* FROM bdt INNER JOIN specials ON bdt.id = specials.id2 WHERE bdt.active='yes' and specials.date >= CURDATE() AND date = CURDATE() AND date
my map incorporates daily specials for local businesses. i am joining two tables to accomplish this. bdt which is a general contact information table and specials which is the daily specials table and exporting the .xml file then style with xslt.
i am manually exporting the .xml by running these querys in phpmyadmin but i cannot get the same results as i get when using the select statement that works with my html page, because I only get one row from the specials table when i join with bet.i want to get all of the records over the next 7 days and i have tried creating views as well as many other changes to no avail.
$query_today = "SELECT bdt.*, specials.* FROM bdt INNER JOIN specials ON bdt.id = specials.id2 WHERE bdt.active='yes' and specials.date >= CURDATE() AND date = CURDATE() AND date