Deleting Rows in Mysql via web

[Krusifix]

im unsure of what code to use in order to delete a specific row by ID # in the database...... keep in mind that this site is running phpnuke and this is within the module..... please help

OpenTable();
$query = "SELECT * FROM `joininfo1` ORDER BY `id` ASC";

				$result = mysql_query($query) or die("$query failed!");

echo "<table border=0 cellspacing=4 cellpadding=4 width=100%>";

		echo "<td bgcolor=#2B3954 colspan=6 align=center><b>DFExtreme Join Requests</b></td><tr>";



		echo "</table>";


				echo "<br>";

				echo "<table border=3 cellspacing=2 cellpadding=2>";

				echo "<td bgcolor=#414F68 align=center>Request ID</td>";

				echo "<td bgcolor=#414F68 align=center>Name</td>";

				echo "<td bgcolor=#414F68 align=center>Age</td>";

				echo "<td bgcolor=#414F68 align=center>ICQ</td>";

				echo "<td bgcolor=#414F68 align=center>Recent Squads</td>";

				echo "<td bgcolor=#414F68 align=center>Years Played</td>";

				echo "<td bgcolor=#414F68 align=center>Games Owned</td>";

				echo "<td bgcolor=#414F68 align=center>Email</td>";

				echo "<td bgcolor=#414F68 align=center>Comments</td><tr>";

				while ($row = mysql_fetch_row($result)) {

					echo "<td bgcolor=#2B3954 align=left>$row[0]</td>";

					echo "<td bgcolor=#2B3954 align=left>$row[1]</td>";

					echo "<td bgcolor=#2B3954 align=left>$row[2]</td>";

					echo "<td bgcolor=#2B3954 align=right>$row[3]</td>";

					echo "<td bgcolor=#2B3954 align=right>$row[4]</td>";

					echo "<td bgcolor=#2B3954 align=left>$row[5]</td>";

					echo "<td bgcolor=#2B3954 align=left>$row[6]</td>";

					echo "<td bgcolor=#2B3954 align=left>$row[7]</td>";

					echo "<td bgcolor=#2B3954 align=left>$row[8]</td>";



					echo "<td align=left><a href=admin.php?op=joindfx&action=delete&id=$del[0]>Delete</a> | ";

					echo "<a href=admin.php?op=joindfx&nr=$nr&cr=$cr&mod=$row[0]>Edit</a></td><tr>";

				}

				echo "</table>";



CloseTable();

[jpmoriarty]

well given as this is effectively an sql question, i always make sure i know the command direct into mysql before i worry about putting it into my php.

The delete query is:

$delete = "delete from table where condition";

so just run that as your query (ie mysql_query($delete)) and it will get rid of the row that contains the condition.

Just a note (and not a dig!) - people are usually keen for others to post code - but your code doesnt appear to have anything to do with your question, so you could have left it out! If it refers to the delete query that you're trying to run, then some indication of that might have been a good idea!

[Krusifix]

here is the line im worried about because nothing happens

echo "<td align=left><a href=admin.php?op=joindfx&action=delete&id=$del[0]>Delete</a> | ";

so what your say is to add something like this? before the link

$delete = "DELETE FROM 'table' WHERE 'id'=[$row]";