Page 1 of 1

While() @_____@

Posted: Wed Jun 06, 2007 3:38 pm
by Mightywayne
Here's what I need to do. ._. What happens is, for the first name that comes up, it makes a <td> with a light beige (sp?) background, and then if there's another name, it'll do it in a darker color.

Code: Select all

$check = 'light';
	  
if ($check == 'light')
{	    	  
while($rowz = mysql_fetch_array($results))
{
echo "<a href='pushalong.php?name={$rowz['firstname']} {$rowz['lastname']}'>{$rowz['firstname']} {$rowz['lastname']} </a>";
echo "<br>";
echo "<tr><td bgcolor='#FECB98' width='40%'>TEST1</td></tr>";
$check = 'dark'; }
}

if ($check == 'dark')
{	    	  
while($rowz = mysql_fetch_array($results))
{
echo "<a href='pushalong.php?name={$rowz['firstname']} {$rowz['lastname']}'>{$rowz['firstname']} {$rowz['lastname']} </a>";
echo "<br>";
echo "<tr><td bgcolor='#FEB66D' width='40%'>TEST2</td></tr>";
$check = 'light'; }
}
It'll only show the first one, "TEST1".

Posted: Wed Jun 06, 2007 4:01 pm
by volka
Proper indention should shed some light on the problem

Code: Select all

$check = 'light'; 
if ($check == 'light')
{               
  while($rowz = mysql_fetch_array($results))
  {
    echo "<a href='pushalong.php?name={$rowz['firstname']} {$rowz['lastname']}'>{$rowz['firstname']} {$rowz['lastname']} </a>";
    echo "<br>";
    echo "<tr><td bgcolor='#FECB98' width='40%'>TEST1</td></tr>";
    $check = 'dark';
  }
}

if ($check == 'dark')
{               
  while($rowz = mysql_fetch_array($results))
  {
    echo "<a href='pushalong.php?name={$rowz['firstname']} {$rowz['lastname']}'>{$rowz['firstname']} {$rowz['lastname']} </a>";
    echo "<br>";
    echo "<tr><td bgcolor='#FEB66D' width='40%'>TEST2</td></tr>";
    $check = 'light';
  }
}

Posted: Wed Jun 06, 2007 4:10 pm
by galbus
change to:

Code: Select all

$color = '#FECB98';
$n = 1;
          
while($rowz = mysql_fetch_array($results))
{
    echo "<a href='pushalong.php?name={$rowz['firstname']} {$rowz['lastname']}'>{$rowz['firstname']} {$rowz['lastname']} </a>";
    echo "<br>";
    echo "<tr><td bgcolor='{$bgcolor}' width='40%'>TEST{$n}</td></tr>";

    if ($bgcolor == '#FECB98')
    {
      $bgcolor='#FEB66D';
    }
    else
    {
      $bgcolor='#FECB98';
    }

    $n++;
  }
}

Posted: Wed Jun 06, 2007 4:20 pm
by Mightywayne
After some tweaking (you missed bg in the first color reference) it works. Thanks!

Posted: Wed Jun 06, 2007 4:28 pm
by WaldoMonster
Mabe something like this

Code: Select all

$i = 0;
// While loop
    {
?>
<tr>
    <td bgcolor="<?php echo ($i++ & 1) ? '#FEB66D' : '#FECB98'; ?>">....</td>
</tr>
<?php
    }