Instructions for the impatient:

• Go to Mysql and Perl for the Web website
• Look at the examples
• Download the code that created such examples.
• Use it at will.

If you think you have more time, buy the book as well. It won't harm you.

Alternatively, if you feel that you want to spend some time learning how to do the job properly, then look at our Tutorials, and especially:

• Reading from a database
• Tricks with DBI
• HTML::Template Tutorial
• DBI recipes

Can someone just give me a snippet on how to connect to a MySQL db from a website?

#!/usr/bin/perl -T

use warnings FATAL => 'all';
use strict;
use DBI;
use CGI;

my( $dsn, $username, $password ) = qw( you tell me );

my $dbh = DBI->connect( $dsn, $username, $password )
    or die DBI::errstr;

my $q = CGI->new;

print $q->header, $q->h1( "Looks like we connected to $dsn!" );

exit;
[download]

You have much reading to do.

Let me suggest the following reading to you:

1. Before You Post ...
2. How (Not) To Ask A Question
3. Before asking a database related question ...
4. DBI recipes