What do you mean it uses 2? It does not.
On Tue, 30 Jul 2002, Andrey Hristov wrote:
> 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
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
