mysql - phpMyAdmin, join 2 tables, export XML for Google Maps and Google Earth -
i trying launch events site utilising google maps , google earth.
i trying same results when joining 2 tables using php using phpmyadmin can export xml , use it.
the tables joining are:
bdt
table holding general info business , other events named specials
.
i have 2 select statements on each page provide results looking for, need same results in phpmyadmin can export xml. problem when join tables 1 record/event displayed each user. trying events each user date >=
today.
select bdt.*, specials.* bdt join specials on bdt.id = specials.id bdt.active = 'yes' group bdt.id order specials.price asc; select bdt.*, specials.* bdt inner join specials on bdt.id = specials.id bdt.active = 'yes' , specials.date >= curdate() , bdt.id = $row-today-id$ group specials.title order specials.date, specials.price asc limit 7;
Comments
Post a Comment