Re: mysql_fetch_array limit? - more details

Problem solved. I was stupidly overlooking an incorrect column definition in a temporary table. Everything's fine now. Thank you so much for trying to help me, and please excuse my errors. Paul "Richard Hutchins" <Richard.Hutchins@GetingeCastle.com> wrote in message news:1EA7D3AE70ACD511BE6D006097A78C1E022BF618@USROCEXC... > One thing I haven't seen yet is a cut-n-paste of your db tables. Could you > post that to this list? Maybe there's something you're overlooking there? > Maybe seomebody will find something amiss there. > > I know it sounds simple and you might think you have it all down right, but > how 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:prw@evolving.com] > Sent: Tuesday, July 30, 2002 10:34 AM > To: php-db@lists.php.net > 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