Get seperate variable for each row

Nixon

Hi please can you tell me how to get this script so that it recognises each row as a variable.


<?php

include("connectdb.inc.php"); 

$querytop= mysql_query( "select outwarusername, outwarlink, points, clicks from outwarinfo order by points desc limit 5" );

while ( $row=mysql_fetch_array($querytop)  )
{
$outwarname=$row["outwarusername"];
$outwarlink=$row["outwarlink"];
$outwarpoints=$row["points"];
$outwarclicks=$row["clicks"];

print "<table><tr><td width=150>$outwarname</td><td width=300><a href=\"$outwarlink\" target=\"_blank\">$outwarlink</a></td><td width=100>$outwarpoints</td><td width=\"100\">$outwarclicks</td></tr></table>";

}

?>

Thanks, Nixon

ahundiak

Not positive what you are asking but if you move the <table> and </table> tags to outside of the while loop then you will generate one html table with multiple rows.

Nixon

The table is working and everything. What I want to do is be able to alter each row coloum specifically. Say i want to do the first row coloum in red and the second in blue for example, at the moment i would only be able to change all the coloum rows i would not be able to change just one. Do you understand, its kind of hard to explain.

Nixon.

mystrymaster

you could assign your colors to variables and have them work on a count in the while loop


<?php

include("connectdb.inc.php"); 
// array to store the colors
$rowcolor[0] = 'red';
$rowcolor[1] = 'blue';
$rowcolor[2] = 'green';

$querytop= mysql_query( "select outwarusername, outwarlink, points, clicks from outwarinfo order by points desc limit 5" );
//Counter variable
$i = 0;
while ( $row=mysql_fetch_array($querytop)  )
{
$outwarname=$row["outwarusername"];
$outwarlink=$row["outwarlink"];
$outwarpoints=$row["points"];
$outwarclicks=$row["clicks"];

print "<table><tr bgcolor='$rowcolor[$i]><td width=150>$outwarname</td><td width=300><a href=\"$outwarlink\" target=\"_blank\">$outwarlink</a></td><td width=100>$outwarpoints</td><td width=\"100\">$outwarclicks</td></tr></table>";
// add one to the counter
$i++;

}

?>