webmazter Posted May 13, 2008 Share Posted May 13, 2008 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> Quote Link to comment Share on other sites More sharing options...
roopurt18 Posted May 13, 2008 Share Posted May 13, 2008 http://us.php.net/mysql_query Look at Example #2 Quote Link to comment Share on other sites More sharing options...
Barand Posted May 13, 2008 Share Posted May 13, 2008 good tutorial: http://www.sitepoint.com/article/publishing-mysql-data-web Quote Link to comment Share on other sites More sharing options...
soycharliente Posted May 13, 2008 Share Posted May 13, 2008 $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 } } ?> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.