[RESOLVED] Not all records are output

[iyatos]

After running a query in which three records in my database satisfy the query, only one is printed. After running:

$user = $_COOKIE['reecey_user'];
$fromd = "SELECT from_user FROM pms WHERE to_user = '$user' ";
$fromq = mysql_query($fromd) or die("could not run query");
$from = mysql_fetch_array($fromq,MYSQL_NUM)or die("could not run query");
$num = mysql_num_rows($fromq);
$num--;
$i = 0;
for ($i;$i <= $num;$i++){
echo $i . " : " . $from[$i] . ' ';
}

I get 0 : admin 1 : 2 :
When I run the same query in SQL, under PHPMyAdmin three records are given.

[devinemke]

$result = mysql_query("SELECT from_user FROM pms WHERE to_user = '" . $_COOKIE['reecey_user'] . "'") or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	echo $row['from_user'] . '<br>';
}

[iyatos]

thanks, how would I output more than one field?

[devinemke]

$result = mysql_query('SELECT field1, field2 FROM table') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	echo $row['field1'] . ' ' . $row['field2'] . '<br>';
}