NEWBIE PLEASE HELP SOMEONE, ANYONE

[bhays]

I have a list of FAQ question and answers on a website I am working on. I want to display one of the Q&A's randomly each day on the home page. is there an easy way for a newbie to do this???

any direction would be great!!!!

[Anon]

Hey it would be best if you simply just had it randomly select one everytime that anyone hit your site. That is simply just my opinion though. I know that I will get FLAMED for this comment but all well.

http://www.php.net/manual/en/function.rand.php

That will tell you how to select a random number. Also tells many other cool things you can do with MySQL. Sorry can't be much more help than this. But I haven't actually had to do what you are doing. 🙂 Lata!
Ziggs

[bhays]

thanks for the direction... that gets me moving somewhere!!! any other opinions are welcome!!!

[Anon]

Glad I could help.

Ziggs

[Anon]

Another way to use the RAND() function with MySQL is to use it in conjunction with the ORDER statement and then LIMIT the set to 1:

Select faq FROM faq_list ORDER BY RAND() LIMIT 1;

Good luck!