CODEWITHSUNDEEP
phpmysql
Kan01
Kan01

Reputation: 1

PHP- I get errors on this code . The error says , Warning: mysqli_query() expects parameter 1 to be mysqli, null given in

$q = "SELECT CONCAT" (lname ', ', fname) AS name
DATE_FORMAT(registration_date, %M %d, %Y) AS regdat FROM users
ORDER BY registration_date DESC;        
$result = @mysqli_query ($dbcon $q);

Upvotes: 0

Views: 85

Answers (1)

pavel
pavel

Reputation: 27072

You have there error in quotes:

$q = "SELECT CONCAT(lname, ', ', fname) AS name,
             DATE_FORMAT(registration_date, '%M %d, %Y') AS regdat 
      FROM users
      ORDER BY registration_date DESC";
$result = mysqli_query ($dbcon, $q);

Upvotes: 1

Related Questions