Edit Entry

[MrBodean]

I have tried a number of ways and could not get it to work.

I just want to edit a certain line where I know the value of one of the fields

Here is what I do now
$mynum = 3;
$result=MYSQL_QUERY("DELETE FROM $db WHERE num = '$mynum'");
$result=MYSQL_QUERY("INSERT INTO $db (title,url,num)"."VALUES (''$mytitle','$myurl','$mynum')");

I delete it then add the updated one back in, is there a way to just edit it in 1 query without removing and adding?

Thanks,
Jeff

[cretaceous]

an UPDATE query might be what you want:

$sql = "UPDATE garment SET gname='$gname',gtype='$gtype' WHERE garm_id=$garm_id";

$result = mysql_query($sql);

[nemonoman]

You'd want to try an UPDATE statement, son:

UPDATE myQuestion SET answered='YES' WHERE title='Edit Entry'