Newbie - Limited results from MySQL query

Codes here !

Moderators: macek, egami, gesf

Post Reply
Xerpher
New php-forum User
New php-forum User
Posts: 164
Joined: Tue Aug 27, 2002 8:25 pm
Location: Ontario, Canada
Contact:

Post by Xerpher » Wed Mar 19, 2003 4:00 pm

Silly question... what code are you using? :P

Romantik
New php-forum User
New php-forum User
Posts: 67
Joined: Mon Feb 24, 2003 2:55 am
Location: ../Ukraine/Kherson
Contact:

Post by Romantik » Thu Mar 20, 2003 2:10 am

use LIMIT
read http://www.mysql.com part documentation


Code: Select all

$str_requete = "SELECT id,stof,auteur,grootte,vak FROM artikel WHERE affichage='$affichage' ORDER BY date DESC LIMIT 10"; 

User avatar
wmdrumaizi
New php-forum User
New php-forum User
Posts: 40
Joined: Thu Jan 23, 2003 5:15 pm
Location: Malaysia
Contact:

Limited results from MySQL query

Post by wmdrumaizi » Thu Apr 10, 2003 12:59 am

Hi Romantic, I've used limit and it worked. But could you tell me how to navigate from one page to next page and so on

Thanks in advance

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests