Hola gente,
tengo una duda que he buscado por la red pero no encuentro, y es que me he topado con esta consulta.
Código PHP:
$query = "select orderid from orders where
customerid = '" . $customerid . "' and
amount > (" . $_SESSION['total_price'] . "-.001) and
amount < (" . $_SESSION['total_price'] . "+.001) and
date = '" . $date . "' and
order_status = 'PARTIAL' and
ship_name = '" . $ship_name . "' and
ship_address = '" . $ship_address . "' and
ship_city = '" . $ship_city . "' and
ship_state = '" . $ship_state . "' and
ship_zip = '" . $ship_zip . "' and
ship_country = '" . $ship_country . "'";
y no se que funcion o que significa el valor
PARTIAL.
por otra parte tampoco se que función hace
amount
la tabla de la BD es la siguiente.
Código PHP:
create table orders
(
orderid int unsigned not null auto_increment primary key,
customerid int unsigned not null,
amount float(6,2),
date date not null,
order_status char(10),
ship_name char(60) not null,
ship_address char(80) not null,
ship_city char(30) not null,
ship_state char(20),
ship_zip char(10),
ship_country char(20) not null
)
type=InnoDB
DEFAULT CHARACTER SET utf8
COLLATE utf8_general_ci
;
Saludos