So I have one page that basically reads the entries I have from my table and out puts them with a link around the date so that when clicked your supposed to be able to delete it. Problem is when I click the link nothing happens. Heres the code for the page that lists the table.

//fetch from db
				$fetch = mysql_query("SELECT * FROM news ORDER BY id DESC",$link) OR DIE(mysql_error());
					if(mysql_numrows($fetch) < 1) {
						echo "<br /><br />No News.<br /><br />";
					}
					else {
						echo "<h3>News</h3><small>From newest to oldest. Click News Title to Delete.</small>";

						$r_count = 0;
						$c_1 = "c_1";
						$c_2 = "c_2";

						print "<table id=\"regs\">";			
							while($display=mysql_fetch_assoc($fetch)) {
								extract($display);
								
								$r_color = ($r_count % 2) ? $c_1 : $c_2 ;

								print "<tr class=\"".$r_color."\">";
								print 
									"<tr><td>".$newstitle."</td><td><a href=\"del.php?action=delnews&rid=".$id."\">".$newsdatetime."</a></td></tr>";
								print "</tr>";						
								$r_count++;
							}
						print "</table>";
					}

I have another page that includes the delete functions for all of my pages. Here is the code part of that file that corresponds to this page.

else if ($action == "delnews") {
	if ($rid != "") {
		if ($confirm == "") {
			$sql = mysql_query("SELECT * FROM news WHERE id='$rid' ",$link);
			while($disp=mysql_fetch_assoc($sql)) {
			extract($disp);

			echo "<p><b>Delete $newstitle?</b></p>";
	
			echo "<a href=\"?action=del&rid=".$id."&confirm=yes\">Yes</a><br /><a href=\"javascript:history.go(-1);\">No, return to add news page.</a>";
			}
		}
		else if($confirm=="yes") {
			//proceed deleting
			$sql="DELETE from news WHERE id='$rid'";
			$result=mysql_query($sql);

			if($result){
			echo "<h3>Deleted!</h3><p><a href=\"viewplayerprofiles.php\">Return to add news page.</a></p>";
			}
			else {
			echo "<h3>ERROR</h3>";
			adminindex();
			}
		}
		else {
			echo "<h3>error</h3>";
			adminindex();
		}
	}
}

When I click the link on the first page which is supposed to bring me to a confirmation page asking if I want to delete the entry, instead I get brought to a blank page with this in the address bar.

http://www.website.com/TEST/admin/del.php?action=delnews&rid=1

You do have $rid = $_GET['rid']; somewhere in your code ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.