Hello again dear programming community again I need some assistance with one of my .PHP files.

What I'm trying to accomplish is to run this file twice a day to update the rankings of our users websites. When I run the script I get the error "HTTP-feil 500 (Internal Server Error)"

Could anyone help me? Detect any spelling errors? Improve the coding? Or if possible, complete it.
If you need more information then please do ask.

Thanks a ton in advance!

You have MANY PHP errors in the script.
http://www.raymondhill.net/finediff/viewdiff.php?data=ade30190e015c888a4148925ec70ad5d0dc6282e
http://codepad.viper-7.com/jkEkR2

Make sure the script doesn't contain these errors before you paste it here, otherwise we will not be able to help you with the real reason that the script isn't working.
If the 500 error still occurs with a valid version of your code example, there are ALOT of information online on the issue already.

I'm terribly sorry for not noticing those minor mistakes :| Was late at night and we had changed the document tons of times to try different techniques.
Here's an updated code:


We have got it "working" but our problem now is to set the rank PER site, so for the FOR have to start at the first row in the database and move to the next row for every pass.

Do you have any idea how to make something like that? In case you do, post your PayPal account with the code please, you deserve a donation

$i = 0;
while ($row = mysql_fetch_assoc($result)){
$i++;
$update = "UPDATE sites SET rank=$i where site_id=$row['site_id']" ;
$result = mysql_query($update);
}

i dont do php, but something to that effect

Hmmm, I wonder if using site_id is the right choice, because we use DESC by views to get the top ranked to be in row 1, that sites ID can be anything :| Will test if it though! I am also unsure if the $i = 0; and $i++ is working, because when I test, every sites rank get's set to 7 (we have 7 sites for testing)

Carteblanches' code should work fine. Can you paste the complete script that you used when every sites rank got set to 7?

<?php
include('config2.php');

$sql = "SELECT * FROM sites ORDER BY views DESC";
$result = mysql_query($sql) OR die(mysql_error());
$total = mysql_num_rows($result);

echo $total;


$i = 1;
while ($row = mysql_fetch_assoc($result)){
$i++;
$siteid = $row[site_id];
$update = "UPDATE sites SET rank=$i where site_id=$siteid" ;
$result = mysql_query($update);
}


?>

This "works" for the first site. First site get's set rank 1, but all the other sites get set to rank 7 :/ It's as if the WHILE runs, but does not update the RANK field on every pass, and updates every row except the first one when it is "finished" and $i=7

This is breaking me :')

$i = 1;
while ($row = mysql_fetch_assoc($result)){
$i++;
$siteid = $row[site_id];
$update = "UPDATE sites SET rank=$i where site_id=$siteid" ;
$result = mysql_query($update);
}

that might be the problem. delete the variable on the bottom.

This post was edited by carteblanche on Aug 5 2012 01:56pm

Tried to delete it, didn't do no good