Flare Sci-Fi Forums: Looking for MySQL Hints

This is topic Looking for MySQL Hints in forum Officers' Lounge at Flare Sci-Fi Forums.

To visit this topic, use this URL:
https://flare.solareclipse.net/ultimatebb.php/topic/10/2722.html

Posted by MinutiaeMan (Member # 444) on :

Well, it's a long story.

I've been working on a Trek-related database for nearly seven years now. I've used FileMaker Pro, which is the program that my father purchased for his business originally. I've hoped to be able to publish my work (eventually) on the web, but FileMaker database hosting has proven far too expensive.

However, I recently changed hosting services, and my new hosting package includes MySQL databases. I figured, why not create a new framework based on a made-for-the-web program, and get my work out there that way? It can't be that difficult...

Ha!

Although my hosting account has this control panel and some management pages, it's turning out to be a hell of a lot more complex than I ever thought it would be.

I've taken a look around at sites like mysql.com and phpmyadmin.net (the web interface for MySQL), but their documentation is obscenely long-winded, complicated, and apparently is based around command-line control of the whole thing. I've had a little bit of UNIX experience, but not nearly enough for something like this. And all the documentation I've found seems to be meant for direct manipulation of the databases, not through host-provided interfaces.

So what I'm hoping is, that someone here has a little bit of experience and can point me to a decent source for documentation, tutorials, and so on. I can purchase some books if I need to, but I frankly have no idea what I'm looking for or where to start... and I don't want to have to buy books that I don't need.

Please? [Smile]

Posted by E. Cartman (Member # 256) on :

Well, SQL is rather like a carriage to PHP's horse: the latter usually serves as a front-end for the former, so you'll need to learn both if you want to get the most out of either language.

SQL tutorials can be found all over the 'net - covering everything from the basics to more advanced topics.

The best source of documentation, by the way, is SQL's official page.