Still problem with mysql_real_escape_string

[robert_gsfame]

I have this

mysql_query(sprintf("UPDATE TABLE1 SET photo=NULL WHERE username='%s'",

mysql_real_escape_string($session)));

 

then i didnt find NULL value inside the photo column, only blank

 

???really confused

 

 

 

 

[greatstar00]

NULL is blank, the ascii value of 0 (not a printable character, printable character is from 32 to 126, inclusive), anything beyond 128, is used for the purpose of other language

if u want it to be the text NULL

do this

UPDATE TABLE1 SET photo="NULL" WHERE username='%s

 

Another thing, depends what software u using, they might have different way of displaying NULL (the ascii 0)

some display NULL (with some background color), like the mysql official GUI tool