in reply to SQL- for starters
You will probably be able to use the SQL statements directly out of the PHP code. This will save you the trouble of having to come up with the SQL on your own. However, if you're dead set on learning SQL, there are plenty of tutorial sites on the web. SQL in a Nutshell from O'Reilly is good, but it's more of a reference than a tutorial.
Another issue is the database you're using. If it's MySQL or PostgreSQL, there are direct DBI/DBD modules. However, if you're using a Microsoft Database such as SQL Server or Access, you'll have to setup and use ODBC. While that's not necessarily more difficult, you will need to set up an ODBC connection to the database on the hosting machine.
Using all the DBI/DBD modules is fairly strightforward and only requires that you download and install the appropriate drivers/interfaces. Check out
here in the monestary for some good information, tips, and tutorials.
HTH,
/Larry
|
---|