I am not a proper programmer just done bits on Visual Basic, HTML, Java script. Im currentley at university and have been put into a group to develop a basic consumer website. I had to open my mouth and defend linux based web development against 5 hardcore Windows losers. Now im expected to elad this group what languages do you think i should learn? I have chosen apache to host the site and mysql for the backend.

Let me be the first to tell you that you have opened up a can of worms with this one. What language you use really depends on what you need the application to do.

Since you are using Linux/Apache/MySQL your probably going to want to use one of the P languages to complete your LAMP: PHP, Perl, or Python. Each language has its own strengths but I would say PHP is probably the most widely used in terms of a LAMP architecture. Check those out and pick the one that you are most comfortable with.

I do prefer Perl though.

PHP doesn't really have the feel of the languages like C, Java and Perl. But it is always preference at the end. Have a look at the syntaxes, and see which you are more comfortable with.

PHP is designed for web design, so some pieces of code are easier to write

I have seen bits about perl and done the hello world part i actually like it, from the ideas being put together about the site, i need perl to be able to read & write to a mysql database on one apache server and be able to send that data to another apache server somewhere which could update a mysql or ms sql server, prefable secureley!!!!!

Thanx for every1s input

How about JSP/Servlet? It runs on Windows and Linux, so the whole group should be satisfied. And since Apache Tomcat runs on both platforms, you all can code and debug on your own.

Perl, Apache run on both OS
If you go with Perl (my pref), lookup the CGI.pm module. The HTML stuff is avail as called subs, so you don't have to have embedded HTML, which makes it messy imho.
The Perl DBI will connect to multiple DBs, local or remote, if you use separate mysql_connect cmds;
Let me know if you want some code:
See these sites:
http://www.perl.com/pub/a/1999/10/DBI.html
http://search.cpan.org/~timb/DBI-1.45/DBI.pm
http://search.cpan.org/~rudy/DBD-mys...b/DBD/mysql.pm
http://www.perlmonks.com/

Great stuff, thansk alot chrism01 if ts ok ill take u up on that, ill add u to my buddy list, this why i love the linux community I have just started reading up on some perl beginners stuff, perl is looking good....

Update -

I have installed perl 5, mysql, created a table and now trying to connect to the sql table, have so far just managed to connect to it, but cannot manage to connect to it with username / password, i receive the error message : client does not support authenication protocol requested by server , consider upgrading mysql client

any ideas???

also ive been trying to connect to a txt file to read n print the text, it never works....heres the code

$file = 'C:\Documents and Settings\Administrator\Desktop\My Perl\db.txt';

open (INFILE, $file) or die "cannot open file: $!";

@my_file = <$file>;

print "Hello, $file!";

Another problem? help someone pls......

Can't locate DBI:MYSQL.pm in @INC <@INC Contains: c/perl/lib c:/perl/site/lib

theres a lil more but thats the main error message

any ideas