[PHP-DB] mysql_fetch_array limit? - more details From: Paul Worthington (prw <email protected>)
Date: 07/30/02

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 <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