working with arrays

[ligraci]

First of all, thanks in advance to anyone who can help me sort this thing out... I need to recall from the database certain records and I need to do it with one single GET command via http line (something like http://www.myhost.com/get.php?recordIDs=1,2,5,8)
What I did is:

$result = mysql_query("select rif,cat,dom from table",$db);
$list = array ($var);

if ($myrow = mysql_fetch_array($result))
foreach ($list as $v) {
$result = mysql_query("select rif,cat,dom from table where rif = $v",$db);
printf("%s|%s|%s", $myrow["rif"], $myrow["cat"], $myrow["dom"]);
} while ($myrow = mysql_fetch_array($result));

Is this the right way to do it? If yes, why isn't it working? If not, what's the right way to do it. I searched this message board for previous posts but I couldn't find any solution. Thanks again!

[Anon]

Try this:

$result = mysql_query("select rif,cat,dom from table",$db);

// This is what we need
$list = split(",", $recordIDs);

if ($myrow = mysql_fetch_array($result))
foreach ($list as $v) {
...

This will split the list you passed (seperated by commas) into an array. Hope that helps!

Chris King

[ligraci]

Thank you for your help, it worked well but now I have another problem.
This is my code:

$result = mysql_query("select rif,cat,dom from table",$db);
$list = split(",", $recordIDs);

if ($myrow = mysql_fetch_array($result))
foreach ($list as $value) {
$result = mysql_query("select rif,cat,dom from table where rif = $value",$db);
printf("%s|%s|%s", $myrow["rif"], $myrow["cat"], $myrow["dom"]);
} while ($myrow = mysql_fetch_array($result));

The problem is that $value seems to be always 1 instead of every value in my $list. Thanks again for your help!