Posts

Showing posts with the label mySqli

error: Fatal error: Uncaught mysqli_sql_exception: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

Error: Fatal error : Uncaught mysqli_sql_exception: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column Solution: mysqli_query($con, "SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));");

classDbTable.php

Image
https://gist.github.com/milan-sahana/c42d56711cf1c707f40ae239619f9ec4