Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include('../inc/conn.php');
- $conn = mysql_connect($host,$user,$pass);
- mysql_select_db($db, $conn) or die(mysql_error());
- $result = mysql_query("SELECT * FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' ORDER BY id DESC LIMIT 1") or die(mysql_error());
- while ($records = mysql_fetch_assoc($result)) {
- echo $records['post_title'] . " " . $records['post_content'] . "<br>";
- }
- $result2 = mysql_query("SELECT * FROM games_posts WHERE post_type = 'post' AND post_status = 'publish' ORDER BY id DESC LIMIT 1") or die(mysql_error());
- while ($records2 = mysql_fetch_array($result2)) {
- echo "<a href='" . $records2['guild'] . "'> . $records2['post_title'] . "</a>" . $records2['post_content'] . "<br>";
- }
- $result3 = mysql_query("SELECT * FROM tab_posts WHERE post_type = 'post' AND post_status = 'publish' ORDER BY id DESC LIMIT 1") or die(mysql_error());
- while ($records3 = mysql_fetch_assoc($result3)) {
- echo $records3['post_title'] . " " . $records3['post_content'] . "<br>";
- }
- ?>
Add Comment
Please, Sign In to add comment