Re: Storing HTML in a DB field...

In article <004c01c30dc8$c7d59730$2900a8c0@homegroup>, jvilla@isdesigndev.com says... > I know I have seen this before, but can't remember and am hard pressed > for time. > > I have an app which wrote a bunch of HTML (tables, style definitions, > etc) to a file and then it was displayed later. Well now, instead of > saving it to a file, I want to store it in MySQL. It keeps failing. Do > I need to do anything special before I insert it? > > Right now, my query looks like this: > > $sql = "INSERT INTO orders SET user_id = ".$_POST['user_id'].", order > = > '".$WRITE_TO_FILE."'"; > > Where WRITE_TO_FILE is a var which has all the data via > > $WRITE_TO_FILE .= "blah blah"; > $WRITE_TO_FILE .= "blah blah"; > $WRITE_TO_FILE .= "blah blah"; > $WRITE_TO_FILE .= "blah blah"; You might find it helpful to use mysql_error() after your insert to see if the database returns a useful error message. Also, try echoing your completed query to see if you can spot a syntax error. -- Quod subigo farinam $email =~ s/oz$/au/o;