-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi thanks .. for telling me tht DBI dont accept $!
erm i still have problems though. Theres actually data in the this table made
up of 2 columns. But, apparently my query keep returning "0" and "new" which
I cant understand why.
#!/usr/bin/perl -w
use DBI;
# connect to the db server
my $dbh = DBI -> connect('dbi:mysql:database:hostname:3306', 'xxx');
my $error = $dbh -> errstr;
my $sql = "select status_id, description from status";
my $query = $dbh -> prepare($sql);
# execute the query
$query -> execute ;
# return the results
my ($results) = $query -> fetchrow_array;
print "$results \n";
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE+hL2JNgvTa7Hj2AURAgsCAJ9xk4wkpDUB1U6vZyE4TZUQg6pCCwCfU2AL
UOyjIwsO7yij9Gjb1n9OQmI=
=/EUQ
-----END PGP SIGNATURE-----
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
