The Arcive of vBulletin Modifications Site.

DrkFusion · #1 10-13-2002, 04:27 PM

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 · #2 10-13-2002, 05:00 PM

I would also like to know this:P

Satan

DrkFusion · #3 10-13-2002, 05:16 PM

Quote:

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 · #4 10-13-2002, 05:27 PM

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

Satan

Velocd · #5 10-13-2002, 06:16 PM

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 · #6 10-13-2002, 07:10 PM

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 · #7 10-13-2002, 07:14 PM

You got it noX

Should be $DB_site->query_first though I think

DrkFusion · #8 10-13-2002, 07:36 PM

So

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

Thanks
-Arunan

NTLDR · #9 10-13-2002, 07:40 PM

That looks good to me noX

DrkFusion · #10 10-13-2002, 07:47 PM

Thanks NTLDR, thanks Velocd
Appreciate your continuted support here

-Arunan

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06157 seconds Memory Usage 4,726KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_php (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/functions_amr.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages: