Walgermo Posted February 4, 2011 Share Posted February 4, 2011 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.