Jump to content

Random Selection

- - - - -
Started by dirkfirst, Oct 21 2006 06:37 AM

This topic has been archived. This means that you cannot reply to this topic.
5 replies to this topic

#1
dirkfirst
Posted 21 October 2006 - 06:37 AM

dirkfirst

    Programming Expert

  • Members
  • PipPipPipPipPipPip
  • 354 posts
From a MySQL database how can I randomly selected the data I use with mysql_query($query)?

I think that creating an array and using the rand() function is my only choice. This takes a lot of resources when I'm pulling 10,000 rows. Any Ideas?

#2
John
Posted 22 October 2006 - 02:19 PM

John

    Writes binary right handed and hex left handed

  • Moderators
  • 6,321 posts
you might be able to do this with a UNION

#3
Guest_Jordan_*
Posted 22 October 2006 - 03:11 PM

Guest_Jordan_*
  • Guests
Just use the rand() function of MySQL.

SELECT * FROM tbl ORDER BY RAND() LIMIT 1;

#4
sfod_d223
Posted 23 October 2006 - 10:46 AM

sfod_d223

    Newbie

  • Members
  • Pip
  • 6 posts
I don't know if I'm asking this in the right room but here it goes. Where do I put a random function If I am trying to make random links for articles on homepage show up in different areas.
Down the Tracks |Submit Links Here[SIGPIC][/SIGPIC]

#5
Guest_Jordan_*
Posted 23 October 2006 - 05:32 PM

Guest_Jordan_*
  • Guests
If you want it on your homepage put it on your homepage. Are you using the mysql random function from above?

#6
dirkfirst
Posted 26 October 2006 - 07:29 AM

dirkfirst

    Programming Expert

  • Members
  • PipPipPipPipPipPip
  • 354 posts

Jordan said:

Just use the rand() function of MySQL.


SELECT * FROM tbl ORDER BY RAND() LIMIT 1;


Thanks, works perfect.
Back to PHP Development




  1. CODECALL Programming Forum
  2. → Web Development Forum
  3. → PHP Development
IPB skins by Skinbox