Re: Problem with "while/fetchrow_array"
From: Chris Denman (cjdenman_at_gmail.com)
Date: 12/29/04
- Next message: Ron Wingfield: "Off Topic: Tsunami"
- Previous message: Cosimo Streppone: "Re: Parallel::ForkManager && DBI memory leak ?"
- In reply to: Ron Wingfield: "Problem with "while/fetchrow_array""
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Wed, 29 Dec 2004 18:40:25 +0000 To: Ron Wingfield <rtwingfield@archaxis.net>
With all due respect, why don't you learn how to program like the rest of us.
I learned to program with research and trial and error. I used search
engines, purchased books and borrowed code. It took me ages to get a
script to run, let alone connect to a database (permissions!).
I think I have only asked a group a question twice in many years (and
even then I was told to bugger off).
You sound like a nice bloke, and I don't want to upset anyone, but
please only ask questions when you have tried all other avenues first.
There's loads of help out there (www.cpan.org - www.perldoc.com -
www.google.com etc).
People normally charge good money for the advice they are giving you -
please don't take advantage.
Chris
On Wed, 29 Dec 2004 12:07:38 -0600, Ron Wingfield
<rtwingfield@archaxis.net> wrote:
> Hello everyone,
>
> I'm having difficulty solving this code problem. I can load a popup list of states from a "states" table, but I can't seem to get-it-right when I execute a SHOW, rather than a SELECT query. Actually, I want to create a popup list of all DATABASES through the CGI. From the command line, this works:
>
> mysql> SHOW DATABASES;
> +-----------+
> | Database |
> +-----------+
> | cookbook |
> | test |
> +-----------+
> 2 rows in set (0.00 sec)
>
> As you can see, there are two databases on my server, "cookbook" and "test". I prepare the query request, and execute it without any error complaints. The while/fetchrow_array returns only one iteration or row, . . .apparently the last row which contains the "test" database, and ultimately my popup list only contains the "test" database row. I'm not getting any error from the fetchrow_array function; however I only see one diagnostic display of "GOT HERE! db_name=test". Apparently, the while loop has only looped one time. Regarding the following code, why is "cookbook" missed?
>
> $sth=$dbh->prepare("SHOW DATABASES;");
> $sth->execute( );
> DBI_error("Query execution to SHOW DATABASES failed.","7");
> while($db_name = $sth->fetchrow_array( ))
> {
> DBI_error("Fetchrow_array failed.","7"); # Test/no exit-on-error.
> push(@db_name_values, $db_name); # Save each value in array.
> DBI_error("GOT HERE! db_name=$db_name<br>","1"); #### TEMP!
> # When used with option "1", ----^
> # this always prints a diagnostic "trace" message.
> }
> print # Start of print block
> $cgi-> popup_menu
> (
> -name=>'db_name',
> -values=>\@db_name_values
> ),
>
> Thanks and OTTF,
> Ron Wingfield
>
> FreeBSD 4.8 -- Apache http 2.0.28 -- MySQL client/server 4.1.7
> Perl 5.8.5 -- p5-DBD-mysql-2.9004 driver -- p5-DBI-1.46
>
> --------------------------------------------------------------------------------
>
>
- Next message: Ron Wingfield: "Off Topic: Tsunami"
- Previous message: Cosimo Streppone: "Re: Parallel::ForkManager && DBI memory leak ?"
- In reply to: Ron Wingfield: "Problem with "while/fetchrow_array""
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
