[Resolved] Functions within loops

La_Parka

I'm trying to create a function that alternates table background colors for each row outputted by a MySQL query, but am running into some problems with trying to get the function to distinguish one row from another. I have tried running a simple counter function within a loop, but it has been to no avail:

function counter()
{
	$i++;
	return $i;
}

echo "<table>";

$query = mysql_query("SELECT * FROM table");
while ($row = mysql_fetch_array($query))
{
	$num = counter();
	echo "<tr><td>$num</td></tr>";
}

echo "</table>;

My goal is to output "1" as $num for the first row, "2" for the second, and so on. However, with my current code, "1" is outputted for every single row.

Is there any way to increment a function's output?

LordShryku

Seems like overkill to use a function to increment a number, but try passing the number to the function

function counter($i)
{
    $i++;
    return $i;
}

And in the loop...

$num = counter($num);

yousaf931

This is the simple and easy code i can post

php:

</table>

yousaf931

This is the simple and easy code i can post


<table width="100" border="0" cellspacing="0" cellpadding="0">
 <?php 
 	$col_01= "#999999";
	$col_02= "#666666";
 	for($i=0; $i<10; $i++){
 ?>
 <tr>
    <td bgcolor="<?php if ($i%2){ echo $col_01; }else echo $col_02; ?>"><?php echo $i; }?></td>
  </tr>

</table>

La_Parka

Originally posted by LordShryku
Seems like overkill to use a function to increment a number, but try passing the number to the function
function counter($i)
{
    $i++;
    return $i;
} 
And in the loop...
$num = counter($num); 
[/B]

The actual function I sought was to alternate row colors, while the counter's purpose was to solve the more basic problem of getting a function to differentiate between each iteration of a loop. Your code appears to have done the trick for both. Thanks for the help.