| |
|
|
| | Eto moi kodi:
$countries = "SELECT ex_orders.orders_status,ex_orders.customers_country,countries.countries_name, ex_orders_status.orders_status_payed ";
$from = "FROM (ex_orders INNER JOIN ex_orders_status ON ex_orders.orders_status=ex_orders_status.orders_status_payed ) " .
"INNER JOIN countries ON ex_orders.customers_country=countries.countries_name ";
$where = "WHERE ex_orders.date_purchased BETWEEN '".guion($fromdate)."' AND '".guion($todate)."'AND ex_orders.customers_country=countries.countries_name AND ".$nonepaid."ex_orders.orders_status=ex_orders_status.orders_status_payed "
|
Eto moi zapros vdata base
Dalshe doljno idti uslovie tipa takogo: esli ptichka stoit to pokazat tolko dannie dlya klientov, kotorie zaplatili
Esli ptichki net, to pokazat vse dannie.
Kak eto sdelat, pomogite pojaluista,!!!!!!!!!!!!!!!!!!!
A eto html kod:
<table align="rigth">
<td align="rigth"><input type="checkbox" name="nonepaid" CHECKED > Include non paid orders </td>
</table>
|
| |
| |
|
|
| |
|
|
| |
для: kaya
(11.04.2010 в 11:13)
| | | http://translit.ru/
========== (c) kaya ====
Это мой код:
$countries = "SELECT ex_orders.orders_status,ex_orders.customers_country,
countries.countries_name, ex_orders_status.orders_status_payed ";
$from = "FROM (ex_orders
INNER JOIN ex_orders_status
ON ex_orders.orders_status=ex_orders_status.orders_status_payed )
INNER JOIN countries
ON ex_orders.customers_country=countries.countries_name ";
$where = "WHERE ex_orders.date_purchased BETWEEN '".guion($fromdate).
"' AND '".guion($todate).
"'AND ex_orders.customers_country=countries.countries_name AND ".$nonepaid.
"ex_orders.orders_status=ex_orders_status.orders_status_payed "
|
Это мой запрос в БД
Дальше должно идти условие типа такого: если птичка стоит то показать только данные для клиентов, которие заплатили
Если птички нет, то показать все данние.
Как это сделать, помогите пожалуйста,!!!! | |
| |
|
|
| |
|
|
| |
для: Trianon
(11.04.2010 в 11:15)
| | | Cпасибо, | |
| |
|
|
