Limiting in mySQL

[DrkFusion]

Hi, how would I limit in mysql, like on the first page there would only be 50, then on the next 50-100 and so on?

Thanks
-Arunan

[Chris M]

I would also like to know this:P

Satan

[DrkFusion]

Originally posted by hellsatan
I would also like to know this:P

Satan

Liar you just want to make a screenshot of you being the last poster LOL

-Arunan

[Chris M]

Possibly...But I am interested in learning anything and everything about PHP & MySQL

Satan

[Velocd]

Fifty what? Threads? Posts?

The basic query is:

PHP Code:

$DB_site->query("SELECT * FROM thread LIMIT 50"); 


That's ofcourse not the query to use, but you can see the LIMIT 50 part will retrieve 50 threads or whatever. If it's for each page, you'll have to check out the showthread.php and find the specific code to manipulate.

[DrkFusion]

Well, like after the 50 is posted, how would i make it so on the next page, all the stuff from 51-100 are shown?


Is it something like
[sql]$DB_site->query("SELECT * FROM thread LIMIT 51,100");[/sql]
?

-Arunan

[NTLDR]

You got it noX

Should be $DB_site->query_first though I think

[DrkFusion]

So

[sql]$DB_site->query_first("SELECT * FROM thread LIMIT 51,100");[/sql]

Thanks
-Arunan

[NTLDR]

That looks good to me noX

[DrkFusion]

Thanks NTLDR, thanks Velocd
Appreciate your continuted support here

-Arunan