[RESOLVED] No changes but now does not work

[Ember]

I have an issue with some code. This code goes through a database of images that have relevant links that parses into an html link and image tag. Up until today it was working fine. The funny part is I haven't even been at work to change anything because I was on spring break. I'm wondering what would all of the sudden make this not work properly.
Here is the code. The error I am recieveing is:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\dining\mealplans.php on line 136

The PHP code in the documnet looks like this:

  <?php
	// Connect to the database
	mysql_connect ('localhost', '***', '**********) ;
	mysql_select_db ('ads');

// Select random rows from the database
$result = mysql_query ("SELECT * FROM links ORDER BY RAND() LIMIT 1");

// For all the rows that you selected
while ($row = mysql_fetch_array($result))

{
// Display them to the screen...

echo "<a href=\"" . $row["link"] . "\" target=_blank>
<img src=\"" . $row["image"] . "\" border=0 alt=\"" . $row["text"] . "\">
</a>" ;
} 
  ?>

Any help would be appreciated. You can message me at Emb3rX on AIM if you have a quick fix for this.

[bogu]

Can u give me your domain where the script is runing? :evilgrin: :evilgrin: :evilgrin:

Man next time dont make public your mysql, username and password ...

Your select looks fine so the question is, does this table links exists in your database?

[Ember]

haha, oh crap, forgot about that line.....
I got it resolved. One of my co-workers was working on file directly off the server and was storing all his work in progress and test files...filling up the hard drive the sites are stored on instead of his work in progress folder on a different hard drive. So apparently the low disk space was halting when the script tried to write to the hard drive. Thanks for the reply though.