Get everything out of the databse

[Bman900]

I have this code so far:

 

$result = mysql_query("SELECT * FROM question")

or die(mysql_error());

$row = mysql_fetch_array( $result ); 

echo "Name: ".$row['name'];

echo " Question: ".$row['question'];

echo " Email: ".$row['email'];

 

It only prints the last entry in the database.

[wildteen88]

if you are retrieving more than one row from the query you'll need to loop through the results.

// loop through the results
while($row = mysql_fetch_assoc( $result ))
{
    echo "Name: ".$row['name'];
    echo " Question: ".$row['question'];
    echo " Email: ".$row['email'];
}

[Bman900]

if you are retrieving more than one row from the query you'll need to loop through the results.

// loop through the results
while($row = mysql_fetch_assoc( $result ))
{
    echo "Name: ".$row['name'];
    echo " Question: ".$row['question'];
    echo " Email: ".$row['email'];
}

 

My God you are smart! Thank you!