Datagrid - MYSQL/PHP Alphabetic filter

// for select query
var select_lv:LoadVars = new LoadVars ();
var errorMsgs:Array = ["", "Couldn't connect to server", "Couldn't connect to database", "Error running query", "First four entries may not be deleted"];
// create a string to show where to access the PHP script
var filepath:String;
// string to store video filepath
var videofilepath:String;
// create an array to be the dataprovider for the datagrid
var tabInfo:Array = [];
var tabAlpha:Array = [];
// create an object to listen for clicks on datagrid headers to do correct sort
var headerListener:Object = {};
headerListener.headerRelease = function (event:Object) {
	switch (event.columnIndex) {
	case 0 :
		if (tab_dg.getColumnAt (0).sortedUp) {
			tab_dg.sortItemsBy (tab_dg.columnNames[0], Array.CASEINSENSITIVE | Array.DESCENDING);
		} else {
			tab_dg.sortItemsBy (tab_dg.columnNames[0], Array.CASEINSENSITIVE);
		}
		tab_dg.getColumnAt (0).sortedUp = !tab_dg.getColumnAt (0).sortedUp;
		break;
	case 1 :
		if (tab_dg.getColumnAt (1).sortedUp) {
			tab_dg.sortItemsBy (tab_dg.columnNames[1], Array.NUMERIC | Array.DESCENDING);
		} else {
			tab_dg.sortItemsBy (tab_dg.columnNames[1], Array.NUMERIC);
		}
		tab_dg.getColumnAt (1).sortedUp = !tab_dg.getColumnAt (1).sortedUp;
		break;
	}
};
 
// script filepath
if (_url.indexOf ("http") != 0) {
	filepath = "http://davgra0.100webspace.net/scripts/";
} else {
	filepath = "../scripts/";
}
// video/tab file path
videofilepath = "http://localhost:8888/flv/";
// limit fields to max characters allowed by database
artist_ti.maxChars = 50;
song_ti.maxChars = 10;
 
// tab_dg changeListener
changeListener = new Object ();
changeListener.change = function (evt_obj:Object) {
	 textholder.tab_txt.text = "test";
	 var lv:LoadVars = new LoadVars();
	 lv.onData = function(thetext:String) {
		 textholder.tab_txt.text = thetext;
		 bufferClip._visible = true;
		 bufferClipCover._visible = false;
		 }
// load flv file
	ns.play(videofilepath + tabInfo[evt_obj.target.selectedIndex].flv);
// load tab file
lv.load(videofilepath + tabInfo[evt_obj.target.selectedIndex].tab);
}
 
tab_dg.addEventListener ("change", changeListener);
 
// load database
select_lv.onLoad = function (ok:Boolean) {
	if (ok) {
		if (this.errorcode == "0") {
			for (var i:Number = 0; i < this.n; i++) {
				tabInfo.push ({record:this["id" + i], artist:this["artist" + i], rating:Number (this["rating" + i]), song:this["song" + i], flv:this["flv" + i], tab:this["tab" + i]});
			}
			// only display Artist, Song, and Rating (not record id, flvname, tabname)
			tab_dg.columnNames = ["artist", "song", "rating"];
			// set formatting of artist column
			tab_dg.getColumnAt (0).width = 95;
			tab_dg.sort
			// trap header click event to sort case-insensitive on this field
			tab_dg.getColumnAt (0).sortOnHeaderRelease = false;
			// this property will keep track of whether sort is ascending or descending
			tab_dg.getColumnAt (0).sortedUp = false;
			tab_dg.getColumnAt (0).headerText = "Artist";
			// set formatting of score column
			tab_dg.getColumnAt (1).width = 95;
			// trap header click event to sort numerically
			tab_dg.getColumnAt (1).sortOnHeaderRelease = false;
			tab_dg.getColumnAt (1).sortedUp = false;
			tab_dg.getColumnAt (1).headerText = "Song";
			// set formatting of date column
			// auto-sort will work fine for this column
			tab_dg.getColumnAt (2).width = 70;
			tab_dg.getColumnAt (2).headerText = "Rating";
			// set dataProvider for datagrid
			tab_dg.dataProvider = tabInfo;
			// execute headerRelease function for correct sort when user clicks a header
			tab_dg.addEventListener ("headerRelease", headerListener);
			dbloaderMC._visible = false;
			panel._visible = true;
			msg_ta.text = "Select an item from the list to loac video.";
		} else {
			// show kind of error
			msg_ta.text = errorMsgs[Number (this.errorcode)];
			// if query error, show mysql_error
			if (this.errorcode == "3") {
				msg_ta.text += ": " + this.msg;
			}
		}
	} else {
		// if loadvars failed (eg, if script not found)
		msg_ta.text = "Flash-database select operation failed";
	}
};
dbloaderMC._visible = true;
msg_ta.text = "Getting tabs from database...";
select_lv.sendAndLoad (filepath + "getlivetab.php", select_lv, "POST");
 
 
 
// ----- ALPHA -------
 
// load records beginning with 'a'
      
var sender_lv:LoadVars = new LoadVars();
sender_lv.variableToSend = 'A';
var reciever_lv = new LoadVars();
receiver_lv.onLoad = function (ok:Boolean) {
     if (ok) {
          if (this.errorcode == "0") {
               for (var i:Number = 0; i < this.n; i++) {
                    tabInfo.push ({record:this["id" + i], artist:this["artist" + i], rating:Number (this["rating" + i]), song:this["song" + i], flv:this["flv" + i], tab:this["tab" + i]});
               }
               // set dataProvider for datagrid
               tab_dg.dataProvider = tabInfo;
               // execute headerRelease function for correct sort when user clicks a header
               tab_dg.addEventListener ("headerRelease", headerListener);
               msg_ta.text = "Select an item from the list to loac video.";
          } else {
               // show kind of error
               msg_ta.text = errorMsgs[Number (this.errorcode)];
               // if query error, show mysql_error
               if (this.errorcode == "3") {
                    msg_ta.text += ": " + this.msg;
               }
          }
     } else {
          // if loadvars failed (eg, if script not found)
          msg_ta.text = "Flash-database select operation failed";
     }
     msg_ta.text = unescape(this);
};
 
alpha_btn.onRelease = function() {
	sender_lv.sendAndLoad (filepath + "select_alpha_pass2.php", receiver_lv, "POST");
}