html text queries to postgres

[Anon]

I am attempting a simple web-based browser for my tables in Postgres. Text is typed into a 'textarea' on the page, and submitted. the result is ok except for when a 'new line' is used ie.

select *
from table

rather than
select * from table

is there a php method of fixing this?
resulting error
Warning: PostgresSQL query failed: ERROR: parser: parse error at or near " "

thanks

[Anon]

I'm using php with mySQL. I haven't seen this problem. What field type do u use for recording "textarea"?

[Anon]

sorry,
the field type, in HTML is areatext, a text box.

I believe the problem actually lies in the way the value is sent to the next page. the get statement looks like

?strSQL=select+*%0D%0Afrom+faculty

rather than
?strSQL=select+*+from+faculty

which works. Is there a way in PHP to parse this out?