hi adrianyong wherever in query u pass the text field.. just put it in the function str_replace() function and replace all (") with (\").. simple.... isn't it...?? bye, Gaurav Rustogi --- Adrianyong <h_tere2000@xxxxxxxxx> wrote: > Hi everyone, > > I would like to ask, if you guys ever > encountered a update or insert for problem for text > data. You see i tried to INSERT or UPDATE an entire > article. Turns out there are errors. I think most > notably syntax errors. > > Might be because in the text data/article might have > contain (") quotations , single or double. Hence, > this messes up the mysql query. > > So I'm trying to write a messy prosedural hardcoded > patch for that in my php. > > But in the meantime i'm asking -- is a better and > more elegant way, any ideas guys? > > > > --------------------------------- > New Yahoo! Messenger with Voice. Call regular phones > from your PC for low, low rates. > > [Non-text portions of this message have been > removed] > > > > PHP Data object relational mapping generator > http://www.metastorage.net/ > Yahoo! Groups Links > > > php-objects-unsubscribe@xxxxxxxxxxxxxxx > > > > > > ___________________________________________________________ Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com PHP Data object relational mapping generator http://www.metastorage.net/ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-objects/ <*> To unsubscribe from this group, send an email to: php-objects-unsubscribe@xxxxxxxxxxxxxxx <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/