My mistake: I was setting the limit myself via an incorrect column definition whilst creating a temporary table. I feel so stupid. Thanks for trying to help me.
Paul "Kodrik" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > I use mysql_fetch array to retrieve large text data many many times > without a problem. I've actually written functions to retrieve the data for me using this > function, and I never had a single problem, truncated or speed, on Unix, > Linux or Windows platform. > > Check out the code for the functions getrow(), getrows(), they use > mysql_fetch array. > http://zc8.com/zc8/samplecode/sqltools.phps > > This is the explanations of the functions: > http://zc8.net/zc8/shownews.php?articleid=98 > > You can use those as you please if you want > > > On Tue, 30 Jul 2002, Paul Worthington wrote: > > > No I don't have PhpMyAdmin installed. I work directly in MySQL via a > > terminal, so all my checking is with native calls anyway. Working natively > > in MySQL, all my data is there and everything works the way I expect it to. > > Using mysql_fetch_array() in PHP results in a truncated result set. And I am > > trying to figure out why, and how I can work around this problem. > > Thanks again, > > Paul Worthington > > [EMAIL PROTECTED] > > > > "Andrey Hristov" <[EMAIL PROTECTED]> wrote in message > > 01ed01c237ea$0d0fcf10$1601a8c0@nik">news:01ed01c237ea$0d0fcf10$1601a8c0@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]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Tuesday, July 30, 2002 7:53 PM > > > Subject: Re: [PHP-DB] 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 > > > > [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 > > > > > > > > > > > > > > > > > > > -- > > 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
