Re: mysql_fetch_array limit? - more details

Thank you for that idea. I don't think that's it, though, because this script is the only one I'm ever running on this site. The problem is perfectly consistent and repeatable, which leads me to believe it's something in the way the array is being built. Paul Worthington prw@evolving.com "Andrey Hristov" <ahristov@icygen.com> wrote in message 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. > 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 Worthington" <prw@evolving.com> > To: <php-db@lists.php.net> > 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: 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. > > > > 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: > > > ............................................................................ > > .................................. > > $db = mysql_connect("localhost", "user1"); > > mysql_select_db("testdb",$db); > > $sql = "SELECT * FROM tmp ORDER BY Name"; > > $result = mysql_query($sql,$db); > > > > echo "<TABLE>\n"; > > echo "<TR>\n<TH>Place > > Name</TH>\n<TH>Description</TH>\n</TR>\n"; > > while ($myrow = mysql_fetch_array($result)) { > > > > printf("<TR><TD>%s</TD><TD>%s</TD></TR>\n", > > $myrow[Name], > > $myrow[txtSWDesc1]); > > } > > echo "</TABLE>\n"; > > > ............................................................................ > > ............................... > > What happens is I'm only getting the first 256 characters of txtSWDesc1 > > displayed in my table. I am assuming the problem is in > > mysql_fetch_array(), that it must have some size limitation that > > truncates whatever data it has read to exactly 256 chars. Another > > possibility is that the mysql_query() could be truncing the result. I've > > checked my data directly in MySQL, and all the characters are there in > > direct SELECTs. > > > > Can someone please help? I've checked all manuals and FAQs I can, but I > > can't figure out why I'm having this problem. It should not be happening > > at all. Is there some size limitation to the array created via > > mysql_fetch_array()? Is there some other function that will accomodate > > my data? Is there any custom code to handle my data correctly? > > > > Thanks, > > Paul Worthington > > paulworthington@mac.com > > > > > > -- > > The views expressed here are those of the user, not necessarily those of > > Evolving Systems, Inc. > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > >