SQL

Good lord. I believe the server is running Apache, but I could be wrong. The SQL server is MySQL. I do think I have the ability to use PHP. I looked a little into that. There seems to be a piece of software called Code Charger that plugs into Front Page. It appears to be a PHP WYSIWYG editor, but I dunno. I take it what you then do is run SQL queries thru PHP?

This is my second attempt to learn a little bit about this stuff. It's not that interesting to me, really. Maybe I should just learn Java instead.

I've got other fish to fry, this was something I thought I might be able to hack together in an afternoon. Maybe I wouldn't even need SQL. I saw the SQL code in Access and thought perhaps that did more than just queries (ie, it was a mark-up like language as well -- or at least could be interpreted that way).

Bleah, my head is spinning. I feel like I don't have enough knowledge to even know what to ask. I hate that.

 

Trust me, SQL is very is easy to learn, Java Script is not. If you are developing web pages, it'll be in your best interest to learn SQL and learn it well. By doing so you'll be able to write queries and what not that are effecient. A lot of programmers write bad queries that are ineffecient and take much longer to run than needed.

I'm fine until I have to use Java, then things get tricky. I stick with VB Script as much as possible. Oracle is incorporating Java into their database...you can program Java code instead of SQL starting with 8i (I beleive)...there is also a pretty simple language called PL SQL....so you wouldn't be wasting your time if you are going to be workin with oracle by learning Java.

An advantage of Access is that it will be every machine with MS Office installed...it is universal in the business world, no additional liscenses needed, etc.

 

Yeah, I'm guilty of that all the time. I think "wow, it would be cool to do that, I bet I could whip that out real quick" and then after a few hours of investigation I realize how little I really knew about whatever it was before getting all hyped about it. But a lot of times it gets me interested in something and then I try to learn a lot about it.....

Acutally, it sounds like you just need something small, and I know this wouldn't fit with your host, but Access 2000 and XP have what they call Data Access Pages - they're similar to ASP pages, but the only catch is everyone who wants to look at them has to have a copy of Access on their computer. Fine for a corporate intranet or something like that, but not for the web.