iPhone SDK develop & programming tips

  <?php 
	global $wpdb; 
 
	$sql = &quot;SELECT DISTINCT ID, post_title, post_password, comment_ID, 
    comment_post_ID, comment_author, comment_date_gmt, comment_approved, 
    comment_type,comment_author_url, 
     SUBSTRING(comment_content,1,30) AS com_excerpt 
    FROM $wpdb-&gt;comments 
    LEFT OUTER JOIN $wpdb-&gt;posts ON ($wpdb-&gt;comments.comment_post_ID = 
    $wpdb-&gt;posts.ID) 
   WHERE comment_approved = '1' AND comment_type = '' AND 
   post_password = '' 
   ORDER BY comment_date_gmt DESC 
   LIMIT 10&quot;; 
 
   $comments = $wpdb-&gt;get_results($sql); 
   $output = $pre_HTML; 
   $output .= &quot;\n&lt;ul&gt;&quot;; 
   foreach ($comments as $comment) { 
	$output .= &quot;\n&lt;li&gt;&quot;. &quot;&lt;p&gt;&lt;a href=\&quot;&quot; . get_permalink($comment-&gt;ID) . 
		&quot;#comment-&quot; . $comment-&gt;comment_ID . &quot;\&quot; title=\&quot;on &quot; . 
		$comment-&gt;post_title . &quot;\&quot;&gt;&quot; . strip_tags($comment-&gt;com_excerpt) 
		.'&lt;/a&gt;('.strip_tags($comment-&gt;comment_author). ')&lt;/p&gt;&lt;/li&gt;'; 
   } 
   $output .= &quot;\n&lt;/ul&gt;&quot;; 
   $output .= $post_HTML; 
   echo $output;
   ?>