Dibatalkan

Easy & Fast mysql query correct

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.

Best Regards,

If you are familar with mysql, you can do it within 1 minute.

I also test this code, not display.

$customers_query = tep_db_query("select o.orders_id, o.date_purchased, c.lat, c.lng from ". TABLE_ORDERS ." as o, ". TABLE_ORDERS_TO_LATLNG ." as 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 ");

seems the issue are here:

and o.date_purchased between "' . $qstartdate . ' 00:00" and "' . $qenddate . ' 23:59" group by o.orders_id

Kemahiran: Troli Membeli-belah

Lihat lebih lanjut: int map, group o, double escrow, fast mysql query, fast mysql searching, easy escrow, query table, null, mysql query, int, easy c, C easy, google query, mysql amp, fast work, google map select, mysql check, mysql create table, mysql osc, map select, order mysql, confirm order oscommerce, primary key, work order mysql, oscommerce google map

Tentang Majikan:
( 0 ulasan ) HongKong, China

ID Projek: #356045