>
> I don't understand the code. I copy it from a book. I am trying to print out
> the records returned from a query. I have a table named client in database
> andy. The table has 2 records. When I run the above code, I have 2 blank
> lines return. Could any one tell me what the problem is? Where could I
> find better documentation on DBI::DBD::mysql stuff for beginner? man
> DBD::mysql is difficult to understand. Thanks again for the info.
>
> #!/usr/bin/perl
>
> use DBI;
> $dbh=DBI->connect('DBI:mysql:andy');
> my $query="select * from client";
> my $sth=$dbh->prepare($query) or die "cann't prepare".$dbh->errstr."\n";
> $sth->execute;
> my $rows;
> while(@row=$sth->fetchrow_array)
> {my $i;
> for $i (0..($sth->{num_of_fields}-1))
> {print "[".$row[$i]."]";}
> print("\n");
> }
> $sth->finish;
> $dbh->disconnect
Hi,
I'm not an expert in perl too, but i would correct your code to this:
> #!/usr/bin/perl
>
> use DBI;
> $dbh=DBI->connect('DBI:mysql:andy');
> my $query="select * from client";
> my $sth=$dbh->prepare($query) or die "cann't prepare".$dbh->errstr."\n";
> $sth->execute;
> my $rows;
> while(@row=$sth->fetchrow_array)
> {my $i;
> for $i (0..($sth->{NUM_OF_FIELDS}-1))
> {print "[".$row[$i]."]";}
> print("\n");
> }
> $sth->finish;
> $dbh->disconnect
Note the uppercase in $sth->{NUM_OF_FIELDS}.
Also remove the line "my $rows"... It's doing nothing there.
>
> >From: "Chuck \"PUP\" Payne" <[EMAIL PROTECTED]>
> >To: Doug Thompson <[EMAIL PROTECTED]>, Andy Cheng
> ><[EMAIL PROTECTED]>, Intrex <[EMAIL PROTECTED]>,
> >"[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> >Subject: Re: Mysql installation. Help!
> >Date: Sun, 10 Mar 2002 14:18:13 -0500
> >
> >Ok, if never run it then you have to start once, if I remember right undex
> >Red Hat, you have to go to /etc/rc.d/init.d and do this...
> >
> >./mysql start that will start it
> >
> >Then you will need to set it up so it will start later. SuSE you have to
> >start it once....
> >
> >You will then need to set a password for mysql.
> >
> >I hope that helps.
> >
> >
> > ----------------------------
> > | Chuck Payne |
> > | Magi Design and Support |
> > | www.magidesign.com |
> > | [EMAIL PROTECTED] |
> > ----------------------------
> >
> >BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
> >Web Design you can afford.
> >
> >Fortune for today --
> >
> >Q: How many Zen masters does it take to screw in a light bulb?
> >A: None. The Universe spins the bulb, and the Zen master stays out
> > of the way.
> >
> >
> >
> > > If mysql.sock doesn't exist, that is because the server is not running.
> > >
> > > I fought the same battle as Mark and ultimately downloaded and installed
> >the
> > > RPM for 3.23.49a from MySQL in place of
> > > the copy that came with RH. The MySQL RPM installed and came up just
> >like it
> > > says in the book. Saves a lot of hair
> > > and dain bramage.
> > >
> > > If the server process _is_ running, it may be useful to go through the
> >section
> > > on binary installation and check those
> > > items to see if your RPM set everything up correctly. Don't bet on
> >finding
> > > anything, but it doesn't take long to do
> > > these checks.
> > > http://www.mysql.com/doc/I/n/Installing_binary.html
> > >
> > > Regards,
> > > Doug
> > >
> > > "Perfection is finally attained not when there is no longer anything to
> >add,
> > > but when there is no longer anything to
> > > take away." -- Antoine de Saint Exup?ry
> > >
> > > On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote:
> > >
> > >> What I did was beat my brains out on the same exact problem. In the
> >end I
> > >> have no clue what I did to get it actually working. I had re-installed
> >the
> > >> mysql from the .tar.gz, I installed all the RPM's several times.
> >Everytime,
> > >> I fully rebooted the system, and finally I have to run
> > >> safe_mysqld --user=root
> > >>
> > >> I think finaly I ran the tar -zxvf on the mysqlmax.<version>.tar.gz,
> > >> rebooted the system, then re-ran safe_mysqld --user=root.
> > >>
> > >> Mark
> > >>
> > >> ----- Original Message -----
> > >> From: "Andy Cheng" <[EMAIL PROTECTED]>
> > >> To: <[EMAIL PROTECTED]>
> > >> Sent: Sunday, March 10, 2002 10:01 AM
> > >> Subject: Mysql installation. Help!
> > >>
> > >>
> > >>> Hi all,
> > >>> I got this error message when trying to connect to mysql at the shell
> > >>> command:
> > >>>
> > >>> Error 2002:Can't connect to local MySql server through socket
> > >>> '/var/lib/mysql/mysql.sock
> > >>>
> > >>>
> > >>> There is no mysql.sock in the /var/lib/mysql directory. Did I miss
> >some
> > >>> thing in the mysql installation? Where could I find the mysql.sock?
> >I
> > >>> install mysql that came with redhat 7.2. Thank for the help.
> > >>>
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > Before posting, please check:
> > > http://www.mysql.com/manual.php (the manual)
> > > http://lists.mysql.com/ (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> > > <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > >
> >
> >
> >---------------------------------------------------------------------
> >Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> >To request this thread, e-mail <[EMAIL PROTECTED]>
> >To unsubscribe, e-mail
> ><[EMAIL PROTECTED]>
> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
>
>
> _________________________________________________________________
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
--
dsoares
(sql)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php