Formatting text

[neilmurray]

Hi,

I have selected a row from a table where the column names are:

id, money, com1, com2, com3, com4, com5, com6

I want to do a loop where I run a function on each one of the com1, com2 etc. values one at a time.

Is there any way I can format the text to be say

for ($i=1;$i<=20;$i++)
{
$answer = com$i +whatever
}

So I can run the same loop for each of the com values.

Thanks,

Neil.

 

[r937]

no

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[TonyGroves]

It depends on the language and database interface you're using. I don't know much PHP, but I think you could do something like:[tt]
$answer = $row["com".$i] + $whatever;[/tt]
where the '.' represents the PHP string concatenation operator, whatever that is.