Mysql Need Help!!!

[jjoves]

Yesterday my journal site was working fine - then today I get this error message:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site168/fst/var/www/html/index.php on line 171

Here is the code:

<?
					if ((!$day || !$year || $month) && !$mydate) {
					  	$mydate = date("Y-m-d");
					} else {
					 	$month = $month+1;
					 	if ($year && $month && $day) {
							$mydate = "$year-$month-$day";
						}
					}
					echo "<strong style='font-size: 13px;color:#666699;'>$mydate</strong><br /><br />";
					echo "<input type=\"hidden\" name=\"mode\" value=\"gowrite\">";
					echo "<input type=\"hidden\" name=\"mydate\" value=\"$mydate\">";

				$sql = "select * from notes where notes_date='$mydate' order by notes_time desc";
				$result = mysql_query($sql);
				while ($row=mysql_fetch_array($result)) {
					echo "

						<strong style='font-size: 11px;'>$row[notes_user]</strong> $row[notes_time]
						<br>--------------------------------------------------------------------------------------
                        <br/>".nl2br(stripslashes($row[notes_note]))."<br /><br />

					";
				}
				mysql_free_result($result);
				 if ($mynotes && $user) {
					if ($allowhtml == "0") {
						$mynotes = str_replace("<", "&lt;", "$mynotes");
						$mynotes = str_replace(">", "&gt;", "$mynotes");
					}
					if ($mydate && $todayonly == "0") {
						$sql = "insert into notes (notes_date,notes_note,notes_time,notes_user) values ('$mydate','$mynotes',CURTIME(),'$user')";
					} else {
						$mydate = date("Y-m-d");
						$sql = "insert into notes (notes_date,notes_note,notes_time,notes_user) values ('$mydate','$mynotes',CURTIME(),'$user')";
					}


							mysql_query($sql) or die("error 324343");



					$adate = explode("-", $mydate);
					$mymonth = $adate[1]-1;
					header("Refresh:0;url=$PHP_SELF?day=$adate[2]&month=$mymonth&year=$adate[0]");
				}

				if ($todayonly == "1") {
					$posttext = "<strong style='font-size: 10px;color:#666699;'>Note: You can only post under today's date</strong>";
				} else {
					$posttext = "<strong style='font-size: 10px;color:#666699;'>Note: You can post notes under any date, past, present or future</strong>";
				}
			   ?>

[brooky]

There aren't 171 lines of code there is that your index.php file?

[jjoves]

Oh I forgot to mention -- the script is begins on line 162 -214 that means . line 171 is this line:

echo "<strong style='font-size: 13px;color:#666699;'>$mydate</strong><br /><br />";

[HairyScotsman]

Although the it says the error is on line 171, it actually occurs 170. Its just the way that PHP's interaction with Mysql works. So the error is actually at

while ($row=mysql_fetch_array($result)) {

which to me suggests to me that your SQL statement you generate is not returning any results.

You could check this :

select * from notes where notes_date='$mydate' order by notes_time desc

This only searches for notes that have their date set to $mydate.
Therefore if you don't have anynotes say for today in your database you would get this error. If that is the case why dont you try simply

select * from notes order by notes_time desc

Hope this helps...sorry if Im wrong

Rene

[cgraz]

I agree with Hairy Scotsman in saying that your query is what is giving you the problem. Change

                    $sql = "select * from notes where notes_date='$mydate' order by notes_time desc";
                    $result = mysql_query($sql);

to

$sql = "select * from notes where notes_date='$mydate' order by notes_time desc";
print $sql . "<br>"; // printing the string always helps
$result = mysql_query($sql) or die(mysql_error()); // mysql_error() will let you know if there was an error

Cgraz