Flexible Query Functions

gistfile1.aw

<?
function submit()
{
	$fields = array(
		'first_name',
		'last_name',
		'email',
		'phone'
	);
	
	$fields_user=array(
		'gender',
		'birthday',
		'display_name'
	);
	
	$fields_moderator = array(
		'gender',
		'birthday',
		'display_name',
		'position_title'
	);
	
	$fields_administrator = array(
		'gender',
		'birthday',
		'display_name',
		'position_title',
		'show_online',
	);
	
	$fields_staff = array(
		'position_title',
		'show_online'
	);
	
	$fields = array_merge($fields, ${'fields_'.$_SESSION['member']['member_type']});
	
	foreach($fields as $f)
	{
		if (isset($_POST[$f])) {
			if (is_array($_POST[$f])) {
				
			} else {
				$set[] = $f .' = "'. mysql_real_escape_string($_POST[$f]) .'"';
			}
			$data[$f] =$_POST[$f];
		}
	}

	$query = 'UPDATE members SET '. implode(', ', $set) .' WHERE id='. $_SESSION['member']['id'];

	query($query);

?>