So lösen Sie "Reihenfolge nach Klausel befindetPhp

PHP-Programmierer chatten hier
Anonymous
 So lösen Sie "Reihenfolge nach Klausel befindet

Post by Anonymous »

Ich habe das neue Ubuntu installiert und mein Code hat ein Problem mit MySQL.

Code: Select all

( ! ) Warning: PDOStatement::execute(): SQLSTATE[HY000]: General error: 3065
Expression #2 of ORDER BY clause is not in SELECT list, references column 'clicshopping_test_ui.p.products_date_added' which is not in SELECT list; this is incompatible with DISTINCT
in /home/www//boutique/includes/OM/DbStatement.php on line 97s
< /code>

Es scheint, dass MySQL 5.7 keine Anforderung wie: < /p>

erlaubtselect .... distinct with  order by rand(), p.products_date_added DESC
< /code>

Wenn ich dies verwende, funktioniert es: < /p>

select distinct .... with  order by rand(),
< /code>

Wie kann ich diese Situation auflösen? $Qproduct = $OSCOM_PDO->prepare('select distinct p.products_id,
p.products_price
from :table_products p left join :table_specials s on p.products_id = s.products_id
where products_status = :products_status
and products_view = :products_view
and p.products_archive = :products_archive
order by rand(),
p.products_date_added DESC
limit :products_limit');
$Qproduct->bindInt(':products_status', 1);
$Qproduct->bindInt(':products_view', 1);
$Qproduct->bindInt(':products_archive', 0);
$Qproduct->bindInt(':products_limit',
(int)MODULE_FRONT_PAGE_NEW_PRODUCTS_MAX_DISPLAY);

Quick Reply

Change Text Case: 
   
  • Similar Topics
    Replies
    Views
    Last post