Trouble with fetching row (for)
Posted: Tue Jul 20, 2004 4:20 pm
Code: Select all
<?php
$host = "localhost";
$user = "xxx";
$pswd = "xxx";
$dbname = "xxx";
$connect = mysql_connect($host, $user, $pswd)
or die("Could not connect: " . mysql_error());
$database = mysql_select_db("$dbname")
or die(MySQL_Error());
$username = $_POST["username"];
$password = $_POST["password"];
$sql = "SELECT * FROM edh_centres";
$result = mysql_query($sql) or die("nothing in the database");
echo ("<table width="100%" border="0" cellspacing="0" cellpadding="0">");
for ($i=0; $i < mysql_num_rows($result); $i++){
$row = mysql_fetch_row($result);
echo("
<tr>
<td>$row[1]</td>
<td>$row[2]</td>
<td>$row[3]</td>
<td>$row[4]</td>
<td>$row[5]</td>
<td>$row[6]</td>
<td>$row[7]</td>
</tr>
");
mysql_close($connect);
?>Parse error: parse error, unexpected $ in /home/daniel12/public_html/zoro/center.php on line 48
wich is the last line of my code