Posted on: 05/24/05 02:41pm
By: limiter
/** * Show upcoming reviews PHP Block function */ function phpblock_showupcomingreviews() { $dbserver = 'yourdatabaseserver'; $usr = 'yourusername'; $pass = 'yourpassword'; $db = 'yourdatabase'; mysql_connect($dbserver,$usr,$pass); mysql_select_db($db); $drafts_query_sql = "SELECT * FROM gl_stories WHERE draft_flag = 1 AND (tid = 'moviereview' OR tid = 'dvdreviews') ORDER BY date"; //you can include more topics by adding 'OR tid ='topicname' $drafts_query = mysql_query($drafts_query_sql); $drafts_rows = mysql_num_rows($drafts_query); if ($drafts_rows != 0) { $retval = $retval . "<ul>"; } $d = 0; while ($d < $drafts_rows) { $drafts_title = mysql_result($drafts_query,$d,'title'); $retval = $retval . "<li>" . $drafts_title . "</li>"; $d++; } if ($drafts_rows != 0) { $retval = $retval . "</ul>"; } return $retval; }