Jessee Parker wrote: > > I tried doing this on my last run of data but things still got shifted > over by the quotes when I look at the actual data. It's kind of strange, > when I run the same bit of code on some test info, it seems to work fine > (nothing is shifted) but when I run it against a larger set of data, only > the records that contain quotes seem to screw things up.
i don't know what you mean by shifted over by the quote. does it mean everything before(or after) the quote character is chop off? can you paste a sample data of how this shifted over looks like? > > Also, I know this is most likely a stupid question but when you do a > select on the information you just stored, will the quotes mess up things > if you do something like this (this is after setting up the query, > preparing and then executing it) : > > ($field1,$field2,$field3,$field4,$field5) = $sth6->fetchrow; no, it won't mess things up. if you get it into the DB correctly, it will come back out the way you expect it. david -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]