RE: [PHP] strange PHP/MySQL problem
| From: | Wizaerd) | Date: | Sun, 28 Jan 2001 05:03:59 +0000 |
| Subject: | RE: [PHP] strange PHP/MySQL problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-37090@lists.php.net to get a copy of this message | ||
Is it possible that the name field isn't lon enough to contain the full
value so is being truncated whereas the description field is long enough...
Joseph E. Sheble
a.k.a. Wizaerd
Wizaerd's Realm
Canvas, 3D, Graphics,
ColdFusion, PHP, and mySQL
http://www.wizaerd.com
=================================
> -----Original Message-----
> From: PeterOblivion@aol.com [mailto:PeterOblivion@aol.com]
> Sent: Saturday, January 27, 2001 9:06 PM
> To: php-general@lists.php.net
> Subject: [PHP] strange PHP/MySQL problem
>
>
> if you goto
> http://downloads.moddingcentral.com/add.php
> you will see a simple form
>
> this form takes the info and a PHP script processes it and places
> it into a
> mysql table. now the problem
>
> if i put Cynical Saint's Video Tutorial in the name it will display
> Cynical Saint\ in the dbase (also seen @ downloads.moddingcentral.com)
>
> but if you place it in the description it is fine..
>
> here is my sql query
>
> $rst = mysql_query("INSERT INTO tablename(id, game, section, name, size,
> description, dllink, creator, creatoremail, date, website, score,
> downloads)
> VALUES ('$id', '$game', '$section', '$modname',
> '$size', '$description',
> '$dllink', '$creator', '$creatoremail', now(),
> '$website', '0',
> '0') ") or
> die(mysql_error());
>
> Whats wrong with this?
> its driving me nuts!
>
> - Thanks
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>
>