Query of MySQL

wxdqz

New Member
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 !";
}

?>
 
Back
Top