如何在PHP中运行具有多行的MySQL Query？

Question

How do you run a query like the following in PHP:

INSERT INTO table VALUES ('example name', 'thisisfirstline
           thisissecondline
           thisisthirdline')

I have type set to text.

I have no problems at all when I run it with Navicat. I tried running it in PHP:

mysql_query("INSERT INTO table VALUES ('example name', 'thisisfirstline
           thisissecondline
           thisisthirdline') 
           OR die('ERROR');

This outputs the following:

thisisfirstlinethisissecondlinethisisthirdline

How do I insert the value without sticking it all together?

Answer 1

Put for inserting newline in a MySQL table :

INSERT INTO table VALUES ('example name', 'thisisfirstline

    thisissecondline

    thisisthirdline')