Fetch problem

[karimali831]

Hi,

 

When I execute this query from phpmyadmin:

 

SELECT cupID FROM cup_clans WHERE clanID='1' AND 1on1='1'

It selects two rows from the cupID column which works fine.

 

And for php:

 

 

$isuser = safe_query("SELECT cupID FROM cup_clans WHERE clanID='1' AND 1on1='1'");
    $dp=mysql_fetch_array($isuser);
   
    echo $dp['cupID'];

 

echo's only one ID.. and not both?

 

I don't understand why? I want it to echo all rows in the cupID column.

[JAY6390]

You need to loop for each result

while($dp=mysql_fetch_array($isuser)) {   
    echo $dp['cupID'];
}