TO IMPLEMENT BESPOKE FINANCIAL REPORT
=====================================

1 Everything you need is contained in the directory form01.


2 Edit the source code for processor01.php:
	
	Where the text INSERT ALEGROCART DATABASE USER NAME HERE appears, change this text to the name of the database user that accesses your AlegroCart database. If you wish, you can create a database user solely for this function. The user will need rights to read from your AlegroCart database and to be able to create, update and delete a temporary table;

	Where the text INSERT ALEGROCART DATABASE USER PASSWORD HERE appears, change the text to the password for the database user entered in the previous step;

	Where the text INSERT ALEGROCART DATABASE NAME HERE appears, change the text to the name of your AlegroCart database;

	Where the text INSERT SORT ORDER HERE appears, change the text to the sort order that you wish your product lines to appear on the report. This should be in the following format -
		(Sort order sequence 1, Product id 1),
		(Sort order sequence 2, Product id 2),	
		(Sort order sequence 3, Product id 3),
		(Sort order sequence 4, Product id 4),
				.
				.
				.
		(Highest sort order sequence, Last product id)		
				
		Here -
			Sort order sequence 1 = "1"
			Sort order sequence 2 = "2"
			Sort order sequence 3 = "3" etc.
		and -
			Product id = "product_id" from the product_description table on the AlegroCart database
			
		An example format for the complete line of source code would be:
			$result = mysql_query("INSERT INTO chris_temp_product_sort_order VALUES
                (1, 27),
				(2, 26),
				(3, 25),
				(4, 32),
				(5, 31),
				(6, 30),
				(7, 28),
				(8, 36),
				(9, 29),
				(10, 37),
				(11, 35),
				(12, 34),
				(13, 33)");
			
				
3 Copy directory form01 onto your server.


4 To access this utility, enter the following URL into your browser:
	http://yourdomain.com/form01/form01.html