[SOLVED] right way to read data from a mysql database ?

[webmazter]

is this the right way to read data from a mysql database with php.

if so i get no results echoed.

mysql_select_db("fishdbs_fishdb", $con);

 

$result = mysql_query("SELECT * FROM fish");

?>

<p><?= $echo['scientificname']; ?>

 

</body>

</html>

[roopurt18]

http://us.php.net/mysql_query

 

Look at Example #2

[Barand]

good tutorial:

 

http://www.sitepoint.com/article/publishing-mysql-data-web

[soycharliente]

$result is just a mysql resource. It holds the data. usually you'll loop through the array and pull out any data. for example:

 

<?php
$sql = "SELECT * FROM table"; // the query
$result = mysql_query($sql) OR DIE (mysql_error()); // run the query to return the data in an array
if (mysql_num_rows($result) > 0) // if we got some data, move on
{
while ($r = mysql_fetch_array($result)) // loop though each element
{
	$name = $r['name']; // pull out a name
	$date = $r['date']; // pull out a date
	echo "<p>Name: {$name}<br />Date: {$date}</p>"; // this gets echoed once for each entry returned
}
}
?>