How can I delete a row with a <a href... link???

[juuso79]

I have made this switch and I try to use it with this href-link I only want to delete one row but it doestn work!!!

Please Help!!

/////////////////////////////////////////////////////
<a href=uusi.php?a=delete&ID_number='$a_row[0]'> <i>Delete . '$a_row[0]'</i></a>
///////////////////////////////////////////////////////
switch($a)
{

CASE &quot;delete&quot;:
mysql_query(&quot;DELETE FROM uutiset2 WHERE ID_luku = '$b_row[0]'&quot;
printf (&quot;Records deleted: %d\n&quot;, mysql_affected_rows());

BREAK;
}
/////////////////////////////////////////////////////

 

[sleipnir214]

Does this:

&quot;DELETE FROM uutiset2 WHERE ID_luku = '$b_row[0]'&quot;

create the string you thing it does? I see that the input parameter form the form submission is ID_number, but you refer to a variable $b_row;

 

[juuso79]

Doesnt help sorry

 

[sleipnir214]

If you do:

$mystring = &quot;DELETE FROM uutiset2 WHERE ID_luku = '$b_row[0]'&quot;;

print $mystring;

What do you get?

 

[juuso79]

DELETE FROM uutiset2 WHERE ID_luku = ''

and nothing else?

 

[sleipnir214]

Then $b_row[0] does not contain the value you need.

From the URL you describe in your initial post, the row id of the row you want to delete is in ID_number.

As that point do you move the data into $b_row[0]?

 

[juuso79]

My problem was that I tryed to put the $b_row[0] table value to single integer. When I tryed

<a href=uusi.php?a=delete&ID_number[0]='$a_row[0]'> <i>Delete . '$a_row[0]'</i></a>

it worked (stupid me)