function getsale($id) { $s = new Dedesql(false); $query = "select * from #@__basic where cp_number='{$id}'"; $s->SetQuery($query); $s->Execute(); $rowcount = $s->GetTotalRow(); if ($rowcount > 0) { $row = $s->getone(); return $row['cp_sale']; } $s->close(); }