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:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 10:34 AM To: [EMAIL PROTECTED] 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
