> > > > $sql = "INSERT INTO ecomm (ID,part) VALUES ('$sid','$spp')";
> >
> > Another thought:  Are ID and part character data of some sort?  If not
> > 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]

Reply via email to