Hi List, Just wanted to pick your brains please? I'm trying to standardise on the way I query databases and move away from the Dreamweaver built-in functions (which I know you all hate!) ;) I've been on this list for about 5 years now and I don't think I've ever heard anyone mention the Pear packages, eg: MDB_QueryTool and wondered if there was any reason why not? I found some classes on phpclasses and have already started using one of them by Henry Chen and there are plenty more. I am still using Dreamweaver as the text editor for PHP on a Mac and trying to code things manually but building SQL queries are one of the biggest problems I come across. To be honest, Dreamweaver used to be fine but for me, historically on both PC and Mac, after a while it decides that it can connect to the DB but cannot see any of the tables which prevent using the wizards which is why I'm moving away from it. All tutorials on the net are different and I'd like some info on the best practices that you guys follow when dealing with MySQL. Thanks in advance, Tom PS - I'm only dealing with simple queries: show, insert, update, delete, etc.
