RE: MySQL Query

From: Peter Marko (marko@limba.sk)
Date: 01. 07. 2002, 14:43 CEST

Previous message: mail@pp21.cz: "Re: soubor cdr"
In reply to: R F: "MySQL Query"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

> 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?

pocita od nuly, takze
limit 1,3

peter

Previous message: mail@pp21.cz: "Re: soubor cdr"
In reply to: R F: "MySQL Query"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

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