L Posted June 23, 2007 Share Posted June 23, 2007 Hey, I need help with my news script...i added comments so you can see what im trying to do. But basically i have two files, the submitnews.php and the show.php. Submitnews.php is a separate file so i can submit news to the database show.php shows the news article with the comments associated with it. THE PROBLEM: The News, user who submitted it, date, and the subject are all not showing. Only the comments are showing. Thank you for your time EDIT: Forgot to add the script...hehe... show.php <?PHP include("db.php"); // Get News ID $id = $_GET['id']; // Get the Actual News that matches the News ID $news = mysql_fetch_array(mysql_query("SELECT * FROM `news` WHERE `id`=$id ") or die(mysql_error())); // Get Comments for that specicif News ID $comid = mysql_query("SELECT * FROM `comments` WHERE `newsid`='".$news['id']."' ORDER BY `id` DESC LIMIT 0,50") or die(mysql_error()); // Display News Artical echo $news['news']; echo $id; ?> <table width="35%" cellspacing="2" cellpadding="2" border="2"> <tr> <td> User </td><td> Comment </td> </tr> <? // Set up an IP address that has access to delete comments $ip = $_SERVER['REMOTE_ADDR']; $okip = "24.15.10.41"; while ($view = mysql_fetch_array($comid)) { // Display all comments for artical, with Delete Comment Option if your IP matches the OK IP if ($ip == $okip) { echo "<tr><td><a href=\"mailto:".stripslashes($view['contact'])."\">".stripslashes($view['user'])."</a><br>".$view['date']."<br><center><a href=\"show.php?del=".$view['id']."\">[X]</a></center></td><td><textarea name=\"textarea\" cols=\"25\" rows=\"4\" wrap=\"virtual\" readonly>".stripslashes($view['comment'])."</textarea></td></tr>"; } // If it doesn't match it, display comments without delete option else { echo "<tr><td><a href=\"mailto:".stripslashes($view['contact'])."\">".stripslashes($view['user'])."</a><br>".$view['date']."</td><td><textarea name=\"textarea\" cols=\"25\" rows=\"4\" wrap=\"virtual\" readonly>".stripslashes($view['comment'])."</textarea></td></tr>"; } } ?> </table> <?PHP // This stuff is needed to delete the comment from the database $comment = $_GET['del']; if ($comment != NULL && is_numeric($comment)) { if ($ip == $okip) { mysql_query("DELETE FROM `comments` WHERE `id` = '".$comment."' LIMIT 1 "); echo "Comment has been deleted.<META HTTP-EQUIV=\"REFRESH\" CONTENT=\"2; URL=show.php\"> "; } else { echo "You do not have permission to delete comments."; } } ?> ~L Link to comment https://forums.phpfreaks.com/topic/56902-solved-help-on-news-script/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.