从数据库mysql获取N值

Question

i have a table i get cars form databases and i list it in this table:

$row_id=$_GET["id"];
$solK = ($row_id-1) * 9;
$sagK = ($row_id) * 9;
$sorgu2 = mysql_query("SELECT * FROM Car WHERE Car_ID > '$solK' AND Car_ID < '$sagK'");

Every page have 9 cars i use id for sort these cars but when i delete a car (for example Carid=5) in first page have 8 cars but other pages have 9 cars how can i get first N values without CarId from databases can you explain with sql codes.

Answer 1

Add a LIMIT to your query.

For example

SELECT * FROM tbl LIMIT 0, 9

will select the first 9 entries from tbl.

In order to match your query and preserve the ordering I'd state it as

SELECT * FROM Car ORDER BY Car_ID LIMIT 0, 9

for the first nine rows. For the next nine rows, just increment both numbers by 10 and so on.