Search Engine Friendly Database driven URLs

Search Engine Friendly Database driven URLs - I have a database driven php application - The URLs provided are in typical database format [ e.g. [login to view URL] ] - The application is mysql database driven and for SEO purposes I want very search engine friendly urls driven by database categories for example : [login to view URL] - There are about 30 product types, 2000 manufacturers, and thousands of product detail pages. - I need the url rewrite setup to be very efficient and fast - It must be very easy to add new url categories etc to reflect database changes - The selected provider must be able to briefly explain or provide specific comments explaining the .htaccess files etc - Now I could spend hours learning all about mod_rewrite etc to do this, but someone who has done this before will be able to do this in an hour or two ! - It would be a big plus if the bidder could also show me how to setup a sitemap in the new Google/Yahoo standard XML format that is also database driven. RESPONSES ========= - Please respond to the key requirements above point by point indicating your proposed solution. - Please include similar sites / demos you have developed in your response. - PLEASE DO NOT PROVIDE A STANDARD RESPONSE LISTING LOTS OF SITES NOT RELEVANT TO THIS PROJECT. ALL SUCH RESPONSES WILL BE DELETED. - Platform must be able to run on Apache/Linux Server with MySQL database. - This project is Price Sensitive