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 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]

Reply via email to