SELECT only puling first row! AHH help

Hi, in my PHP script I am using:

print_r(mysql_fetch_row(mysql_query("SELECT email, name FROM newsletter")));
print_r(mysql_fetch_row(mysql_query("SELECT COUNT(email), COUNT(name) FROM newsletter")));
die();

PHP:

newsletter table:

INSERT INTO `newsletter` VALUES (1, 'email1@email.com', 'name1');
INSERT INTO `newsletter` VALUES (2, 'email2@email.com', 'name2');
INSERT INTO `newsletter` VALUES (3, 'email3@email.com', 'name3');

Code (markup):

For some reason, it is only printing the first row

results:

Array ( [0] => email1@email.com [1] => name1 ) Array ( [0] => 3 [1] => 3 )

Code (markup):

 

You have to loop through the result.

$query = mysql_query("SELECT email, name FROM newsletter");

while ($row = mysql_fetch_row($query))
{
    print_r($row);
}

PHP:

 

then how do I use the implode function on it?

 

nico_swd right
this script print first result because you pull only first result

 

$query = mysql_query("SELECT email, name FROM newsletter");
$tmp = array();

while ($row = mysql_fetch_row($query))
{
    $tmp[] = $row['email'];
}

echo implode(', ', $tmp);

PHP:

 

You can't use that!

$q = mysql_query("SELECT email, name FROM newsletter");
while ($row = mysql_fetch_array($q))
{
  echo 'Email is: '.$row['email'];
  echo '<br />Name is: '.$row['name'];
}

PHP:

Like nico_swd said, you must use a loop (while or for is you'll count the results before the loop).