script.quakenet.org/paste

Id: 10572; Nick: n/a; Timestamp: 2008-05-14 20:46:07; Pasted as: mIRC
Description: n/a

						<?php
                        $result = mysql_query("SELECT * FROM `forum_kommentarer` ORDER BY `datum` DESC LIMIT 5") or die(mysql_error());
                        while ($rad = mysql_fetch_array($result)) 
						{
                        	$str = (strlen($rad['text']) > 26 ? substr($rad['text'], 0, 26).'...' : $rad['text']);
                        	echo "<tr><td width=\"127\"><a href=\"./?p=visa_trad&ID=".$rad['tradID']."#comment".$rad['commentID']."\" style=\"margin:left: 1px;\">".$str."</a></td><td width=\"7\">-</td><td><a href=\"./?p=profile&id=".$rad['userID']."\">".selectuser($rad['userID'])."</a></td></tr>"; 
						}
                        if (mysql_num_rows($result) < 5) 
						{ 
							$limit = 5-mysql_num_rows($result); 
							for($i=1;$i<=$limit;$i++) 
							{ 
								echo "<tr><td width=\"127\"></td><td width=\"7\"></td><td></td></tr>"; 
							}
						}
                        ?>

Parsed for bracket errors and indented:

<?php
$result = mysql_query("SELECT * FROM `forum_kommentarer` ORDER BY `datum` DESC LIMIT 5") or die(mysql_error());
while ($rad = mysql_fetch_array($result))
{
  $str = (strlen($rad['text']) > 26 ? substr($rad['text'], 0, 26).'...' : $rad['text']);
  echo "<tr><td width=\"127\"><a href=\"./?p=visa_trad&ID=".$rad['tradID']."#comment".$rad['commentID']."\" style=\"margin:left: 1px;\">".$str."</a></td><td width=\"7\">-</td><td><a href=\"./?p=profile&id=".$rad['userID']."\">".selectuser($rad['userID'])."</a></td></tr>";
}
if (mysql_num_rows($result) < 5)
{
  $limit = 5-mysql_num_rows($result);
  for($i=1;$i<=$limit;$i++)
  {
    echo "<tr><td width=\"127\"></td><td width=\"7\"></td><td></td></tr>";
  }
}
?>

Options: New, Download, , mIRC Parser;