Re: How can this be done?

http://www.php.net/addslashes -jack Subodh Gupta wrote: > > Hi All, > > I created a table using the create command. > > create table trivia > ( > entry_id integer not null auto_increment, > trivia text null > ); > > Now I have a fle tvia.txt, the content of which are as follows: > > The average person's left hand does 56% of the typing. > The longest one-syllable word in the English language is "screeched". > All of the clocks in the movie "Pulp Fiction" are stuck on 4:20. > No word in the English language rhymes with month, orange, silver, or purple. > > I want to insert each line of the file in a new row in the table. > > I wrote the following code for it. > > <?php > include "db.php"; > dbconnect("guestbook2k"); > $fcontents=file("tvia.txt"); > while (list ($line_num, $line) = each ($fcontents)) { > $query="insert into trivia (trivia) values ('$line')"; > $result = mysql_query($query) > or die("Query failed: " > ."<li>errorno=".mysql_errno() > ."<li>error=".mysql_error() > ."<li>query=".$query > ); > echo "<b>Line $line_num:</b> ". $line . "<br>\n"; > } > ?> > > I got the following error. > Query failed: > errorno=1064 > error=You have an error in your SQL syntax near 's left hand does 56% of the typing. > ')' at line 1 > query=insert into trivia (trivia) values ('The average person's left hand does 56% of > the typing. ') > > Now I know that I got the error because there was ( ' ) in the first line. So how do I > prevent this. Or in other words insert into > the table text containing > ( ' ) and ( " ) or for that matter any metacharacter. > > Thank You in Advance. > > Subodh Gupta > I have learned, Joy is not in things, it is in us. > You will ultimately be known by what you give and not what you get. > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net