hi , i have a site that shows all the products in database and i have made it so that you should only be able to see the 10 first at first
and then you when you press number 2 you get posted back to the same page but with diffrent querystring making the variable min 10 and max 20
but here's the problem, the list works perfectly but somehow the query to the database fails at random, when i press 2 i get rows 10 to 31 and when i press 3 i get 20-31 and when i press 4 i get 30-41 and when press 5 i get 41 wich is the last row and making number 1 and 5 correct but the rest is not correct.
here's my querystring for database:
hemtinfo = "SELECT * FROM Produkter RIGHT JOIN lista ON Produkter.typ_produkter=lista.typ ORDER BY lista.rubrik ASC LIMIT " + min + "," + max;
i have checked so min and max are the right numbers for each site so i dont understand what the problem is
please help =)
...
Go to the complete details ...