PHP Help Please

[carp]

I want to get results from MySQL database and display them like this:

http://www.tricksoft.net/php/DT/topscores.php


Thanks in advance!




--=-=-=-=-=
The weirdest thing just happened to me. I came back to the forums and it said I was not logged in so I tried and it was an invalid account so I re-registered witht he same username and it workked lol. I was just here yesterday.
=--=-=-=-=-=

[chrisjk]

Off the top of my head...

<?php

// connect to db
$db = mysql_connect('localhost', 'username', 'password');
mysql_select_db('dbname', $db);

// query db
$scores_result = mysql_query('SELECT * FROM scores ORDER BY score DESC');
$rank = 0;

// loop through returned rows
while ($scores = mysql_fetch_array($scores_result)) {
      // print row
      $rank++;
      print $rank.' ';
      printf ("%s", $scores['name']);
      print ' ';
      printf ("%s", $scores['score']);
      print '<br>';
}

?>

[carp]

Sorry, I should have explained. I know how to get the results...But I want the colors to change for every result. Back and forth

[chrisjk]

I see

Try something like this...

$bgcolour = '#FFFFFF';

// print each row
while (...blah blah blah...) {
      // alternate colour
      if ($bgcolour = '#FFFFFF') {
          $bgcolour = '#000000';
      } else {
          $bgcolour = '#FFFFFF';
      }
}