Re: mysql test and error
| From: | hE | Date: | Sun, 24 Feb 2008 22:00:41 +0000 |
| Subject: | Re: mysql test and error | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-270014@lists.php.net to get a copy of this message | ||
The following program gave the error:
"Parse error: parse error in C:\apache\htdocs\mysqltest.php on line 10"
<html>
<head><title>Test MySQL</title></head>
<body>
<!-- mysql_up.php -->
<?php
$host=”localhost”;
$user=”root”;
$password=””;
mysql_connect($host,$user,$password);
$sql=”show status”;
$result = mysql_query($sql);
if ($result == 0)
echo '<b>Error ' . mysql_errno() . ': '. mysql_error() . '</b>';
else
{
?>
<!-- Table that displays the results -->
<table border=”1”>
<tr><td><b>Variable_name</b></td><td><b>Value</b>
</td></tr>
<?php
for ($i = 0; $i < mysql_num_rows($result); $i++) {
echo '<TR>';
$row_array = mysql_fetch_row($result);
for ($j = 0; $j < mysql_num_fields($result); $j++)
{
echo '<TD>'. $row_array[$j] . '</td>';
}
echo '</tr>';
}
?>
</table>
</body></html>
what is the reason?