Hi All,

if ($updatecode == 3 ){
mysql_query("UPDATE tblcollection SET status = 3 WHERE barcode = '$barcode'");
}
else{
$rec=mysql_query("select * from tblcollection where barcode='".$barcode."'");
if($row=mysql_fetch_array($rec)){
//update
mysql_query("UPDATE tblcollection SET ( barcode = '$barcode', Title = '$title', Genre = '$genre',Boxsize = '$boxset' ) WHERE '$rec'");
}
else{
//insert
mysql_query("INSERT INTO tblcollection (barcode,Title,Genre,Boxsize) VALUES ('$barcode','$title','$genre','$boxset')");
}
}

I don't know how take id from $rec in
mysql_query("UPDATE tblcollection SET ( barcode = '$barcode', Title = '$title', Genre = '$genre',Boxsize = '$boxset' ) WHERE '$rec'");

Ramesh