
June 19th, 2003, 04:12 PM
|
|
|
|
Join Date: Apr 2007
Location: Medina, Ohio
Posts: 233
Time spent in forums: < 1 sec
Reputation Power: 2
|
|
|
RE: Random Rows Help!
try this:
php Code:
Original
- php Code |
|
|
|
<?php for ($times = 1; $times <= 5; $times++) { $result = mysql_query("SELECT * FROM usershowentries ORDER BY rand();", $db); $horsename = $rows[horsename] { $query = mysql_query("select * from horsedata where horsename='$horsename'"); $sum = $rows[horsepoints] + 50; mysql_query("update horsedata set horsepoints='$sum' where horsename='$horsename'"); echo "$horsename got 50 points!"; } } ?>
|