A visual tool to help me construct MySQL queries

[haryanto]

Hi guys,

I am a designer and I had very limited programming knowledge. I've been trying really hard on programming but somehow those stuff never really sink in.
I am basically a visual guy.

Here is the problem. I am having trouble with MySQL and PHP. I want to do neat stuff in PHP but I have trouble generating commands and stuff. I was wondering if there is any visual tool that can help me contruct PHP and MySQL codes. Thank you in advance for your help guys!

[bcolflesh]

Not Free:

[ems-hitech.com...]
[interakt.ro...]
[navicat.com...]
[crlab.com...]

[mifi601]

phpMyAdmin is free

[haryanto]

But phpmyadmin doesnt help me create php codes
so no use.

[ukgimp]

I have converted mysql to access before now and used the query builder tool in access and then copied it back. Workds well in most cases, but some differences do occur.

for example

where table.col!= 1 works in mysql but in access you get

where table.col <> 1

if you are aware of things like this is is not too bad. I have re-written some that access produces as they tend to be inner joins which can look complex.

[mifi601]

phpmyadmin DOES write SOME code for you. It will get you started to understand the query language.