EASY?! _ LIMIT (MySQL) with a variable

hi all
i appologize if the following question is common knowledge, but it save me for hours...

i am using LIMIT in MySQL with php.
LIMIT can have two arguements and i want to fill them in with variables from php...

i tried it this way:

$page = 0 (i tried it also with page = "0")

mysql_query("SELECT * FROM t1 ORDER BY id DESC LIMIT '$page',10");

i get this error:

Warning: Supplied argument is not a valid MySQL result resource

When i fill the 0 directly - it works...
i do not know what to do, please help

thanks MoREM

leave off the single quotes, make sure $page is a number.

mysql_query("SELECT * FROM t1 ORDER BY id DESC LIMIT $page,10");

w/o quota(')

you may do something like

$step = 10;
$page = 1; // this will start from page 1

mysql_query("SELECT FROM t1 ORDER BY id DESC LIMIT " . $page $step . ",$step");

btw
after ...LIKE fromRecord, howManyRecords

on page 2 query will be
...LIKE 20,10
page 6
...LIKE 60,10

sorry, it was from my head

first page will start from record 10

$step * $page = 10

but it must start from record 1

but I'm sure you will do that on the right way

best regards

You are great help thanks a lot, must have been blind... g

cya MoREM