Had to pass this along...

[charlesh]

I noticed that on certain pages here on glowhost.com, the customer testomonial will change each time you refresh the browser, so you get a fresh, dynamic comment each time. That's cool stuff and I have done the same for one of my clients on www.biplaneride.com. I thought I'd pass it along, if it is of use for anyone else. Really, all the work is done in the SQL query. Check it out.

  $query = "SELECT commentData FROM comments WHERE LENGTH(commentDATA) < 150 AND approved = 1 ORDER BY RAND() LIMIT 1";
$result = mysql_query($query);
$num_results = mysql_num_rows($result); 
  

Then later on, just echo out the results:

 echo htmlspecialchars(stripslashes(mysql_result($result, 0, "commentData"))); 
  

CharlesH

[rlhanson]

Thanks for the script CharlesH - I hope to use this one day!
The site you mentioned: www.biplaneride.com - do you do flash yourself?

[charlesh]

Yes, I did do the flash and it really looks more difficult than it is. I am getting better with it, tho and you can do a lot of cool stuff with actionscript.

Charlesh

[dansgalaxy]

Hmm, i have my random quote slightly different, my database is set up so i have the main testimonial stored and i then select 4 quotes and put them into seperate fields and then have it select a random quote

will have to see if i can get more of the logic into the SQL tho

Dan