How to grab random data from a table?

yihungkuo

Hi there,

I have a vertical scroller javascript that scrolls automatically. Right now, all the content in the scroller is entered manually in HTML within several <div>, for ex.

<div id=1>first row content</div>
<div id=2>2nd row content</div>
<div id=3>3rd row content</div>

and so on..

I have a database that has certain values that I want to just grab from and place in these divs, how do I do that?

Thanks in advance.

coldwerturkey

depending on what DBMS you're using (I'll assume mysql), you can use RAND() in your query

then use basic retrieve methods (again depending what DBMS) with mysql_query() and mysql_fetch_array() in a while() loop to print the desired content in the desired html.

Search basic 'php mysql tutorials' for step by step instructions

yihungkuo

Hi Thanks,
What about calling them by order of data create date? Can you please give me some hint on how to write that while() loops? thanks.

coldwerturkey

yihungkuo;10908124 wrote:
What about calling them by order of data create date?

than you would ORDER BY date ASC/DESC.

yihungkuo;10908124 wrote:
Can you please give me some hint on how to write that while() loops? thanks.

for the while loop like i said: "Search basic 'php mysql tutorials' for step by step instructions"

yihungkuo

alright. thanks.