ninja-joe has asked for the wisdom of the Perl Monks concerning the following question:
The code doesn't flag any syntax errors, so I'm a little confused. Is it me or something I should email the sysadmin about?#!/usr/bin/perl use DBI; use CGI qw/:standard/; import_names('f'); print header(); my $database = "databasename=default"; my $host = "host=mysql.domain.com"; my $driver = "DBI:mysql"; my $user = "user"; my $pass = "pass"; my $dbh = DBI->connect("DBI:mysql:$database;$host", $user, $pass) or print "Can't connect to mysql database: $DBI::errstr<br>"; $sth = $dbh->prepare("SELECT section, content FROM webdata WHERE secti +on=home") or print "Can't prepare statement: $DBI::errstr<br>"; $sth->execute() or print "Can't execute statement: $DBI::errstr<br>"; $dbh->disconnect();
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Problems with MySQL - "No Database Selected"
by chromatic (Archbishop) on May 09, 2002 at 21:09 UTC | |
by ninja-joe (Monk) on May 09, 2002 at 21:14 UTC | |
Re: Problems with MySQL - "No Database Selected"
by boo_radley (Parson) on May 09, 2002 at 20:47 UTC | |
by ninja-joe (Monk) on May 09, 2002 at 21:06 UTC | |
Re: Problems with MySQL - "No Database Selected"
by mephit (Scribe) on May 09, 2002 at 21:31 UTC | |
Re: Problems with MySQL - "No Database Selected"
by ninja-joe (Monk) on May 09, 2002 at 21:42 UTC |