Outputting data from the database

[Aybabtu]

Can some one help me remember how the while statement works. I am trying to output variables from a table in my database.

[stolzyboy]

pretty generic connection, query, and display

<?
$conn = mysql_connect("localhost", "username", "password") or die(mysql_error());
$db = mysql_select_db("database_name") or die(mysql_error());

$query = "select * from table_name;";
$result = mysql_query($query) or die(mysql_error());

while ($row = mysql_fetch_array($result))
{
echo $row['fieldnamefromtable'] . "<br>";
}
?>

[Aybabtu]

thanks!!!

[paulnaj]

$result = mysql_query("SELECT name FROM mytable");

Either ...

while($obj = mysql_fetch_object($result)){
echo $obj->name;

}

... or ...

while($row = mysql_fetch_row($result)){
echo $row[0];

}

... or ...

while($hash = mysql_fetch_array($result)){
echo $hash["name"];

}

etc.