Sql T_STRING error :s

[FourthChapter]

Hey all, im writing this code to display links that users can add. Theres an error on line 13. Any ideas? Sorry i newb

		
		<?			$conn = @mysql_connect("host", "username", "password")
     or die("could not connect");
		 		$rs = @mysql_select_db("tablename", $conn)
     or die("could not select database");
		 		$sql="select * from es_usersites";
				$rs=mysql_query($sql,$conn)
		 or die("could not execute query");;

	 while($row= mysql_fetch_array($rs) )
	 {
	   $list .= "<tr>";
	   $list .= "<td>".$row["username"]."</td>";
		 $list .= "<td class=navigation align=\"left\"><a href=\".$row["address"].\">".$row["title"]."</a></td>"; //this line
	   $list .= "</tr>";
	 }

	 echo($list);
?>

Thanks very much

Matt

[mogster]

$rs=mysql_query($sql,$conn)
should be
$rs=mysql_query($sql,$conn);

knutm

[mogster]

And the line underneath has a double set of ; .....oh, I see...

Why do you compile the $list, then echo it?

Suggestion:

<?PHP            

$conn = @mysql_connect("host", "username", "password") or die("could not connect");
$rs = @mysql_select_db("tablename", $conn) or die("could not select database");
$sql="select * from es_usersites";
$rs=mysql_query($sql,$conn) or die("could not execute query");
while($row= mysql_fetch_array($rs))
{
echo "<tr><td>".$row["username"]."</td><td class=navigation align=\"left\"><a href=\".$row["address"].\">".$row["title"]."</a></td></tr>";
}
?>

. and do you have the <table> and </table>?

knutm 😉

[FourthChapter]

There is now an error with the following line:

{
echo "<tr><td>".$row["username"]."</td><td class=navigation align=\"left\"><a href=\".$row["address"].\">".$row["title"]."</a></td></tr>";
}

any ideas? any errors in the way its written?

thanks very much

Matt

[mogster]

Ah, yeah, you should probably use either none or single quotes inside the brackets (and there's also a missing " or two:

echo "<tr><td>".$row[username]."</td><td class=navigation align=\"left\"><a href=\"".$row[address]."\">".$row[title]."</a></td></tr>";

knutm