vb.org Archive - Chosin a row randomly from a mysql table

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Chosin a row randomly from a mysql table (https://vborg.vbsupport.ru/showthread.php?t=35556)

DjSap

03-01-2002 12:26 PM

Chosin a row randomly from a mysql table

Well im making a hot or not (photo rating) hack for my board, its practily done but i dont know how to solve the randomizing thingy so that when people load hotornot.php then a random image is shown. From reading a tutorial i learned a little and used the code they supplied to write this query:

PHP Code:


		
			
 $result= $DB_site->query("select * from photoalbum WHERE allowrate='1'"); 

 $row=mysql_num_rows($result); 

 srand((double)microtime()*1000000); 

 $random=rand(1,$row);

 $messages = $DB_site->query("SELECT * FROM photoalbum WHERE picid='$random'");

The problem is that since i have deleted some pics from the table photoalbum then the id field goes like 2,4,5,8 and so on. Now when the random image is shown sometimes an non existing row is chosen since the random thingy may say 3 even though there is no row with the id 3. How do i make it randomize the rows that actually exist?

Admin

03-01-2002 12:30 PM

Code:

SELECT * FROM photoalbum ORDER BY RAND()

DjSap

03-01-2002 12:37 PM

lol it was that easy, heh well thanx again for helping me out.

All times are GMT. The time now is 03:21 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00963 seconds Memory Usage 1,715KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: