Topic awaiting preservation: My silly question, forgive me. (Page 1 of 1)

Hi, guys. I will be really pleased if you would like to give me your couple of words, please.

Q. If I study SQL, do I still have to study PHP or ASP or whatever server side scripting languages?

I mean I am taking database class in polytechnic. In that class, I am going to study SQL. I have been wondering which server side scripting language I will take. I was nearly about to start to PHP until I see time table of this term.

I just thought if I study SQL in class, there will be no point to study ASP or PHP to make someting like E-commerce web site?

What do you think of my words? Am I correct?

Please give me your words. I will really really appreciate it.
Many thanks in advance.
cya.

Hiroki Kozai

Hiroki.
SQL is the language you use to talk to a database, "SELECT * FROM text WHERE text_id ='1' " means give me all collumns and rows from the table text if column text_id holds the value 1.

This in itself cannot be used in a webpage, you must have some kind of serverside language (PHP, ASP, JSP, Perl...) in order to connect to the database, send the SQL and do something with the stuff the SQL returns.

So, yes, you must learn a serverside language.
Which?

Well that depends on a lot of things.
Personally I prefer PHP and a MySQL datbase because it's free and easy to get started, and quite poverful once you know it. Plus there are a lot of web hosts offering this at a low cost.

The same goes for Perl and JSP as well I suppose but I just never got hooked on that. Web hosts for JSP is not as common as for PHP though.

ASP is sort of free as you develop at home using personal webserver (not an option in XP Home edition) but as soon as you "go live" you need a webhost with IIS which probably will cost you more money. Also, most webhosts with ASP support Access databases (which is ok for small stuff but not for bigger things) or MSSQL which is quite expensive. The combination ASP + MySQL is not that common even if it works.

That's my $0.02
/Dan

{cell 260}
-{ a vibration is a movement that doesn't know which way to go }-

Hi, Dms. Thank you very much. I got it.
Yes, I planed to study PHP as my choice of server side scripting.
I will do my best.
Have a great weekend.
Many thanks.
Cya.

Hiroki Kozai