DJ-Sound

Okay I'm having a bit of a problem. (notice it's 5am )

I have a query that loops through a max of 5 values. Then within that loop, I need to update 5 different fields with those different values. So essentially I need to run a different query for each value. (I think)

Currently have it as: (which of course doesn't work)
Where $uid contains the 5 different values and $recipient1 through $recipient5 need to be filled.
????: NamePros.com http://www.namepros.com/programming/617511-how-do-diff-query-each-value.html

Any ideas? I lack the fundamentals of php but I can't find the answer to how I should structure this.

Many thanks,
-Ryan

adamo

I dont know if I understood you right.

$uid is an array with 5 different values and you need to assign each value to a different field in the database?

__________________

DJ-Sound

Yeah I can make it an array, its currently a while loop.

(long join query)
while ($row = mysql_fetch_array($find_them)){
$uid = $row['uid'];

I need to insert the first instance/loop of uid into $recipient1 insert query, second instance/loop into $recipient2 etc etc


Thanks,
-Ryan

adamo

$i=1;
foreach($uid as $value){

$sql= "UPDATE table SET recipient$i = $value ..."
$i++;
...
}

__________________

Jim_

Something more like this, perhaps?

$i = 0;
while ($i < 5 && $row = mysql_fetch_array($find_them)){
$recipients[$i] = $row['uid'];
$i++;
}
//...
//...
//echo $recipients[0] . ", " . $recipients[1] ...

__________________
ask me about the internet

DJ-Sound

Thanks guys

Almost there,

View Code

The UPDATE leads query within the foreach loops is running twice as much as it should. The $find_the query is producing 2 $uid's and the querys in the foreach are running 4 times, so the $recipient1 and 2 is set to the first $uid and recipient3 and 4 is set to the second $uid. Which is a big problem.

Any ideas?

Thanks,
-Ryan

---------- Post added at 06:05 PM ---------- Previous post was at 04:42 PM ----------

Okay, for those interested, here is how I got it to work:
????: NamePros.com http://www.namepros.com/showthread.php?t=617511

for ($val1 = each($uid), $val2 = each($bid); $val1 || $val2;
$val1 = each($uid), $val2 = each($bid)) {

query goes here calling on the values like $val1[1] and $val2[1]

}