Don't know how to take ID from record source.PHP Code:$rec ="SELECT tbltracks. * FROM tbltracks,tblcollection WHERE tbltracks.FT_SuplProdID=tblcollection.suplprodid and tblcollection.barcode='$barCode' ORDER BY tbltracks.ID Limit ".($trackOrder).",1";
mysql_query("UPDATE tbltracks SET (Sound_Links='$SoundLink') WHERE tbltracks.ID ='{$row['ID']}'");




Reply With Quote