
June 7th, 2006, 06:09 PM
|
|
Contributing User
|
|
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 65
Time spent in forums: 1 Day 1 h 5 m 28 sec
Reputation Power: 4
|
|
|
Help!!! Please - MySQL upgrade problems
I'm not sure if anyone can help me with this one, it's hard to understand I think.. Anyways, I just upgraded Mysql from version 4.0.3 i think to 5.1 and now my website isn't working properly.. I am using the tag
include ("includes/quotes.php");
in a section, but on my site when it gets to that it goes blank and stops loading the rest of the site. I haven't changed anything in my files just upgraded mysql..
the quotes.php file is as follows:
Quote: <?php
require ("includes/dbconn.php");
$randomQuotes = "SELECT * FROM `quotes` ORDER BY RAND() LIMIT 1";
$finalRandomQuotes = mysql_query($randomQuotes);
while ($row = mysql_fetch_assoc($finalRandomQuotes)){
?>
<div align="center"><em><?php print $row['quote']; ?></em></div>
<?php
}
?> |
And i can't see anything wrong in there as to why it shouldn't work properly?? It's just not that file, it seems to do the same for other files i'm trying to include..
Any help would be muchly appreciated!!
|