Newbie - Limited results from MySQL query

Codes here !

Moderators: egami, macek, 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:

Wed Mar 19, 2003 4:00 pm

Silly question... what code are you using? :P
Terra Design, my business and sole / huge PHP project... a fully dynamic and adaptive site engine.

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

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"; 
PHP+MySql= Love :)

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

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
Thanks and regards;
wmdrumaizi

Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 4 guests