Array Help

[jasonburns]

I am having a problem referencing an array, some help would be appreciated.

$query_WishList = "SELECT TrackID FROM wishlists WHERE SetID = $setid";
$WishList = mysql_query($query_WishList) or die(mysql_error());

If I run that SQl query directly on the DB, I get the results of 2 & 7, which is correct and what I am looking for. If I add the following:

$row_WishList = mysql_fetch_array($WishList); or $row_WishList = mysql_fetch_assoc($WishList);

And then call the array using print_r(array_values($row_WishList)); why does it only return the first number, 2. Do I need to enclose it in a 'do while' function? Is there a way to simply get a result of (2, 7) like the direct SQL query returns?

[Weedpacket]

Originally posted by jasonburns
Do I need to enclose it in a 'do while' function?

Basically yes. Or at least a loop of some form. What

$row_WishList = mysql_fetch_array($WishList); or $row_WishList = mysql_fetch_assoc($WishList);

does is tries to fetch an array; if it fails, it tries again. Conversely, if it succeeds first time, it doesn't bother trying again.

[mrhappiness]

and i thought it results in a parse error since or is no valid command 😉

[jasonburns]

The 'or' was just there to let you know I have tried both methods; mysql_fetch_assoc and mysql_fetch_array. Thanks for the help.