HI,
assign another para. and set it up like this
$somepara. = addslashes($line);
than "insert into trivia(trivia) values ('$line');
that will work
Kelvin.
"Jack Dempsey" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]