What is this??

[robert_gsfame]

i have textarea and when i try to insert it into my database, i found this "Â "

i am not sure what cause that   appeared in my database

 

can give me a clue??

[TGWSE_GY]

are you striping slashes?

[robert_gsfame]

what do u mean striping slashes??

i just insert this

 

"Text :B " then everything mess up

when inserting the record i use get_magic_quotes as i use mysql_real_escape_string

but i've done all my best and still get the same result :'(

[robert_gsfame]

i still couldn't find the answer for this

below is the code

function clean($string) {

    if(get_magic_quotes_gpc()) {

        return stripslashes($string);

    }else{

    return $string;

    }

}

$message=$_POST['message']

$insertquery=mysql_query(sprintf("INSERT INTO table(message)VALUES('%s')",

mysql_real_escape_string($message)));

 

and the result i got is this : Hello My name is :B        * italic one is emoticon tag

[Pikachu2000]

I don't see where you are actually passing the value of $_POST['message'] to the clean() function. Is that done elsewhere in the script?

[kenrbnsn]

Are you actually typing in a double quote " or are you cutting/pasting from a Microsoft product like Word? Microsoft Word has things called "Smart Quotes" which will appear like that if you try to display them on a web page.

 

Ken