Da ich ja ein wenig ein Ordnungsfanatiker bin, schreibe ich die SQL-Befehle immer in Großbuchstaben.
Das heißt statt
SELECT xyz FROM xyz WHERE x = 1
schreibe ich immer
SELECT xyz FROM xyz WHERE x = 1
Nun erlebe ich gerade etwas sehr kurioses. Aus folgendem Query:
$cc_query_raw = "select c.coupon_id, c.coupon_code, c.coupon_amount, c.coupon_type, c.coupon_start_date, c.coupon_expire_date, c.uses_per_user, c.uses_per_coupon, c.restrict_to_products, c.restrict_to_categories, c.date_created, c.date_modified, c.coupon_active, cd.coupon_name from " . TABLE_COUPONS ." c," . TABLE_COUPONS_DESCRIPTION . " cd where cd.coupon_id = c.coupon_id and cd.language_id = '" . $_SESSION['languages_id'] . "'" . $where_status . $where_search . $where_type . $sort;
habe ich dieses gemacht
$cc_query_raw = "SELECT c.coupon_id, c.coupon_code, c.coupon_amount, c.coupon_type, c.coupon_start_date, c.coupon_expire_date, c.uses_per_user, c.uses_per_coupon, c.restrict_to_products, c.restrict_to_categories, c.date_created, c.date_modified, c.coupon_active, cd.coupon_name FROM " . TABLE_COUPONS ." c," . TABLE_COUPONS_DESCRIPTION . " cd WHERE cd.coupon_id = c.coupon_id AND cd.language_id = '" . $_SESSION['languages_id'] . "'" . $where_status . $where_search . $where_type . $sort;
und schon kommt folgender SQL-Fehler:
1064 - You have an error IN your SQL syntax; CHECK the manual that corresponds TO your MySQL server version FOR the RIGHT syntax TO USE near 'SELECT c.coupon_id, c.coupon_code, c.coupon_amount, c.coupon_type, c.coupon_star' at line 1
SELECT COUNT(*) AS total SELECT c.coupon_id, c.coupon_code, c.coupon_amount, c.coupon_type, c.coupon_start_date, c.coupon_expire_date, c.uses_per_user, c.uses_per_coupon, c.restrict_to_products, c.restrict_to_categories, c.date_created, c.date_modified, c.coupon_active, cd.coupon_name FROM coupons c,coupons_description cd WHERE cd.coupon_id = c.coupon_id AND cd.language_id = '2' AND c.coupon_active = 'Y'
Sobald ich das FROM in from ändere funktioniert es wieder tadellos. Muss man nicht verstehen, oder?
Gruß
Ronny
Linkback: https://www.modified-shop.org/forum/index.php?topic=13961.0