Edit and delete row from db :(

[kekke]

Hi!

I´m really stuck right now and would need some help.

I need to know if there is somewhere a tutorial for editing or deleting a row from mySQL.

First I have a page in html with a form. I fill out the form and the result is inserted into the database. Works fine.

Second, I have a page called visa_leftpuff.php and it is displaying the results from the db as I want it to. See example:

http://testlabbet.pixelstorm.se/nyheter/visa_leftpuff.php

Now I want to edit or remove these "puffs". How do I do that? I have searched and found a lot of tutorials, but noone that have helped me. I´m almost there though... I have a page called radera_puff.php ... where I get a list of the puffs but then I don´t know what to do... see example:

http://testlabbet.pixelstorm.se/nyheter/radera_puff.php

Please help! Thanks in advance!

[bubblenut]

delete from table where row='condition' && row2='condition';

update table set row='value', row2='value' where row3='condition' && row4='condition';

Be carefull with update statements as if you leave off the where condition the statement will update every row in the table.

HTH
Bubblenut

[kekke]

Thanks Bubblenut! Ok...some code to make it more clear to you:

This is the file radera_puff.php

<form method="get" action="radera_puff2.php">

<?
mysql_pconnect("db_host","db_username","db_pass"); //connect to the mySQL
mysql_select_db("my_db"); //select the db
if(!$submit)//if submit has not already been pressed
{
    $result = mysql_query("select * from leftpuff order by id"); //select all the news

while($r=mysql_fetch_array($result)) //run the while loop

  { 
        $title=$r["title"];//take out the title
        $id=$r["id"];//take out the id
        ?>
        <INPUT TYPE="RADIO" NAME="id" VALUE="<?php echo $id;?>">
		<?php echo $id;?> <?php echo $title?><br> 

<?
    }
?> 
<input type="submit" value="submit" name="Submit"></form>
<?
}?>

...and here is some code that I don´t know where to go

<?PHP 
else { $sql = "$sql = "delete from news where id=\"$id\""; $result = mysql_query($sql); echo "Puff raderad!"; }
?>

Look at the urls I posted! Any ideas?