I found the problem. I didn't give myself write access to the database   :}

----- Original Message -----
From: "Darryl Friesen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 29, 2001 8:32 AM
Subject: Re: [PHP-DB] insert into mysql


> > > > > $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
>
> Thanks for pointing that out Tom.  That's a good bit of info to tuck away
> for later.
>
> We've been using MSSQL Server 7 here quite a bit lately, and it isn't
nearly
> as forgiving.  :(
>
> - Darryl
>
>  ----------------------------------------------------------------------
>   Darryl Friesen, B.Sc., Programmer/Analyst    [EMAIL PROTECTED]
>   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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to