----- Original Message ----- From: "david" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 02, 2002 10:15 AM Subject: Re: Insertion and Quotes
> 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] Unfortunately I already deleted the left over info in the table but I can give you an example of what is happening. Say you have the following 5 fields: ID: 1 FirstName: Jessee "Jess" Parker Date: 10/02/2002 Email: [EMAIL PROTECTED] Status: here So what happens after doing the insertion using placeholders, the information in the table would look like this: ID: 1 FirstName: Jessee Date: Jess Email: Parker Status: [EMAIL PROTECTED] The quotes throw off the insertion into the MySQL table. I'm using placeholders (?) when building the SQL statement and when I perform the execute I am filling in the blanks so to speak. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
