PHP/MySQL - Randomly display a collection of qoutations

brihas · 1-9-05, 05:29 PM

I have a text file that contains a large collection of quotations. I would like to import these into a MySQL database and then have a PHP script randomly call up a quote from the database and display it. I have seen several sites that do this, and was wondering if any of you could provide any guidance on where I may start looking for details on how to do this.

Thanks in advance for your help.

**BerksWebGuy** · 1-9-05, 06:34 PM

Just to get the basics of PHP and MySQL, go a few googles, look at the stickies in this forum, and look through a few posts.

Making it random is just a matter of a mysql query...not hard at all (here's just one post about it HERE ).

brihas · 1-9-05, 07:04 PM

Thanks for the feedback. I found *exactly* what I was looking for here:
http://www.aasted.org/quote/

Note: This does not use MySQL but rather the original *nix fortune files...which makes my work way easier!

1-9-05, 05:29 PM	#1
brihas Registered Join Date: Jan 2005 Location: canada Posts: 8 Reputation: 5	PHP/MySQL - Randomly display a collection of qoutations I have a text file that contains a large collection of quotations. I would like to import these into a MySQL database and then have a PHP script randomly call up a quote from the database and display it. I have seen several sites that do this, and was wondering if any of you could provide any guidance on where I may start looking for details on how to do this. Thanks in advance for your help.

1-9-05, 06:34 PM	#2
BerksWebGuy Mod Squad Join Date: Apr 2002 Location: Orlando, FL Posts: 6,972 Reputation: 243	Just to get the basics of PHP and MySQL, go a few googles, look at the stickies in this forum, and look through a few posts. Making it random is just a matter of a mysql query...not hard at all (here's just one post about it HERE ). __________________ www.GoLightMedia.com

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

1-9-05, 07:04 PM	#3
brihas Registered Join Date: Jan 2005 Location: canada Posts: 8 Reputation: 5	Thanks for the feedback. I found exactly what I was looking for here: http://www.aasted.org/quote/ Note: This does not use MySQL but rather the original *nix fortune files...which makes my work way easier!