table('goods'), $db, 'goods_id', 'goods_name'); if ($_POST['goods_sn']) { $sql = "SELECT COUNT(*) FROM " . $ecs->table('goods') . " WHERE goods_sn = '$_POST[goods_sn]' AND is_delete = 0 AND goods_id <> '$_POST[goods_id]'"; if ($db->getOne($sql) > 0) { echo('[yes]'); } else { echo('[no]'); } } else { echo('[no]'); } ?>