SQL query generator

[Smithy]

I'm rather new to server side scripting. I've been playing around with managing MySQL databases with PHP for a few months.

I'm developing a large user based "tool" for a game and came across a time consuming task which is susceptible to human error. I need to run a SELECT query which is based on many factors. I've already built the query, it took a long time and involved many nested OR statements. Keeping track of opening and closing all the brackets became very difficult.

Is there a program which can automatically generate SQL queries based on selected factors, in a GUI (rather than having to manually type it all out)?

Perhaps there is a function of phpMyAdmin which I am missing... or maybe a script which can run inside phpMyAdmin.

Looking for suggestions.

 

[suarve]

Thje commercial (paid version) of navicat mysql db manager has a built in query tool - like the ms access query designer.

 

[Tilluss]

There is a function of this in phpMyAdmin but i dont know how advanced it is for your needs. Go to the 'Search' tab and select all of the options you want from there and then once you search it will show a generated query at the top of the page.

 

[dangerstat]

I'm rather new to server side scripting. I've been playing around with managing MySQL databases with PHP for a few months.

I'm developing a large user based "tool" for a game and came across a time consuming task which is susceptible to human error. I need to run a SELECT query which is based on many factors. I've already built the query, it took a long time and involved many nested OR statements. Keeping track of opening and closing all the brackets became very difficult.

Is there a program which can automatically generate SQL queries based on selected factors, in a GUI (rather than having to manually type it all out)?

Perhaps there is a function of phpMyAdmin which I am missing... or maybe a script which can run inside phpMyAdmin.

Looking for suggestions.

{
To be honest you should be fine as long as you use a decent editor that does bracket highlighting (I.e. then you type a close bracket } it'll highlight where you opened it)