Problem with MySQL String limits?
| From: | Null | Date: | Fri, 22 Jun 2001 10:22:48 +0000 |
| Subject: | Problem with MySQL String limits? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-54395@lists.php.net to get a copy of this message | ||
In a script I have an update query adding on to a LONGTEXT field in my database. Strangely it will
no longer work after seemingly random string lengths. So far, one row stopped adding at 440 bytes
and another at 1049 bytes.
mysql_query("UPDATE dod_news SET Comments='$comments', NumComments=NumComments+1
WHERE Num = $Num");
Num is correct, but strangely it doesn't do ANY of the query when this occurs. I have no idea
why it started doing this but any help would be appreciated.