Warning: mysqli_fetch_assoc() expects parameter 1

Question

Trying to get the last row in the table but throwing error ...

'Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, string given in '

$recents = "SELECT * FROM list ORDER BY id DESC LIMIT 1";
if ($result = mysqli_fetch_assoc($recents)) {
    $mName = $result['name'];
    $mDesc = $result['description'];
    $mCost = $result['cost'];
}

Answer 1

You forgot to use the statement to run the query

$results=mysqli_query($conn,$recents)

Answer 2

You need to pass a result from a query, not the query string.

$sql = "SELECT * FROM list ORDER BY id DESC LIMIT 1";
$recent = mysqli_query($connetion, $sql);