Re: 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 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"