Looping for infinite.

[rofl90]

I have this testimonial grabber but it just keeps looping the same exact testimonial for infinite...

 

<?php
echo "<h1>Testimonials</h1>";
echo "<br />";	
while($finalisedpage = mysql_fetch_array(mysql_query("SELECT * FROM testimonials"))) {

echo $finalisedpage['clientname'];
echo "<br /><blockquote>";
echo $finalisedpage['message'];
echo "</blockquote><br />";
echo $finalisedpage['company'];
echo "<br />";
echo date("jS \of F, Y.",$finalisedpage['date']);
echo "<br /><br />";
}
?>

[laffin]

move mysql_query outside of the while conditional.

 

u are getting the same row (row 1) because the query is being constantly run everytime the loop cycles.

 

 

[Stooney]

$result=mysql_query("SELECT * FROM testimonials");
while($finalisedpage = mysql_fetch_array($result)) {

[rofl90]

Thankyou so much both of you

[roopurt18]

echo date("jS \of F, Y.",$finalisedpage['date']);

Suggestion: Look at the documentation for MySQL's DATE_FORMAT function.