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" <[EMAIL PROTECTED]> wrote in message
1EA7D3AE70ACD511BE6D006097A78C1E022BF618@USROCEXC">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:[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

Reply via email to