# $sql = "UPDATE s_roster SET # # nickname=" . $sdb->quote_smart($_POST['nickname']) .", # {$sql} # name=" . $sdb->quote_smart($_POST['name']) .", # origin=" . intval($_POST['origin']) .", # location=" . $sdb->quote_smart($_POST['location']) .", # birth_date='" . $birth_date ."', # sex='" . ( ($_POST['sex'] == 'male') ? 'm' : 'f' ) ."', # website=" . $sdb->quote_smart($_POST['website']) .", # email=" . $sdb->quote_smart($_POST['email']) .", # msn=" . $sdb->quote_smart($_POST['msn']) .", # mouse=" . $sdb->quote_smart($_POST['mouse']) .", # storage=" . $sdb->quote_smart($_POST['storage']) .", # headphones=" . $sdb->quote_smart($_POST['headphones']) .", # monitor=" . $sdb->quote_smart($_POST['monitor']) .", # cpu=" . $sdb->quote_smart($_POST['cpu']) .", # memory=" . $sdb->quote_smart($_POST['memory']) .", # graphic_card=" . $sdb->quote_smart($_POST['graphic_card']) .", # soundcard=" . $sdb->quote_smart($_POST['soundcard']) .", # motherboard=" . $sdb->quote_smart($_POST['motherboard']) .", # connection=" . $sdb->quote_smart($_POST['connection']) .", # about=" . $sdb->quote_smart($_POST['about'])." WHERE user_id=". intval($userdata['user_id']); # $sdb->get_query($sql);