RE: Problem with while/fetchrow_array

2005-01-01 Thread Graeme St. Clair
' connecting locally and user 'fred' connecting from a remote location. Rgds, GStC. -Original Message- From: Ron Wingfield [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 29, 2004 1:08 PM To: dbi-users@perl.org Subject: Problem with while/fetchrow_array Hello everyone, I'm having difficulty

Problem with while/fetchrow_array

2004-12-29 Thread Ron Wingfield
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

Re: Problem with while/fetchrow_array

2004-12-29 Thread Hardy Merrill
Ron, someone else will correct me if I'm wrong, but long ago this bit me also. I believe I remember the answer being that SHOW is a mysql client command - that is not a valid SQL command. I'm not sure if mysql has a mysql-only sql command you can give to get the names of the databases - or

RE: Problem with while/fetchrow_array

2004-12-29 Thread Graeme St. Clair
:[EMAIL PROTECTED] Sent: Wednesday, December 29, 2004 1:08 PM To: dbi-users@perl.org Subject: Problem with while/fetchrow_array 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

Re: Problem with while/fetchrow_array

2004-12-29 Thread Ron Wingfield
- From: Hardy Merrill To: [EMAIL PROTECTED] ; dbi-users@perl.org Sent: Wednesday, December 29, 2004 12:23 PM Subject: Re: Problem with while/fetchrow_array Ron, someone else will correct me if I'm wrong, but long ago this bit me also. I believe I remember the answer being that SHOW

Re: Problem with while/fetchrow_array

2004-12-29 Thread Chris Denman (Protext)
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