MYSQL empty field in PHP

[phppaper]

Hello,

 

I have a empty field of MYSQL and would like to write it with PHP but I dont know how, please help, example:

 

$SQL = "SELECT * FROM table where field = ??? ";

 

"???" is empty field, what should I fill in?

 

Thanks

[mikefrederick]

are you trying to insert something into the database? if so, :

mysql_query("insert into tablename (field1,field2) values ('value1','value2')");

[xProteuSx]

Are you trying to write to a table, or are you trying to read from a table?  The SELECT option is used to read from a table.  If you answer this question, someone will be able to help you.

[phppaper]

I just want to know what represents am empty MySQL field in PHP language and that was just an example ^^

 

Is it "" or '' or NULL??

[Nuv]

Thats field has a name?

[phppaper]

lets say the field name is "time"

[l0ve2hat3]

this should work if mysql field isn't NULL

 

$sql= "SELECT * FROM table WHERE field='' ";

 

if it is do this:

$sql= "SELECT * FROM table WHERE field='NULL' ";

[phppaper]

Thanks!!