html display mysql_query

[mbarmawi]

Hi All,

I am beginner in PHPand MySQL.
I wrote php script to display MySQL database.
the connection, database selection, and query were successfull, but i cannot display it in my browser.
there was an error, i.e.: Resource id #2
the code are below:

<?php
// Connecting, selecting database
$link = mysql_connect("localhost", "librarian", "libra")
or die("Could not connect: " . mysql_error());
print ("Connection successfull");
?>
<br>
<?
mysql_select_db("library")
or die("No database selected");
print ("Database selected");
?>
<br>
<?
$sql = mysql_query("select * from tblreferences") or die("Invalid query:" .mysql_error());
echo ($sql);
?>

Please help me!

Thanks,

[laserlight]

This is based on your own code...
It selects the whole table and displays each record in each row on a line.
The rows are separated by a horizontal rule.

<?php
// Connecting, selecting database 
$link = mysql_connect("localhost", "librarian", "libra") 
	OR die("Could not connect: " . mysql_error()); 
echo "Connection successful<br>"; 
mysql_select_db("library") 
	OR die("No database selected"); 
echo "Database selected<br>"; 
$sql = mysql_query("select * from tblreferences")
	OR die("Invalid query:" . mysql_error());
$num = mysql_num_fields($sql);
while ($row = mysql_fetch_row($sql)) {
	for ($i = 0; $i < $num; $i++)
		echo $row[$i] . "<br>";
	echo "<hr>";
}
?>