deletion on the same page
Posted: Fri Mar 26, 2004 12:11 am
Hai ! i wanted to delete a record from database on the same page . but i can only delete it if i click twice on the link ? why?
here are my codes
<head>
<script type="text/javascript">
function delete() {
<?php $dblink=mysql_connect("localhost","root");
mysql_select_db("database",$dblink) or die("no connection") ;
$query=mysql_query("DELETE FROM Staffs_Category WHERE category_name='$id'" , $dblink);
?>
}
</script>
</head>
<body onload = "delete()">
<table><tr>
<td><a href = "staff.php?id=<?php echo $row->category_name?>">delete</a></td>
</tr>
</table>
thanks for helping
here are my codes
<head>
<script type="text/javascript">
function delete() {
<?php $dblink=mysql_connect("localhost","root");
mysql_select_db("database",$dblink) or die("no connection") ;
$query=mysql_query("DELETE FROM Staffs_Category WHERE category_name='$id'" , $dblink);
?>
}
</script>
</head>
<body onload = "delete()">
<table><tr>
<td><a href = "staff.php?id=<?php echo $row->category_name?>">delete</a></td>
</tr>
</table>
thanks for helping