I would like to be able to show the post that no longer has a related category. Remember that the id in the categories table no longer exists, however the related cat_id in the posts table is still there. Here is the relevent code the first is the function used to get the posts:
function get_posts($id = null, $cat_id = null) { $posts = array(); $query = "SELECT `posts`.`id` AS `post_id`, `categories`.`id` AS `category_id`, `title`, `content`, `date_posted`, `categories`.`name` FROM `posts` INNER JOIN `categories` ON `categories`.`id` = `posts`.`cat_id`"; if ( isset($id) ) { $id = (int) $id; $query .= " WHERE `posts`.`id` = '{$id}'"; echo mysql_error(); } if ( isset($cat_id) ) { $cat_id = (int) $cat_id; $query .= " WHERE `categories`.`id` = '{$cat_id}'"; } $query .= " ORDER BY `post_id` DESC"; $query = mysql_query($query); while ( $row = mysql_fetch_assoc($query) ) { $posts[] = $row; } return $posts;}
The next is the page used to display the posts:
<?php include_once('resources/init.php'); $posts = ( isset($_GET['id']) ) ? get_posts($_GET['id']) : get_posts();?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head> <style> ul { list-style-type: none; } li { display: inline; margin-right: 20px; } </style> <title>My Big Blog</title></head><body> <div> <ul> <li><a href="index.php"> Index </a></li> <li><a href="add_post.php"> Add Post </a></li> <li><a href="add_category.php"> Add Category </a></li> <li><a href="category_list.php"> Category List </a></li> </ul> </div><!--End of Nav division--> <div> <h1>My Big Blog</h1> <?php foreach ( $posts as $post ) { ?> <h2><a href="index.php?id=<?php echo $post['post_id']; ?>"><?php echo $post['title']; ?></a></h2> <p>Posted On: <?php echo date('m-d-Y h:i:s', strtotime($post['date_posted']) ); ?> in <a href="category.php?id=<?php echo $post['category_id']; ?>"><?php echo $post['name']; ?></a></p> <div> <?php echo nl2br($post['content']); ?> </div> <div> <ul> <li><a href="delete_post.php?id=<?php echo $post['post_id']; ?>">Delete This Post</a></li> <li><a href="edit_post.php?id=<?php echo $post['post_id']; ?>">Edit This Post</a</li> </ul> </div> <?php } ?> </div></body></html>
