Jump to content


Photo

updating table with $rank++


  • Please log in to reply
2 replies to this topic

#1 herman19

herman19
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 18 May 2006 - 04:44 PM

<?

$result = mysql_query("SELECT * FROM mclinkscounter ORDER BY clic DESC");

$rank = 1;

echo "<table border=\"0\"><tr><td>Game Name</td><td>Description</td><td>Hits</td><td>Rank</td></tr>";

while($row = mysql_fetch_array($result)){
echo "<tr><td>" . $row['nom'] . "</td><td>" . $row['cat'] . "</td><td>" . $row['clic'] . "</td><td>" . $rank . "</td></tr>";
$rank++;
}
echo "</table>";
?>

This results in [a href=\"http://www.game-kings.com/php/test.php\" target=\"_blank\"]http://www.game-kings.com/php/test.php[/a]

Now, the first 3 values (nom, cat & clic) are taken from the database, the 'rank' value isn't, but I'm looking for something that updates the rank row in my database to the rank this code produces for that game.

Example: Bow man has rank 1 on this page, so I need something that sets rank = 1 for bow man, goldminer has rank 2 on this page, so I need something that sets rank = 2 for gold miner... etc.

I know how I can let the code run automatically, I just don't know the code yet :P

#2 alpine

alpine
  • Members
  • PipPipPip
  • Advanced Member
  • 756 posts
  • LocationNorway

Posted 18 May 2006 - 04:54 PM

Youre looking to update table ??
$id = "1"; // row id or similar
$clik = "2";

$update = mysql_query("update mclinkscounter set clik = '$clic' where id = '$id'") or die(mysql_error());

// or add up (+)
$update = mysql_query("update mclinkscounter set clik = clik + '$clic' where id = '$id'") or die(mysql_error());


#3 herman19

herman19
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 18 May 2006 - 07:42 PM

nah, I don't want to change anything about the clic and id and cat rows... they're all good.

the only thing I want to update is the rank field

EDIT: below is the working code

<?
$result = mysql_query("SELECT * FROM table ORDER BY clic DESC");

$rank = 1;

echo "<table border=\"0\"><tr><td>Game Name</td><td>Category</td><td>Hits</td><td>Rank</td></tr>";

while($row = mysql_fetch_array($result)){
echo "<tr><td>" . $row['nom'] . "</td><td>" . $row['cat'] . "</td><td>" . $row['clic'] . "</td><td>" . $rank . "</td></tr>";


mysql_query("update `table` SET `rank` = '". $rank ."' WHERE `id` = '". $row['id'] ."'") or die (Mysql_Error());

$rank++;
}
echo "</table>";
?>




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users