Re: insert into mysql
| From: | Tom Carter | Date: | Sun, 28 Jan 2001 13:45:24 +0000 |
| Subject: | Re: insert into mysql | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-6232@lists.php.net to get a copy of this message | ||
On Thu, 25 Jan 2001, Darryl Friesen wrote:
>
>
> > It still didn't work.
> > just says unable to add part
>
> > > $sql = "INSERT INTO ecomm (ID,part) VALUES
> > > ('$sid','$spp')";
>
> Another thought: Are ID and part character data of some sort? If not (i.e.
> if ID is an int) then remove the single quotes.
>
A trivial point this, but if you insert values in ' into a mysql int
column then MySQl still treats it as intended. THey aren' necessary for
int columns, but it is acceptable to have them there
-Tom >
> - Darryl
>
> ----------------------------------------------------------------------
> Darryl Friesen, B.Sc., Programmer/Analyst Darryl.Friesen@usask.ca
> Education & Research Technology Services,
> http://gollum.usask.ca/
> Department of Computing Services,
> University of Saskatchewan
> ----------------------------------------------------------------------
> "Go not to the Elves for counsel, for they will say both no and yes"
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>