MySQL Query

From: R F (rozanek@seznam.cz)
Date: 01. 07. 2002, 14:28 CEST


Mam nasledujici dotaz na databazi MySQL:

 $result=mysql_query("select qbtitle,qbcontent,qbdate from $dbnick
where qbtype='news' order by qbdate desc limit 3");
 while(list($qbtitle,$qbcontent,$qbdate)=mysql_fetch_row($result)) 

Vybira tri clanky. Ja bych potreboval, aby hodnota "limit" zacala od
druheho clanku, tzn. vybrat z databaze 3 clanky pocinaje druhym (nebo
prvnim, pokud to MySQL pocita od nuly). Jak na to?

Filip

______________________________________________________________________
Reklama:
Mapy Prahy, Brna a Cech najdete na http://www.mapy.cz



This archive was generated by hypermail 2.1.2 : 01. 07. 2002, 14:28 CEST