Easier queries?

From: Date: Mon, 14 Jul 2003 18:08:04 +0000
Subject: Easier queries?
Groups: php.general 
Request: Send a blank email to php-general+get-155135@lists.php.net to get a copy of this message
Here's what I'm thinking, just looking to see if anyone has done this or similar. - I have a MySQL DB and I create an ODBC datasource for it on my windows box - I then open MS Access and link the tables from my datasource - Access provides a graphical relationship builder, so I build relations in this - Access also provides a graphical query builder that uses the stored relationships - So I build a query, view the SQL and use the SQL code in some mysql_ PHP functions - Maybe next I instead save the queries in a query table so I can get them via simple name, like 'All_Customers' Sort of analogous to MS SQL Views? Sound good, or is there a better way? TIA -Shawn P.S. I've also seen mention of some graphical query builders. Can anyone recommend a good FREE one?

« previous php.general (#155135) next »