Warning message, won't retrieve data

[Anon]

When I run my PHP/MYSQL program I get:

Warning: Supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\intern\IT Requests\myself.php on line 34

this references the line with
$row=mysql_fetch_array($result)

and I get the same thing with

$nrows=mysql_num_rows($result)

I ran this program for the past two weeks and it has worked...I haven't touched the code, but all of a sudden this morning it won't work....

Does anyone have any idea why this is happening??? PLEASE HELP!!!

[Anon]

This is usually a result of a bad query. Please show the code you are using to form your query and also try passing the query directly to mysql to see if you get the expected result.

[Anon]

Here's the code the problem row is marked with ****

However, I can't see how it could be the code b/c I haven't touched it and it worked just fine two days ago

$query = "SELECT issue, Cause, description_short, date_format(date_complete, '%m/%d/%y') AS date_complete, date_format(time_received, '%m/%d/%y') AS time_received FROM issues where Username='$Username'";

$result=mysql_query($query);

echo "<h1>Issues for $Username</h1>";

echo "<table cellspacing='15'>";
echo "<tr>\n
<td>Issue Number</td>\n
<td>Cause</td>\n
<td>A short Description</td>\n
<td>Date Request was received</td>\n
<td>Date Completed\n";

echo "<tr><td colspan='7'><hr></td></tr>\n";

*****while ($row=mysql_fetch_array($result))
{
extract($row);

echo "<tr>\n

	<td>$issue</td>\n
	<td>$Cause</td>\n
	<td>$description_short</td>\n
	<td>$time_received</td>\n";

If ($date_complete=="00/00/00")
{
echo "<td>Work In Progress</td>\n";
}
else
{
echo "<td>$date_complete</td>\n";
}

	echo "<tr><td colspan='7'><hr></td></tr>\n";

}
echo "</table>\n";

[Anon]

To me the query looks allright, check with the database table .issues.

Thomas

[Anon]

The database table is fine. It allows me to add new records or update records to the table. The only time I have a problem is when I try to retrieve the records that are in there

Thanks!!
Mina

[Anon]

Try echoing out your query string, see if $Username is set, and then as I said earlier run it at the mysql command line. If $Username is not set your hosting may have updated their php and you will need to add
$Username=$POST['Username'];
or if data through get.
$Usename=$GET['Username'];

$query = "SELECT issue, Cause, description_short, date_format(date_complete, '%m/%d/%y') AS date_complete, date_format(time_received, '%m/%d/%y') AS time_received FROM issues where Username='$Username'";
echo $query;