Limiting in mySQL
 

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

I would also like to know this:P

Satan

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

-Arunan

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

Satan

Fifty what? Threads? Posts?

The basic query is:
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.

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

You got it noX :D

Should be $DB_site->query_first though I think ;)

So

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

Thanks
-Arunan

That looks good to me noX :D

Thanks NTLDR, thanks Velocd
Appreciate your continuted support here :)

-Arunan

Your welcome Arunan, just giveing back what you have given to the community :D

I hope to be giving much more to the community :)

-nOX

sorry but wrong NTLDR, if he wants more that one row (i think 50 does he want ;)) he HAS to use just query and then create the whileloop with fetch_array :)

Thanks for correcting me Xenon, I can never remember which to use untill I try and find it doesn't work ;)