Code: Select all
$sql = 'SELECT * FROM orders WHERE cartid = "'.$cartid.'" AND customerID = "'.$userid.'"';
$query = mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($query) != 0){
//rows found
}else{
mysql_query("INSERT INTO orders (ordernum,cartid,album,albumid,customer,customerID,phone,email,photographer,address,city,state,zip) VALUE ('$new_name','$cartid','$albumname','$aid','$customer','$userid','$phone','$email','$photographer','$address','$city','$state','$zip')");
mysql_query('UPDATE carts SET ordernum = "'. $new_name .'", locked = "'. 1 .'" WHERE itemID = "'. $cartid .'"');
}~RB