okay im just starting to learn PHP/MySQL... and I got this code from a book im reading to test and see if my SQL database is active... now i got it in alright but wheni go to the page it returns this error
Parse error: parse error, unexpected '>' in /home/yeuakon/public_html/mysql_up.php on line 16
and when i remove the <b></b> tags it gives me a "unexpected T_STRING" on line 16...
is there something wrong?
heres my code
Code:
<html>
<head>
<title>Test MySQL</title>
<body>
<!-- mysql_up.php -->
<?php
$host="localhost";
$user="yeuakon_smf1";
$password="";
mysql_connect($host,$user,$password);
$sql="show status";
$result = mysql_query($sql);
if($result == 0)
echo("<b>Error " . mysql_errno() . ": " . mysql_error() . " </b>);
elseif (mysql_num_rows($result) == 0)
echo ("<b>Query executed successfully!</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>
<?php } ?>
</body>
</html>
|
