We now use osc and google map.
We have two TABLE : order & orders_to_latlng
CREATE TABLE `orders_to_latlng` (
`id` INT NOT NULL AUTO_INCREMENT ,
`orders_id` INT NOT NULL ,
`lat` DOUBLE NOT NULL ,
`lng` DOUBLE NOT NULL ,
PRIMARY KEY ( `id` )
) TYPE = MYISAM ;
We need get [url removed, login to view] and [url removed, login to view] based TABLE order & date_purchased.
We use the following code, but seems it can't work.
Would you please give your advise asap?
$customers_query_raw = 'SELECT o.`orders_id` , o.`date_purchased` , c.`lat`, c.`lng` FROM orders o, orders_to_latlng c WHERE o.orders_id = c.orders_id and o.date_purchased between "' . $qstartdate . ' 00:00" and "' . $qenddate . ' 23:59" group by o.orders_id;';
$customers_query = tep_db_query($customers_query_raw);
while ($customers = tep_db_fetch_array($customers_query))
echo $customers['lat'] . "," . $customers['lng'] . "), \"" . $customers['orders_id'] . "\", \"" <br>";
Max. bidder 10USD. No escrow. after check and confirm and do payment.