Sql Help

[RameshChaudhary]

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

[penagate]

Please use the [php]code here[/php] tags to post PHP code.

Use the index operator to access fields returned in a dataset. Use mysql_fetch_assoc() if you want to access them by field name.

$rec = mysql_query("select * from tblcollection where barcode='".$barcode."'");
if ($row = mysql_fetch_assoc($rec)) {
  //update
  mysql_query(
    "UPDATE tblcollection SET (".
    "barcode = '$barcode', Title = '$title', Genre = '$genre', Boxsize = '$boxset' )".
    "WHERE id = {$row['id']}"
  ); 

Assuming a field name of id.