php and connections
<p>I have a problem with my code and the concatenation in some parts, please help! my code is:</p>

<pre><code>include('connection.php');

$q_books="SELECT name BID FROM books";
$r_books=mysql_query($q_books,$connection) or die(mysql_error()); 
$n_books=mysql_num_rows($q_books);

for($i=0; $i&lt;$n_books; $i++){

    echo "&lt;a href=\"bookinfo.php?BID=\".mysql_result($r_books,$i,'BID')";
    echo mysql_result($r_books,$i,'name');&lt;a&gt;&lt;br/&gt;

}
</code></pre>
