How do you select the first row of a table?

[gregaryb]

 $strSQL = "SELECT * FROM '".$strTableName."' LIMIT 1";
        $Result = $DBConnection->query($strSQL);
echo "########".$strSQL."########<br>";
echo "########".$Result->num_rows."########<br>";

How do you do this successfully such that $Result->num_rows does not come back as null.
Debug output is thus:

@@@@@@@@@@@DoreenColes@@@@@@@@@
########SELECT * FROM 'DoreenColes' LIMIT 1########
################

I have successfully connected to my database at this point.
The database DOES contain a table named "DoreenColes".

And the table definitely contains 1 row of data.

 

Edited August 1, 2022 by gregaryb

[Ingolme]

You have to delimit the table name with `backticks` instead of 'quotation marks'

[Chikwado]

SELECT * FROM table

WHERE id = '1'

AND firstname = 'Smith'