Hello all! I have a php script that pulls from the database and creates an XML file to create the markers for my map. This works great if I am pulling from one table, but I need to pull from two tables. Perhaps I have been overlooking something simple. My select statement is below. Does anyone see anything wrong? My two variables ($combine and $force) are defined further up the page.
$query = "SELECT engagement.engagement, engagement.combine, engagement.unionconfederate, battledescription.battle, battledescription.type, battledescription.lat, battledescription.lng, battledescription.date FROM engagement, battledescription where engagement.combine='$combine' && engagement.unionconfederate = '$force' && engagement.engagement = battledescription.battle"; I'd greatly appreciate any assistance. Chris -- You received this message because you are subscribed to the Google Groups "Google Maps API" 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-api?hl=en.
