MySQL Query Tool for php

[Bob]

I am making the jump from ASP/Access to PHP/MySQL.

And I really miss the ease of generating sql queries inherent in
access.

I've been reduced on occassion to modeling the database in access,
using access to generate the complex sql query then copying it over to
my php app.

Question: Is there a tool that interfaces to mysql and generates sql
queries?

thanks

[John Thingstad]

On 19 Oct 2003 05:47:03 -0700, Bob <cl****@qualitythink.com> wrote:

I am making the jump from ASP/Access to PHP/MySQL.

And I really miss the ease of generating sql queries inherent in
access.

I've been reduced on occassion to modeling the database in access,
using access to generate the complex sql query then copying it over to
my php app.

Question: Is there a tool that interfaces to mysql and generates sql
queries?

thanks

The human brain.
Why don''t you just learn SQL..

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

[John Downey]

John Thingstad wrote:

On 19 Oct 2003 05:47:03 -0700, Bob <cl****@qualitythink.com> wrote:

I am making the jump from ASP/Access to PHP/MySQL.

And I really miss the ease of generating sql queries inherent in
access.

I've been reduced on occassion to modeling the database in access,
using access to generate the complex sql query then copying it over to
my php app.

Question: Is there a tool that interfaces to mysql and generates sql
queries?

thanks

The human brain.
Why don''t you just learn SQL..

phpMyAdmin can help you generate queries if you for some reason don't
learn SQL. Its available at http://www.phpmyadmin.net/.

[Eto Demerzel]

In article <H6***********************@twister.neo.rr.com>, John Downey's
output was...

John Thingstad wrote:

Question: Is there a tool that interfaces to mysql and generates sql
queries?

thanks

The human brain.
Why don''t you just learn SQL..

phpMyAdmin can help you generate queries if you for some reason don't
learn SQL. Its available at http://www.phpmyadmin.net/.

PhpMyAdmin has actually helped me learn some SQL. I've used it to
generate queries, and in doing so, seen how these queries are
constructed, so I am subsequently able to construct them on my own.
And it doesn't cause an error in module explorer.exe, like access does;-)

[sk]

If you can connect to MySQL from your desktop PC (not a given on a
hosted server), then you can install a MySQL ODBC driver on your PC and
use Access or pretty much whatever you want to build queries.

--
Steve Koppelman
http://www.hatless.com/

Bob wrote:

I am making the jump from ASP/Access to PHP/MySQL.

And I really miss the ease of generating sql queries inherent in
access.

I've been reduced on occassion to modeling the database in access,
using access to generate the complex sql query then copying it over to
my php app.

Question: Is there a tool that interfaces to mysql and generates sql
queries?

thanks

[Bob]

Actually I do have quite an extensive knowledge of SQL. I should have
mentioned my queries are very long and very complex, spaning multiple
tables/databases.

And yes I can constuct complex queries, but in this time rushed world,
I prefer point and click.

cl****@qualitythink.com (Bob) wrote in message news:<cf**************************@posting.google. com>...

I am making the jump from ASP/Access to PHP/MySQL.

And I really miss the ease of generating sql queries inherent in
access.

I've been reduced on occassion to modeling the database in access,
using access to generate the complex sql query then copying it over to
my php app.

Question: Is there a tool that interfaces to mysql and generates sql
queries?

thanks