line break in mySql

[ggalan]

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

[djr33]

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.

[ggalan]

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

[djr33]

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.

[alex28]

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