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

[steve.burgess]

$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?

[Aggro]

st***********@boston-spa.org.uk wrote:

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.
Perhaps there is something wrong with the php code you are using? Hard
to say without seeing it.
If I select all rows (i.e I don't specify a "WHERE") I get one fewer
rows returned than there actually are.

If you got limit 0, 30, it will return only 30 rows even if there are
more rows. So how many is it returning?

[steve.burgess]

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