Easy way to make a Dbase with MySQL

[cortese21]

Okay I know I have asked this before in a round about way but here goes again....

I want to make a simple Dbase with example..........

Race Time Distance Name Place (and so on)

Next I want to be able to call it from either Cat. (race, Time, Distance and so on).... What is the easiest way to do this.... Is there a porgram out there that will let me make the cats and it will do all the PHP coding and so forth? Bare with me I am new to all this MySQL and PHP.... But it seems to be unlimitless so I must learn..... Also got PHP NUke up and running and what to get some good content in there...

THanks
Joe!

[jacobi]

Hi Joe,

I just upgraded to Macromedia Dreamweaver MX (http://www.macromedia.com/software/dreamweaver/), which works on both Windows and Mac platforms (I'm using Mac OS X). As part of Macromedia's integration of its former higher-end version of Dreamweaver (UltraDev) for programming "dynamic" content (i.e., databases), Dreamweaver supports a number of database protocols, including PHP/MySQL.

That said, the support is sparse, and I can't wait for an update from Macromedia. I have heard that Adobe GoLive also "supports" the same, but just as ineffective as Dreamweaver. I have overall been extremely pleased with Dreamweaver's ease of use and how productive it makes me in designing even static (html) pages. I'm more of a designer than a computer programmer.

Your best bet is to look at some of the pre-written freeware/shareware scripts on sites such as CGI Expo (http://www.cgiexpo.com/Scripts/42_PHP_Scripts/) or HotScripts (http://www.hotscripts.com/PHP/Scripts_and_Programs/). Both sites not only have PHP scripts, but CGI (PERL) scripts, which will also work on PowWeb sites. Be prepared to spend a lot of time browsing through the collection, though, because it is extensive. The good news is when you click on "Home page" for any of the scripts, it takes you to each script developer's Web site, and many offer a demonstration version of their script right on their site - so you can try it before you implement it. There is usually some minor "programming" involved in setting scripts up - meaning, you have to set the location, user and password for your MySQL database and the URL for your Web site, but most come with great documentation and "Read Me" files that tell you exactly what to type in. PowWeb's FAQs are a great complement to this process (i.e., the path to PERL or formmail). In fact, do read the PowWeb tutorials and FAQs about scripting in both PHP and PERL/CGI, so you'll be prepared. A little time spent researching and preparing now will save you much more time in the long run.

Finally, I posted some narrative on what solutions worked best for me here (http://forum.powweb.com/showthread.php?s=&threadid=11672). Pay special attention to what I said about the Dadabik (http://www.dadabik.org/) script.