Re: [sqlite] php4/sqlite - sqlite_escape_string doesn't function

[Eric Bohlman]

Peter Jay Salzman wrote:
Hi all,
This piece of code kept giving error messages that looked like some of my
VALUES were getting parsed by php:
    sqlite_query( $handle, "
                INSERT INTO course VALUES (
                                sqlite_escape_string($semester),
                                sqlite_escape_string($course),
                                sqlite_escape_string($course_desc),
                                sqlite_escape_string($college),
                                sqlite_escape_string($reference)
                        )
                ");
You're expecting PHP to interpolate function calls within quoted 
strings.  It doesn't.  See the "Strings" section of Chapter 6 ("Types") 
of the PHP manual.