$DBName, Looser"); $sql = 'SELECT wp_posts.post_title FROM `wp_posts`, wp_post2cat WHERE wp_posts.id = wp_post2cat.post_id and wp_post2cat.category_id = \'3\' ORDER BY `wp_posts`.`post_date` DESC'; */ mysql_connect($Host, $User, $Password) or die(mysql_error()); mysql_select_db("$DBName") or die(mysql_error()); // Retrieve all the data from the "example" table $result3 = mysql_query("SELECT wp_posts.post_title FROM `wp_posts`, wp_post2cat WHERE wp_posts.id = wp_post2cat.post_id and wp_post2cat.category_id = 3 ORDER BY `wp_posts`.`post_date` DESC") or die(mysql_error()); $result4 = mysql_query("SELECT wp_posts.post_title FROM `wp_posts`, wp_post2cat WHERE wp_posts.id = wp_post2cat.post_id and wp_post2cat.category_id = 4 ORDER BY `wp_posts`.`post_date` DESC") or die(mysql_error()); $result6 = mysql_query("SELECT wp_posts.post_title FROM `wp_posts`, wp_post2cat WHERE wp_posts.id = wp_post2cat.post_id and wp_post2cat.category_id = 6 ORDER BY `wp_posts`.`post_date` DESC") or die(mysql_error()); // store the record of the "example" table into $row $row3 = mysql_fetch_array( $result3 ); $row4 = mysql_fetch_array( $result4 ); $row6 = mysql_fetch_array( $result6 ); // Print out the contents of the entry /* echo $row3['post_title']; echo $row4['post_title']; echo $row6['post_title']; */ ?>
<more>';
}else{
echo '<more>';
}
?>
<more>";
}else{
print "<more>";
}
?>
<more>";
}else{
print "<more>";
}
?>