I don't think there is api for external queries into cricinfo database.
mySQL can do pretty much everything that any other db can do. With version 5 it has stored procedures. So there's no limitation on how 'decent' a site you can make with php and mysql
Edited on, January 31, 2006, 3:04 AM GMT, by Nasif.