ouput NULL results when using "do while" loop
Posted: Mon Oct 18, 2004 4:02 pm
Hello,
the following is a query that list all the items (24) in a database usin a LIMIT offset , max
on using variables on a do, while loop
i am getting empty results being outputted yet on checking the raw database i can pick up no null entries.
if the balance of the result is
e.g. url http://www.handmadebodyessentials.com/a ... e=2&max=20
Kendall
the following is a query that list all the items (24) in a database usin a LIMIT offset , max
Code: Select all
SELECT prdct.ProductID, prdct.ProductName, prdct.UnitPrice, prdct.Availability, prdct.Category, category.CategoryName FROM products as prdct RIGHT JOIN categories as category ON CategoryID = prdct.Category LIMIT %d, %dCode: Select all
$max = 20, $page = 2i am getting empty results being outputted yet on checking the raw database i can pick up no null entries.
if the balance of the result is
would there be NULL values outputted?< the LIMIT $limit, $max
e.g. url http://www.handmadebodyessentials.com/a ... e=2&max=20
Kendall