my problem is that I often design my MySQL-Tables the exact same fashion I design my PHP-Classes (the only difference being that the PHP-Classes also have specific functions while the Database only holds the data, and that pointers to other objects (in PHP) are numeric references to a Table Index in MySQL).
I some time back found a neat class in the PEAR library (DB_DataObject: http://pear.php.net/package/DB_DataObject
) but could not get it to work, and anyway it seems pretty an overkill for my small applications... I don't need class-factories, thousands of config-files and stuff like that. I need a fast little library with a class I can extend with my own classes so that I can dynamically load the data from the tables into my classes, then work on those classes and at a later moment, maybe save them back to the database.
Does anyone know such a class? It would really help me a lot :)