Re: Problem with MySQL String limits?
| From: | David Robley | Date: | Wed, 20 Jun 2001 08:41:36 +0000 |
| Subject: | Re: Problem with MySQL String limits? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-54482@lists.php.net to get a copy of this message | ||
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.