ODD php warning output - please help!
Posted: Mon May 05, 2003 11:17 pm
OK I have used this code many times (EVEN on the same server) yet for some reason it isn't working...
Can you tell me why?
The error I get is Warning: 2 is not a valid MySQL result resource in /home/httpd/vhosts/site1/httpdocs/diary.php on line 23
23 is
Thanks
Can you tell me why?
Code: Select all
<?php
@mysql_connect($host, $loginname, $password) or die(mysql_error());
@mysql_select_db($data) or die('Could not select database'.mysql_error());
$result = mysql_query("SELECT * FROM $table ORDER BY id DESC");
while ($row = mysql_fetch_array($result)) {
$rowї'diary_entry'];
$rowї'date'];
echo ("<tr><td align=center valign=middle width=25%><font size=3 face=Verdana,BankGothic Md BT, Arial, Helvetica><b>".$rowї'date']."</b></font></td><td align=left valign=middle><font size=3 face=Verdana,BankGothic Md BT, Arial, Helvetica>".$rowї'diary_entry']."</font></td></tr>");
mysql_free_result($result);
}
?>23 is
Code: Select all
while ($row = mysql_fetch_array($result)) {