Can´t Delete a register

[plasmahba]

Hi
I have this code to delete a register from a database but everytime I click on the link I want to delete I clear all the registers.
I think I´m missing something basic here but I cannot see it.
Any help will be fully appreciated.

Select.php-->

<a href="erased.php?$Idc=ID"><? echo "$Name"; ?>

---

erased.php-->

$Idc=$_GET['Idc'];

mysql_query("DELETE FROM myDB WHERE ID = $Idc");

---

Thanks again

[mmilano]

take the '$' out of your link:

<a href="erased.php?Idc=ID"><?=$Name?></a> 

also, note the shorthand i used for injecting a php variable into html. it comes in handy.

[mmilano]

on a second look, .. make sure your 'ID' is an actual value:

<a href="erased.php?Idc=52"><?=$Name?></a> 

this wold delete id 52

[plasmahba]

Hi, thanks for your help.

I tried to do it again and still the instructions clears all the registers from the table instead the one you select.

What I´m doing is getting all the registers "name" from the DB in a list so the user can select one to delete. I´m agree with this
<a href="erased.php?Idc=52"><?=$Name?></a>

But , how can I know what register is which number?
Can I do it automatically?

Thanks again

[mmilano]

something like this:

<?
$result = mysql_query("select id,name from registry");
while($row = mysql_fetch_array($row)){
  echo "<a href=erased.php?Idc=".$row['id'].">".$row['name']."</a>\n";
}
?>

erased.php would look something like this:

<?
$result = mysql_query("delete from registry where id='".$_GET['Idc']."'");
?>

[plasmahba]

Hi again

This code finally worked

select -->
<a href="erased.php?&ID=<? echo "$ID"; ?>"><? echo "$name"; ?>

---

erased.php -->

mysql_db_query ("$DbNombre","DELETE from myDB WHERE ID='$ID'");

Thanks a lot for your help
Cheers