Re: [PHP] Problem with MySQL String limits?

[David Robley]

On Fri, 22 Jun 2001 19:52, Null wrote:
> 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.


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 

Echh, Outhouse does odd things :-)

Try adding echo mysql_error() after you call the query and see what sort 
of error is returned.

-- 
David Robley  Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES  Flinders University, SOUTH AUSTRALIA  

   "My stereo's half-fixed," said Tom monotonously.

[PHP] Problem with MySQL String limits?

[Null]

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.