How to print out results

[kpowning]

Hi there, I was wondering how to write a script to printout information from my sql database on a webpage. Any help would be appreciated.

Thanks.
Kyle

[packland]

this should print out a list of the
data_field_to_print

entry in yourDBName

<?php
$db_name = "yourDBName";
$connection = @mysql_connect("localhost", "usename", "pword") or die("Couldn't connect.");
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select database.");
$table_name = "your_table_name";
$sql = "SELECT * FROM $table_name";
$result = @($sql,$connection) or die("Couldn't execute query.");
$i = 0;
while ($row = mysql_fetch_array($result)) {
$tmp = $row['data_field_to_print'];
print "$tmp<br>\n";
}
?>

Any help?