insert/display problem

[pouncer]

$Desc = mysql_escape_string($_POST['txt_Description']);

 

thats my description text box, which is what i insert into my sql table

 

say if i enter my description like this:

 

hello, these are my favourite dvd's
!!!!!

 

When i query my database to display it, it gives me:

hello, these are my favourite dvd's!!!!!

the exclamation marks should be on a new line right!???

 

$description = stripslashes($row['description']);

 

thats how im getting it!

 

echo $description;

[New Coder]

Have you tried?

 

$description = $row['description'];

 

What does strip slashes do?

 

If you just want to clean the string up use

 

$description = rtrim($row['description']);

 

Hope this helps, but could be a mile off lol

 

 

 

 

[itsmeArry]

instead of using

 

mysql_escape_string($_POST['txt_Description']);

 

covert the br to new line...

 

like

 

nl2br(mysql_escape_string($_POST['txt_Description']));

[pouncer]

to insert

 

$Desc = nl2br(mysql_escape_string($_POST['txt_Description']));

 

i inserted it

 

but still when i display it, it still not appearing on multiline

(btw when i dislay it, its in a table like

 

<td align=center bgcolor=#F5F5FF>$description</td>

[pouncer]

anyone have any idea?

[kenrbnsn]

Do not apply the nl2br() function when you insert the data into the database, only use it when you're displaying the data. Also you should be using the mysql_real_escape_string() function.

 

One caveat, I have heard that the mysql_real_escape_string() function will convert the newline character "\n" to a plain string '\n' which the nl2br() function will not find. If this causes you problems, use something like this:

<?php
echo '<td align=center bgcolor=#F5F5FF>' . nl2br(str_replace('\n',"\n",$description)) . '</td>';
?>

 

Ken

[itsmeArry]

kenrbnsn

 

here you are jus replacing \n with \n

 

<?php
echo '<td align=center bgcolor=#F5F5FF>' . nl2br(str_replace('\n',"\n",$description)) . '</td>';
?>

 

use this

it will replace '\n' to "\n"

<?php
echo '<td align=center bgcolor=#F5F5FF>' . nl2br(str_replace("'\n'",'"\n"',$description)) . '</td>';
?>