jQuery(document).ready(function(){
	
	jQuery("#flex1").flexigrid
			(
			{
			url: 'http://www.fifafanatic.com/wp-content/themes/InterPhase/post2.php',
			dataType: 'json',
			colModel : [
				{display: 'First Name', name : 'first_name', width: 80, sortable : true, align: 'center'},
				{display: 'Last Name', name : 'last_name', width: 100, sortable : true, align: 'center'},
				{display: 'Position', name : 'position', width : 40, sortable : true, align: 'center'},
				{display: 'Age', name : 'age', width : 30, sortable : true, align: 'center'},
				{display: 'Overall', name : 'overall', width : 40, sortable : true, align: 'center'},
				{display: 'Peak', name : 'peak', width : 30, sortable : true, align: 'center'},
				{display: 'Growth', name : 'growth', width : 40, sortable : true, align: 'center'},
				{display: 'Club', name : 'club', width : 100, sortable : true, align: 'center'},
				{display: 'Transfer Price (€)', name : 'transfer', width : 85, sortable : true, align: 'center'},
				{display: 'wage (€)', name : 'wage', width : 60, sortable : true, align: 'center'}
			],
			buttons : [
				{name: 'ALL', onpress: sortAlpha},
				{name: 'GK', onpress: sortAlpha},
                {name: 'DEF', onpress: sortAlpha},
				{name: 'MID', onpress: sortAlpha},
				{name: 'FWD', onpress: sortAlpha}
			],
			searchitems : [
				{display: 'Last Name', name : 'last_name', isdefault: true},
				{display: 'Club', name : 'club'},
				{display: 'Position', name : 'position'}
			],
			sortname: "last_name",
			sortorder: "asc",
			usepager: true,
			title: 'FIFA 09 Best Young Players',
			useRp: true,
			rp: 10,
			showTableToggleBtn: true,
			width: 585,
			height: 255
			}
			);   
	
});
function sortAlpha(com)
			{ 
			jQuery('#flex1').flexOptions({newp:1, params:[{name:'letter_pressed', value: com},{name:'qtype',value:jQuery('select[name=qtype]').val()}]});
			jQuery("#flex1").flexReload(); 
			}