Hello,
It seems we have an issue with SQL for our website :
" 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 '-1 ORDER BY [login to view URL] ASC' at line 17 "
I don't have the knowledge to solve it:
Here is the code :
mysql_select_db($database_mots_cles, $mots_cles);
$query_Rq_cat_images = "SELECT
qerf_product.id_product AS 'Id_P' ,
[login to view URL] AS 'Ref' ,
qerf_image.id_image AS 'image'
FROM
qerf_stock_available
INNER JOIN qerf_product_lang ON qerf_stock_available.id_product = qerf_product_lang.id_product
INNER JOIN qerf_product ON qerf_stock_available.id_product = qerf_product.id_product
INNER JOIN qerf_image ON qerf_stock_available.id_product = qerf_image.id_product
INNER JOIN qerf_category_lang ON qerf_product.id_category_default = qerf_category_lang.id_category
INNER JOIN qerf_category ON qerf_category.id_category = qerf_category_lang.id_category
INNER JOIN qerf_category_product ON qerf_category_product.id_product = qerf_stock_available.id_product
WHERE
qerf_product_lang.id_lang = 1
AND qerf_product_lang.id_shop = 1
AND qerf_stock_available.id_product_attribute = 0 ";
if($qte_mini == 0){
$query_Rq_cat_images .=" AND [login to view URL] <= ".$qte_mini;
$query_Rq_cat_images .=" AND [login to view URL] = 0";
} else {
$query_Rq_cat_images .=" AND [login to view URL] >= ".$qte_mini;
}
$query_Rq_cat_images .= " AND qerf_category_lang.id_shop = 1
AND qerf_category_product.id_category IN ".$filtre."
ORDER BY
[login to view URL] ASC";
The first personn who has the solution will have the project
We could work later together .
Thank you for your proposals.
Hello,
As an expert in writing sql query, i can sort out the issue in your query in few minutes. In fact it is sorted already, please let me know if you are interested.
Thanks
€10 EUR en 0 día
5,0 (277 comentarios)
7,6
7,6
11 freelancers están ofertando un promedio de €15 EUR por este trabajo