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
[EMAIL PROTECTED]

"Andrey Hristov" <[EMAIL PROTECTED]> wrote 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.
> 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" <[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: 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
> > [EMAIL PROTECTED]
> >
> >
> > --
> > 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
> >
> >
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to