SQL not returning any records

I have an weird issue, I am running the following SQL statement:

SELECT * FROM tbl_statement_items;

or

SELECT * FROM `tbl_statement_items`;

The table 'tbl_statement_items' contains 28 records, however when I run the command above its showing 0 results found.

However when I run it through phpmyadmin it displays all the records: (it appends a limit).

SELECT * FROM  `tbl_statement_items` WHERE 1 LIMIT 0 , 30

Am I missin开发者_Go百科g something simple here or has anyone else experienced this?

Thanks in advance.

Since the issue is likely the method in which you are querying your data, make sure of the following (these examples apply to PHP):

// Your connection to the database is properly set up
$con = mysql_connect($hostname, $username, $password) or exit;
mysql_select_db( $dbName, $con );

// You are storing your query in a variable to be processed
$result = mysql_query('SELECT * FROM tbl_statement_items');

// And you are using the appropriate functions to extract your content
while ($resultArray = mysql_fetch_assoc($result)) {
    foreach ($resultArray as $record) {
        // Yada yada yada...
    }
}

This of course is not all encompassing and your issue could be a number of other things, but why not start by double checking the fundamentals, right?