Random text and converting int to string

Radon3k

I have a database that is going to contain quotes. I want these quotes to be displayed randomly. However with what I have now, it's only showing one letter at a time. Is there a way to convert an integer to a string so that the whole word may be converted? Or if there is a better way, please let me know. Thanks for any help you can provide! 🙂

<?php
$get = mysql_query("SELECT * FROM quotes") or die(mysql_error());

$row = mysql_fetch_array($get);
$quotes = $row['quotes'];
$quotes = settype($quotes, "string");

$randquote = rand(1, 10);
echo($quotes[$randquote]);
?>

devinemke

$result = mysql_query ('SELECT * FROM quotes ORDER BY RAND() LIMIT 10');
while ($row = mysql_fetch_assoc ($result))
{
echo $row['quotes'] . '<br>';
}

Radon3k

Thanks, that's what I was looking for! 🙂

Radon3k

Is there a way to make the different quotes a certain amount of times? Almost like a banner management system where there are a certain number of impressions between certain dates. I don't need anything that fancy, that wast just an example. Thanks. 🙂

Radon3k

Anyone?

devinemke

do you mean that you want to rotate a different quote each day?

Radon3k

No, I just want the quotes to rotate more evenly. It seems as if the same quote stays there for a few refreshes. I hope that makes sense.

devinemke

let's backup a minute. the original code sample i posted pulls 10 random quotes out of your database at a time. are you displaying all 10 at a time or then rotating thru the 10? if you are only displaying 1 quote at a time then should modify your query to only pull out 1.

Radon3k

oops, I see the problem now. You're right, I was trying to pull 10 at a time. There aren't even 10 in there and I only wanted one displayed at a time. I think it's fixed now, thanks! 🙂