An ajax-based editable and sortable grid.

We have two tables in a database. One of them (table A) contains data maintained automatically (there is a program that every day refreshes it) and another table (table B) has data that needs to be manually edited. Both tables have a 1:1 relationship, but we use two instead of just one because it makes data load easier. We need a good looking web based editor that will show a grid, with data from both tables, and allow the fields from table B to be edited. The fields can be text, numbers, or dates (a calendar is expected to be displayed). Depending on one or more fields, some rows will be displayed in different colors. Editing must happen in real time, i.e. fields must be updated when they go off-focus, and it must happen automatically (no need to press a 'save' button for example). Database is MySQL. Tables already exist. We will provide the creation script for MySQL and sample data for table A. Table B will be empty after creation obviously and will be populated using this tool. For the table you can use any library you want as long as we can be use it for free (legally, of course). For the backend (i.e. getting the ajax events and doing the actual saving, and initially populating the HTML table) you must use PHP 5. The HTML must be sortable by all fields (sorting must be done correctly, so for date field you must sort by date, not alphabetically). Code must be in English and well commented.