Please Help with simple php

[bzprod]

Hello,

I am using Advanced Guestbook to allow my users to submit quotes. Everything is working great, however, I need a bit of customization. Here goes.

• I would like to display a random entry (from book_data, Comment) on a seperate page on my site.

In other words, my guestbook is located on one page, and on another page I would like to add a random entry (only the entry part, not name, email, etc).

Can anyone tell me how to do this? I imagine it is pretty simple for someone that knows what they are doing.

I would think that I simply need to connect to the database, grab a random entry, and display it on a page.

If anyone can help, I would be very thankful.

-Patrick

[TheDefender]

I would think that I simply need to connect to the database, grab a random entry, and display it on a page.

That's exactly right...

The query would be something like:

SELECT Comment FROM book_data ORDER BY rand() LIMIT 1

Use that, along with what you know on how to create the connection ([man]mysql_connect[/man]), select the DB ([man]mysql_select_db[/man]), querying ([man]mysql_query[/man]) and fetching the array ([man]mysql_fetch_array[/man]).