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.

Reply via email to