Delete button to remove record in database

[Crazy_Bear]

$list  = mysql_query("SELECT subjectlink, title FROM event");

while($record = mysql_fetch_array($list)) {	    

	echo "<tr><td name='".$record['subjectlink']."'>" . $record['subjectlink'] . "</td><td>" . $record['date'] . "</td><td>" . $record['title'] . "</td><td>" . $record['subject'] . "</td><td>" . $record['description'] . "</td><td><input name='cmdEdit' type='button' value='Edit' /><input name='cmdDelete' type='submit' value='Delete'/></tr>";
	}

if(isset($_POST['cmdDelete']))
		{
			$list1  = mysql_query("SELECT subjectlink FROM event ");
			$record1 = mysql_fetch_array($list1);

		$del = mysql_query("DELETE FROM event WHERE subjectlink = '" . $record['subjectlink'] . "'");

}

i just want delete a query record and my code able to delete 1 record but not delete the recor di want, it delete from the end of the record, not the button i provide. can any1 help?

[Ivarska]

Are you sure subjectlink is unique for each row? And why do you use date, subject and description in the while-loop when you're only fetching subjectlink and title from the table?

[Crazy_Bear]

Correction[Just now when i paste forget ot add on....sry~@_@)

subjectlink is a primary key.


$list  = mysql_query("SELECT subjectlink, date, title, subject, description FROM event"); 

[CoderDan]

a) you aren't passing the id of the row to delete, and you need to pass the primary key along to know which to delete.
b) your delete query is using $record to identify, when I think (assuming you do (a) you want to use $record1.

[Crazy_Bear]

how to pass it?i try some way to define it but didnt work

[CoderDan]

well, either change to using $_GET and use a getstring that identifies it for each link, or make a separate post form for each row's buttons that contains it as a hidden input