spewn
Programmer
- May 7, 2001
- 1,034
i set up mysql on the comp and am using mysqlcc to manipulate.
however, i'm unable to access the databases that i have set up.
the server is gServer2, the database is 'ccc' and the table is 'offers'...
this worked previous, i don't know what the issue it.
any ideas?
- g
however, i'm unable to access the databases that i have set up.
the server is gServer2, the database is 'ccc' and the table is 'offers'...
this worked previous, i don't know what the issue it.
Code:
#!/usr/bin/perl
use CGI qw(:standard);
use DBI;
use CGI::Session;
$cgi = new CGI;
print $cgi->header();
$dbh2 = DBI->connect('dbi:mysql:ccc','','');
$sth2 = $dbh2->prepare("select offerID from offers where bannerImg = 'yes'");
$sth2->execute;
use constant COUNT0 => 0;
$count2 = $sth2->rows;
$test22=$row[COUNT0];
while (@row = $sth2->fetchrow_array()) {
print $test22;
}
print << "EOF";
<html>
<head>
<body>
hello world
</body>
</html>
EOFany ideas?
- g