Forum PHP Romania - Discutii despre PHP, MySQL, Javascript, AJAX, etc

[cigraphics]

Cod: $sql = query("SELECT * FROM products p, products_description d, products_specifications s WHERE p.active = '1' AND d.id_product = p.id AND s.id_product = p.id AND p.name LIKE '%".$qs."%' OR p.code LIKE '%".$qs."%' OR d.description LIKE '%".$qs."%' OR s.specification LIKE '%".$qs."%' LIMIT ".$current_page.", ".$items_per_page);

$sql_count = query("SELECT * FROM products p, products_description d, products_specifications s WHERE p.active = '1' AND d.id_product = p.id AND s.id_product = p.id AND p.name LIKE '%".$qs."%' OR p.code LIKE '%".$qs."%' OR d.description LIKE '%".$qs."%' OR s.specification LIKE '%".$qs."%'");

Trebuie cu join ? sau tot o sa-mi faca probleme ?

[griffin]

SELECT * FROM products p, products_description d, products_specifications s WHERE p.active = '1' AND d.id_product = p.id AND s.id_product = p.id AND p.name LIKE '%".$qs."%' OR p.code LIKE '%".$qs."%' OR d.description LIKE '%".$qs."%' OR s.specification LIKE '%".$qs."%' LIMIT ".$current_page.", ".$items_per_page

Pune tot ce e cu OR intre () adica ( p.name LIKE '%".$qs."%' OR p.code LIKE '%".$qs."%' OR d.description LIKE '%".$qs."%' OR s.specification LIKE '%".$qs."%') si in loc de * pune p.*,d.*,s.*


Cod: SELECT p.*,d.*,s.* FROM products p, products_description d, products_specifications s WHERE p.active = '1' AND d.id_product = p.id AND s.id_product = p.id AND (p.name LIKE '%".$qs."%' OR p.code LIKE '%".$qs."%' OR d.description LIKE '%".$qs."%' OR s.specification LIKE '%".$qs."%' ) LIMIT ".$current_page.", ".$items_per_page

La al doilea query faci la fel

[cigraphics]

Am rezolvat cu LEFT JOIN :D
multam de raspuns
Cod: $sql = query("SELECT * FROM products p LEFT JOIN (products_description d, products_specifications s) ON ( d.id_product = p.id AND s.id_product = p.id ) WHERE active = '1' AND p.name LIKE '%".$qs."%' OR p.code LIKE '%".$qs."%' OR d.description LIKE '%".$qs."%' OR s.specification LIKE '%".$qs."%' LIMIT ".$current_page.", ".$items_per_page);

$sql_count = query("SELECT * FROM products p LEFT JOIN (products_description d, products_specifications s) ON ( d.id_product = p.id AND s.id_product = p.id ) WHERE active = '1' AND p.name LIKE '%".$qs."%' OR p.code LIKE '%".$qs."%' OR d.description LIKE '%".$qs."%' OR s.specification LIKE '%".$qs."%'");

[PHPRomania Bot]