line break in mySql

is it possible to add sql string entry with line breaks?
ive tried the expression \n but it didnt work when parsing with php

Yes, but it depends on the format.

For example:
$line = "\n";
mysql_query('......'.$line.'.....');

That would work.

Also, you can just add a line break in the query:
mysql_query('one
two');

If you still have trouble, you'll need to post some code so we can help.

i didnt know you can add an actual line break in the query!
thanks

MySQL is a full programming language, though often it is used through a language like PHP.

If you want to see an example of lots of MySQL code, with comments and many line breaks, just look at the backup from a database (such as generated from phpmyadmin).

Glad to hear it works.

yes you can and the syntax is correct that is given by the earlier post