I wrote a class-based MySQL API to perform and combine some common functions I use with PHP/MySQL programming. It's heavily based off of the MySQL PEAR project but pruned down for my usage and the MySQL->fetch() record actually works.
http://devnull.dtcc.edu/mysql/mysql.phps
http://devnull.dtcc.edu/mysql/index.phps
The tricky part with the fetch() function was actually keeping track of where the user was, so I fudged around it by using the $result as the identifying index of an array and also storing the current record set pointer in the array as well. So, to the main script, the $result stays the same, but in the class, the current position is tracked.
To see what the code actually does:
http://devnull.dtcc.edu/mysql/index.php
Any thoughts or tips for improvement would be appreciated.
