registeracy
SELECT o.id_order, c.email, c.firstname, c.lastname, d.product_name, o.payment, o.id_cart FROM tb_orders o INNER JOIN tb_customer c ON ( c.id_customer = o.id_customer ) INNER JOIN tb_order_detail d ON ( d.id_order = o.id_order ) WHERE o.delivery_number <> 1array(18) {
[0]=>
array(7) {
["id_order"]=>
string(5) "10695"
["email"]=>
string(29) ""
["firstname"]=>
string(10) "TEST LENKA"
["lastname"]=>
string(1) "K"
["product_name"]=>
string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ"
["payment"]=>
string(26) "COMGATE - platební brána"
["id_cart"]=>
string(5) "13827"
}
[1]=>
array(7) {
["id_order"]=>
string(5) "10696"
["email"]=>
string(29) ""
["firstname"]=>
string(10) "TEST LENKA"
["lastname"]=>
string(1) "K"
["product_name"]=>
string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ"
["payment"]=>
string(26) "COMGATE - platební brána"
["id_cart"]=>
string(5) "13828"
}
[2]=>
array(7) {
["id_order"]=>
string(5) "10778"
["email"]=>
string(29) ""
["firstname"]=>
string(10) "TEST LENKA"
["lastname"]=>
string(1) "K"
["product_name"]=>
string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ"
["payment"]=>
string(26) "COMGATE - platební brána"
["id_cart"]=>
string(5) "13924"
}
[3]=>
array(7) {
["id_order"]=>
string(5) "10820"
["email"]=>
string(22) ""
["firstname"]=>
string(7) "Tomáš"
["lastname"]=>
string(7) "Popelka"
["product_name"]=>
string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ"
["payment"]=>
string(26) "COMGATE - platební brána"
["id_cart"]=>
string(5) "13983"
}
[4]=>
array(7) {
["id_order"]=>
string(5) "11398"
["email"]=>
string(25) ""
["firstname"]=>
string(5) "Lenka"
["lastname"]=>
string(10) "Chvostová"
["product_name"]=>
string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ"
["payment"]=>
string(26) "COMGATE - platební brána"
["id_cart"]=>
string(5) "14689"
}
[5]=>
array(7) {
["id_order"]=>
string(5) "11413"
["email"]=>
string(32) ""
["firstname"]=>
string(6) "Pavel "
["lastname"]=>
string(9) "Schiller "
["product_name"]=>
string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ"
["payment"]=>
string(26) "COMGATE - platební brána"
["id_cart"]=>
string(5) "14710"
}
[6]=>
array(7) {
["id_order"]=>
string(5) "11421"
["email"]=>
string(24) ""
["firstname"]=>
string(5) "Tomas"
["lastname"]=>
string(7) "Vondra "
["product_name"]=>
string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ"
["payment"]=>
string(26) "COMGATE - platební brána"
["id_cart"]=>
string(5) "14720"
}
[7]=>
array(7) {
["id_order"]=>
string(5) "11632"
["email"]=>
string(17) ""
["firstname"]=>
string(5) "Marko"
["lastname"]=>
string(6) "Haspel"
["product_name"]=>
string(21) "VOUCHER FOR 5 TICKETS"
["payment"]=>
string(26) "COMAGATE - payment gateway"
["id_cart"]=>
string(5) "14988"
}
[8]=>
array(7) {
["id_order"]=>
string(5) "12016"
["email"]=>
string(18) ""
["firstname"]=>
string(10) "Vladislava"
["lastname"]=>
string(10) "Benešová"
["product_name"]=>
string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ"
["payment"]=>
string(26) "COMGATE - platební brána"
["id_cart"]=>
string(5) "15464"
}
[9]=>
array(7) {
["id_order"]=>
string(5) "12018"
["email"]=>
string(18) ""
["firstname"]=>
string(10) "Vladislava"
["lastname"]=>
string(10) "Benešová"
["product_name"]=>
string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ"
["payment"]=>
string(26) "COMGATE - platební brána"
["id_cart"]=>
string(5) "15467"
}
[10]=>
array(7) {
["id_order"]=>
string(5) "12019"
["email"]=>
string(18) ""
["firstname"]=>
string(10) "Vladislava"
["lastname"]=>
string(10) "Benešová"
["product_name"]=>
string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ"
["payment"]=>
string(26) "COMGATE - platební brána"
["id_cart"]=>
string(5) "15468"
}
[11]=>
array(7) {
["id_order"]=>
string(5) "13362"
["email"]=>
string(20) ""
["firstname"]=>
string(5) "Karel"
["lastname"]=>
string(6) "Šmíd"
["product_name"]=>
string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ"
["payment"]=>
string(26) "COMGATE - platební brána"
["id_cart"]=>
string(5) "17219"
}
[12]=>
array(7) {
["id_order"]=>
string(5) "13510"
["email"]=>
string(27) ""
["firstname"]=>
string(8) "Veronika"
["lastname"]=>
string(9) "Strossova"
["product_name"]=>
string(54) "25.3.2023 ŽIVÁ EXOTIKA (Vstup od / Entry from: 9:00)"
["payment"]=>
string(26) "COMGATE - platební brána"
["id_cart"]=>
string(5) "17415"
}
[13]=>
array(7) {
["id_order"]=>
string(5) "13681"
["email"]=>
string(8) "dvsyd@ff"
["firstname"]=>
string(2) "dv"
["lastname"]=>
string(4) "dfvs"
["product_name"]=>
string(55) "15.4.2023 ŽIVÁ EXOTIKA (Vstup od / Entry from: 10:30)"
["payment"]=>
string(26) "COMGATE - platební brána"
["id_cart"]=>
string(5) "17635"
}
[14]=>
array(7) {
["id_order"]=>
string(5) "14649"
["email"]=>
string(28) ""
["firstname"]=>
string(10) "Drahoslava"
["lastname"]=>
string(8) "Loudová"
["product_name"]=>
string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ"
["payment"]=>
string(26) "COMGATE - platební brána"
["id_cart"]=>
string(5) "18871"
}
[15]=>
array(7) {
["id_order"]=>
string(5) "14973"
["email"]=>
string(25) ""
["firstname"]=>
string(6) "Nikola"
["lastname"]=>
string(10) "Pazderová"
["product_name"]=>
string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ"
["payment"]=>
string(26) "COMGATE - platební brána"
["id_cart"]=>
string(5) "19271"
}
[16]=>
array(7) {
["id_order"]=>
string(5) "14974"
["email"]=>
string(25) ""
["firstname"]=>
string(6) "Nikola"
["lastname"]=>
string(10) "Pazderová"
["product_name"]=>
string(29) "DÁRKOVÝ POUKAZ NA 5 VSTUPŮ"
["payment"]=>
string(26) "COMGATE - platební brána"
["id_cart"]=>
string(5) "19272"
}
[17]=>
array(7) {
["id_order"]=>
string(5) "15712"
["email"]=>
string(18) ""
["firstname"]=>
string(5) "Hoang"
["lastname"]=>
string(3) "Nam"
["product_name"]=>
string(21) "VOUCHER FOR 5 TICKETS"
["payment"]=>
string(26) "COMAGATE - payment gateway"
["id_cart"]=>
string(5) "20228"
}
}