mutiple instance of same "delete " buttong

[faisalabad]

HI everyone .. a newbe to php

i am accessing a table and assinging it to a associate array and with wile loop printing it as table, at the end of every row i have delete button (also part of the while loop ).....

what i want to do is for user to be able Click any "delete" and corrosponding row get deleted from database and then reprint the new updated table...

at the moment it seams only the first "delete" button respond, even that does not delete any record from data base .... help please i am stuck for last 4 days and new to php and programming ...

here is the code that print the table and delete buttons

 

<?php

 

if ($_POST['delete'])

{

 

 

$cattodel = $_POST['cat_id'];

 

mysql_query("DELETE FROM catalogue WHERE cat_id ='$cattodel'");

 

}

 

mysql_connect('localhost','root','root');

mysql_select_db('Catalogues');

 

$getdata = mysql_query("SELECT * FROM catalogue");

echo "

<table border='1'>

<tr>

<td>Catalogue number</td>

<td>Catalogue name</td>

<td>File name</td>

<td>Sale setup</td>

<td>Arrival date </td>

<td>Copy & Retails links</td>

<td>Images & Catalogues pages</td>

<td>Due date</td>

<td>Status</td>

</tr>

 

<form action='viewcatalogues.php' method='post' enctype='multipart/form-data'>";

 

while($data = mysql_fetch_assoc($getdata))

{

 

echo "

<tr>

 

<td>".$data['cat_id']."</td>

<td>".$data['catalogue_name']."</td>

<td>".$data['file_name']."</td>

<td><a href='".$data['sale_setup']."'>".$data['sale_setup']."</a></td>

<td>".$data['arrival']."</td>

<td>".$data['copy_retail']."</td>

<td>".$data['image_cata']."</td>

<td>".$data['due']."</td>

<td>".$data['status']."</td>

<td><input type='submit' name='delete' ></td>

</tr>

</form>";

 

}

 

echo "</table>";

 

?>

 

[-Karl-]

if isset($_POST['delete'])

 

 

You'll also need to POST the cat_id

 

<input type="hidden" name="cat_id" value="{$data['cat_id']}">

[faisalabad]

Thanks Karl .... thank you so much .... its working now  ;D ;D ;D

[-Karl-]

You're welcome sir, can you click the "Mark Solved" button at the bottom of the thread?