INSERT & UPDATE into db

[danielhalawi]

I'm using the following to insert into my table.

<?php 
// get form items 
$artistfirst = $_POST['artistfirst']; 
$artistlast = $_POST['artistlast']; 
$website = $_POST['website']; 
$label = $_POST['label']; 
$labelwebsite = $_POST['labelwebsite']; 
$bigpicture = $_POST['bigpicture']; 
$indexpicture = $_POST['indexpicture']; 
$smallerpic1 = $_POST['smallerpic1']; 
$smallerpic2 = $_POST['smallerpic2']; 

if ($artistfirst) {  

    $result = mysql_query("INSERT INTO db(artistfirst, artistlast, website, label, labelwebsite, bigpicture, indexpicture, smallerpic1, smallerpic2) VALUES ('$artistfirst','$artistlast','$website','$label','$labelwebsite','$bigpicture','$indexpicture','$smallerpic1','$smallerpic2')"); 
    if ($result) { 
        echo "<font size=2 face=Arial><b>".$artistfirst."&nbsp;".$artistlast."</b> has been added to site<br></font><font size=1 face=arial>The artist will appear on the site right now, so add some content.<BR><br>You are now being forwarded to the start of the submition please wait... </font><meta http-equiv=\"refresh\" content=\"10;URL=/submition.php\">";
		die (); 
    } else { 
        echo "Record NOT added<br>"; 
    } 
} else { 
        echo "<br><br><font size=1 face=Arial>your images have been uploaded, please continue with your upload</p></font>"; 
} 

?>

Now how can I update this so, that I can use it as an edit machine aswell.

[Drakla]

If you've got anything that's a primary field then you can use REPLACE INTO instead of insert / update. Also using this lazy method will save you huge time if you've got loads of fields - like you do

	/*		Does a replace into emailtemplates
	 *		insertion or overwrite will happen 
	 *		Variables assumed unescaped
	 */

function insert_email()
{
	$fields = array('name', 'subject', 'body');
	$data = array();
		// construct the query the lazy man's way
	foreach ($fields as $field)
	{
		$data [] = mysql_escape_string($_POST[$field]);
	}

$q = 'REPLACE INTO emailtemplates (' . implode(',', $fields) .') VALUES ("' . implode('"', $data) . '")';
$res = mysql_query($q);

return mysql_affected_rows();
}

Name your form elements the same as your fields then just spak them into the field list

[danielhalawi]

Sorry kinda newbie, that didn't make sense to me.