Server crash/NSL with $i++

[Walgermo]

Hi

 

I am select something from the DB and counting it.

On the localhost on my own computer it works but on my server it crashes. Most likely for different versions of mysql / php!?

 

Here is the code, is there some other ways to write this? so the server doesnt crash:

 

$num = mysql_num_rows($result); 
$i=1; 
if($i < $num) 
{  
echo "<table border='1' width='100%'>"; 
echo "<tr><th>#</th><th>" . ucf(translate('country')) . "</th><th>" . ucf(translate('navn')) . "</th><th>" . translate('date') . "</th><th>" . ucf(translate('bodyweight')) . "</th><th>". translate('lifted') ."</th></tr>"; 

// keeps getting the next row until there are no more to get 
while ($row = mysql_fetch_array( $result ))  
{ 
    // Print out the contents of each row into a table 
    echo "<tr><td align='center'>"; 
echo $i++; // Krasj?? 
    echo "</td><td align='center'>"; 
    echo "<div><img src='img/flags/16/". strtolower($row['user_country']) .".png' /></div> " . translate(ucf(getCountryName(strtolower($row['user_country'])))) . ""; 
    echo "</td><td align='center'>"; 
    echo "<a href='index.php?action=profile&sub=show&tid=". $row['training_id'] ."'>" . getNameFromId($row['user_id']) . "</a>";  
    echo "</td><td align='center'>"; 
    echo formatDate($row['date'], $dateformat); 
    echo "</td><td align='center'>"; 
    echo r_nr2(calcFromKg($row['bodyweight'])). $w_metric; 
    echo "</td><td align='center'>";  
    echo r_nr(calcFromKg($row['kg'])). $w_metric; 
    echo "</td></tr>";  
} 

echo "</table> 
<div class='fixed'> 
                    </div> 
                </div> 
                </div> 
            <div class='fixed'> 
            </div> 
            <div id='footer'> 
            <a id='gotop' href='#' onclick='MGJS.goTop();return false;'>" . translate('top') . "</a> 
                <div align='center' id='copyright'>© " . translate('copyrightyear') . " " . translate('header_text'). " - " .  translate('curversion') ." - <a href='index.php?action=contact'>" . translate('contact') ."</a> - <a href='index.php?action=about'>" . translate('about') . "</a> - " . translate('onlineusers'). ": " . getActiveUsers() . "<br /> 
                </div>"; 
    exit; 
     
} 
else 
{ 
blablabla

 

Versions:

Local: php mysql 5.3 mysql 5.1.36

Server: php 5.29 mysql 5.0.87

 

I hope there is someone who sees something I have not seen here: P hehe ..

Thanks for the reply