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.
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.