If already then...

Manat

Hi,

If I am creating an admin form. So that a user can enter product information, and also a newly added field for product features.

I need to create that field(done), when the user enters the information it goes into a seperate newly created features table.
Each product has a SKU number. But, if a someone enters features info, and in two days comes back and add more features info, how do I, do an insert into if this SKU doesn't exist in the features table, and an UPDATE field SET, if the SKU already has features info in the table, rather than creating two records for the same SKU.

I would appreciate any help.
Thanks
MK

dfr574

Sorry if I'm not following what you are trying to say but, wouldn't it be

$sql = "SELECT * from tbl where SKU = some#";
$result = mysql_num_rows(mysql_query($sql));

if($result != 0){
insert statment
}
else{
update statment
}

maxxd

Wouldn't your Enter New Product and Update Existing Product pages be different? Basically, you enter a new product - including SKU number - when the product is brought to the shelf , so to speak (addNew.php). However, you have to choose the SKU number in order to update or edit information associated with the specific product, right (editExisting.php)?

So it shouldn't be a problem - you've just got the addNew.php page and the editExisting.php, each with a separate query.

Or am I missing something important here?

Don't get me wrong, dfr574's snippet is sound from a logical standpoint, but user error is rampant and you could easily end up with boatloads of wrong product SKUs with full information, and SKUs with incomplete information for the actual products. This is alleviated by making the user select the specific product to edit.

Manat

hi maxxd,

Yes, this is how my page is already structured... However, the only issue is that features is a newly added table, and field.
So, editExisting.php edits existings SKUs, and since features is a new field, it won't have that info already, so I could have easily ended up with duplicate records in the features table.

Thx

p.s. dfr574, thanks i splapped myself on the 4head when I read ur reply.