PHP SQL - newbie having trouble laying-out SELECT result on php/html page, help

Author

newbie having trouble laying-out SELECT result on php/html page, help

ance

2006-08-10, 3:58 am

i have this php page on my website that prints/outputs out all the
entries in my database in a table format...

when i wrote my program it seemed

to print all in one page

now that my stuff is online and the database is huge like anything, it
takes ages to load this page... also i am eating up all the my bandwith
just to see if there are new entries in my database...

i've seen this

way in which phpmyadmin lets you select some
entries in the DB based on some criterion and remembers how to get the
next few entries in line

can someone please help me on how to implement this in php

David Quinton

2006-08-10, 3:58 am

On 9 Aug 2006 23:16:48 -0700, "ance" <ancelotp@gmail.com> wrote:

>can someone please help me on how to implement this in php

I think you want to use LIMIT in your querystring.
<http://mysql.com/doc/refman/5.0/en/select.html>

--
Locate your Mobile phone: <http://www.bizorg.co.uk/news.html>
Great gifts: <http://www.ThisBritain.com/ASOS_popup.html>

Sponsored Links