Forum Moderators: open

Message Too Old, No Replies

I know this sounds dumb, but how can I use data once it's in MYSQL?

I know PHPmyadmin but is there some WYSIWYG way to manipulate the data?

         

brizad

3:49 am on Aug 23, 2007 (gmt 0)

10+ Year Member Top Contributors Of The Month



I've used mysql with forums and blogs. I don't know any DB language per se, although I'm not scared to make queries in PHPmyadmin if I'm given the command to execute. And I can poke around in the tables and usually eventually find what I need. That's all worked fine up until now.

Now I need to have a custom DB made to store some customer and sales info so I can track converting KWs, revenue, etc. I was just in the process of writing an ad to find someone to set this up for me and then it dawned on me that I have no idea how to use and manipulate that data once it's in there.

I searched for things like "mysql administration", "use mysql data", etc. but all I've found are command line things which I hope to avoid. I have the mysql administrator tool but that's really not much different from phpmyadmin. (Unless I'm missing something.)

Is there any WYSIWYG software that would allow me to view/sort/manipulate the mysql data or do I have to learn command line stuff? I'd even settle for some way to get it into a spreadsheet and use it that way.

It also dawned on me that maybe I don't even know enough about this to be specific about what I need a programmer to do, but I guess that's another subject.

I appreciate any ideas.

physics

6:28 pm on Sep 11, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Did you see these:

[mysql.com...] [OK, I guess you did see these but I included them for completeness]

[fileflash.com...]

Also, a programmer should be able to write a custom database admin program for you that will make it 'easy' for you to do the things you want to do with the data. You just have to be very specific about what you want to do with it if you want it to be easy to use though...

brizad

3:25 am on Sep 22, 2007 (gmt 0)

10+ Year Member Top Contributors Of The Month



Thanks physics I'll check them out. As a matter of fact the programmer did make me a nifty little interface which works pretty well.

Sorry for the delay in response. For some reason I never get notified of replies anymore.