Won't return anything when there is only one matching row.

External Since: Feb 08, 2005 Posts: 6

$sql = 'SELECT `PageTitle` ';
$sql .= 'FROM `Pages` ';
$sql .= 'WHERE `PageID` = 1 LIMIT 0, 30';

I have run this query in MySQL control panel and it works perfectly.
When I try to do it via PHP I get no results.

If I select all rows (i.e I don't specify a "WHERE") I get one fewer
rows returned than there actually are.

Any ideas?

External Since: Feb 08, 2005 Posts: 6

Thanks - I seem to have solved this one (but not sure how).

But in answer to your question it was returning 0 rows when there was
one - 2 when there was 3. There would never be over 30 rows.

Steve