I'm trying to query mySQL database but encounter the following error message. HELP !
Warning: 0 is not a MySQL result index in /home/tgtan/ant-www/phpinfo1.php3 on line 8
Sorry,no records were found !
My script as follows:
<?php
$db = mysql_connect("localhost", "tan","1111");
mysql_select_db("ant_com",$db);
$result = MySQL_query("SELECT * FROM table2001",$db);
if ($myrow=MySQL_fetch_row($result)) {
echo "<center>";
echo "<table border=0>\n";
echo "<tr bgcolor=#CCCCCC><td><font size=1 face=Arial>Call Rec'd</font></td>
<td><font size=1 face=Arial>CER No</font></td>
<td><font size=1 face=Arial>System Des</font></td>
<td><font size=1 face=Arial>Serial No</font></td>
<td><font size=1 face=Arial>Problem Description</font></td>
<td><font size=1 face=Arial>Rectification</font></td>
<td><font size=1 face=Arial>Status</font></td>
<td><font size=1 face=Arial>Call Res'd</font></td>
<td><font size=1 face=Arial>Call Comp'd</font></td>
<td><font size=1 face=Arial>Logged By</font></td>
<td><font size=1 face=Arial>Engineer</font></td>
<td><font size=1 face=Arial>Manhours</font></td></tr>\n";
do {
printf("<tr><td>%s</td></tr>\n", $myrow["Call_Received"]);
} while ($myrow=MySQL_fetch_row($result));
echo "</table>\n";
echo "</center>";
} else {
echo "Sorry,no records were found !";
}
?>
Warning: 0 is not a MySQL result index in /home/tgtan/ant-www/phpinfo1.php3 on line 8
Sorry,no records were found !
My script as follows:
<?php
$db = mysql_connect("localhost", "tan","1111");
mysql_select_db("ant_com",$db);
$result = MySQL_query("SELECT * FROM table2001",$db);
if ($myrow=MySQL_fetch_row($result)) {
echo "<center>";
echo "<table border=0>\n";
echo "<tr bgcolor=#CCCCCC><td><font size=1 face=Arial>Call Rec'd</font></td>
<td><font size=1 face=Arial>CER No</font></td>
<td><font size=1 face=Arial>System Des</font></td>
<td><font size=1 face=Arial>Serial No</font></td>
<td><font size=1 face=Arial>Problem Description</font></td>
<td><font size=1 face=Arial>Rectification</font></td>
<td><font size=1 face=Arial>Status</font></td>
<td><font size=1 face=Arial>Call Res'd</font></td>
<td><font size=1 face=Arial>Call Comp'd</font></td>
<td><font size=1 face=Arial>Logged By</font></td>
<td><font size=1 face=Arial>Engineer</font></td>
<td><font size=1 face=Arial>Manhours</font></td></tr>\n";
do {
printf("<tr><td>%s</td></tr>\n", $myrow["Call_Received"]);
} while ($myrow=MySQL_fetch_row($result));
echo "</table>\n";
echo "</center>";
} else {
echo "Sorry,no records were found !";
}
?>