Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
Thanks for all your helpful suggestions. It turns out I was limiting the array myself by setting a temporary table column definition to varchar(255). I have been overlooking it all this time. I feel so stupid. Thanks again for trying to help me. Paul "Paul Burney" <[EMAIL PROTECTED]> wrote in me

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
> From: Paul Worthington [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 30, 2002 10:34 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] mysql_fetch_array limit? - more details > > > I'm running MySQL 3.23.47 and PHP 4.1.2 on Mac OS X 10.1.5. > > In my table, I've

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
in message > > > > 01cd01c237e8$7e1438b0$1601a8c0@nik">news:01cd01c237e8$7e1438b0$1601a8c0@nik... > > > > > Maybe it will help you but I've read that when using persistent > > > > connections > > > > > PHP uses 2 on every request. &

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
lp me. Paul "Mark A. Roedel" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > -Original Message- > From: Paul Worthington [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 30, 2002 9:34 AM > To: [EMAIL PROTECTED] > Subje

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Burney
on 7/30/02 10:34 AM, Paul Worthington at [EMAIL PROTECTED] appended the following bits to my mbox: > I'm using this PHP code, very simple and straightforward, to select two > columns into an array and then display the results in an HTML table: > ...

RE: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Hutchins, Richard
many times have you been nagged for something stupid like forgetting the ; at the end of a query or PHP statement? Just a thought. -Original Message- From: Paul Worthington [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 10:34 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] mysql_fe

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Kodrik
01a8c0@nik... > > Do you have PhpMyAdmin installed? If you have try with it to see the > > results. It uses native mysql functions. > > > > Andrey > > > > - Original Message - > > From: "Paul Worthington" <[EMAIL PROTECTED]> > >

RE: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Roedel, Mark A.
> -Original Message- > From: Paul Worthington [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 30, 2002 9:34 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] mysql_fetch_array limit? - more details > > > What happens is I'm only getting the first 256 characte

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Andrey Hristov
0 seconds. An alternative solution > > would have been to increase the MySQL max_connections parameter from the > > default of 100. > > > > [/snip] > > > > Andrey > > > > - Original Message - > > From: "Rasmus Lerdorf&qu

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Rasmus Lerdorf
: "Rasmus Lerdorf" <[EMAIL PROTECTED]> > To: "Andrey Hristov" <[EMAIL PROTECTED]> > Cc: "Paul Worthington" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Tuesday, July 30, 2002 7:59 PM > Subject: Re: [PHP-DB] mysql_fetch_array limit?

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Andrey Hristov
gt; PHP uses 2 on every request. > > So if in one moment you have 10 scripts,that use persistent connections, > > running you will have 20 connections used to the mysql. > > > > Regards, > > Andrey > > - Original Message ----- > > From: "Paul Worthing

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Rasmus Lerdorf
you will have 20 connections used to the mysql. > > Regards, > Andrey > - Original Message - > From: "Paul Worthington" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, July 30, 2002 5:34 PM > Subject: [PHP-DB] mysql_fetch_array

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
Admin installed? If you have try with it to see the > results. It uses native mysql functions. > > Andrey > > - Original Message - > From: "Paul Worthington" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, July 30, 2002 7:53 PM >

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Andrey Hristov
> - Original Message - > > From: "Paul Worthington" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, July 30, 2002 5:34 PM > > Subject: [PHP-DB] mysql_fetch_array limit? - more details > > > > > > >

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
o if in one moment you have 10 scripts,that use persistent connections, > running you will have 20 connections used to the mysql. > > Regards, > Andrey > - Original Message - > From: "Paul Worthington" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]&g

Re: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Andrey Hristov
"Paul Worthington" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 30, 2002 5:34 PM Subject: [PHP-DB] mysql_fetch_array limit? - more details > I'm running MySQL 3.23.47 and PHP 4.1.2 on Mac OS X 10.1.5. > > In my table, I've got two fields: Nam

[PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Paul Worthington
I'm running MySQL 3.23.47 and PHP 4.1.2 on Mac OS X 10.1.5. In my table, I've got two fields: Name VARCHAR(35) and txtSWDesc1 TEXT. According to the manual, TEXT will give me a maximum space of 65,536 bytes per field. I've entered text in this field in the amount of approximately 500 characters.