ranking!

[canabatz]

i got this code for ranking users input to the data base

$resultr = mysql_query("SELECT id, rank FROM bidding_details where bid_id=$bid_id and sortbid='1' ORDER BY bid_price DESC");
$rank=1;
 
while ($myrow=mysql_fetch_row($resultr)) {
 
$id = $myrow[0];
mysql_query("UPDATE bidding_details SET rank=$rank WHERE bid_id=$bid_id and id=$id and sortbid='1'");
 
$rank++;
 
}    

i got serious problem when allot of users sending data to the data base in the same time ,my question is if that code can cause problem when user sending data in the same time ,the data is sent every second!
thanx

[TheServant]

From my understanding the way mysql handle things is one at a time. Requests are held back while others execute unless you are running multiple linked servers. You can add high priority requests, and also low one which are only run when nothings happening.

Just watch your server resources, as if it's very popular, you could need very high end solutions, like what I imagine eBay uses.