Original geschrieben von davidovich
Meinste? Wie funktioniert dann mien Blätterscript folgens:
?
Meinste? Wie funktioniert dann mien Blätterscript folgens:
Code:
LIMIT $start, $end
User variables may be used where expressions are allowed. This does not currently include contexts that explicitly require a literal value, such as in the LIMIT clause of a SELECT statement, or the IGNORE number LINES clause of a LOAD DATA statement.
Code:
SET @c:=(SELECT COUNT(*) FROM tabelle); SELECT * FROM tabelle WHERE {conditions} ORDER BY id DESC LIMIT 20 OFFSET (@c-20)
Comment