[SOLVED] MySQL Query & Functions

[shane18]

How can you put a function into a SQL line correctly?

 

$sql = "SELECT e_mails FROM mail_useage WHERE date=date("Y-m-d", TIME() - 18000)";

 

Would the code above work? If not, why not?

[alexdemers]

How can you put a function into a SQL line correctly?

 

$sql = "SELECT e_mails FROM mail_useage WHERE date=date("Y-m-d", TIME() - 18000)";

 

Would the code above work? If not, why not?

 

Use concatenation:

 

$sql = "SELECT e_mails FROM mail_useage WHERE date=".(date("Y-m-d", TIME() - 18000));

[shane18]

What if I do:

 

$sql = mysql_query("SELECT e_mails FROM mail_useage WHERE date=date("Y-m-d", TIME() - 18000)");

 

Now how do I do it?

[shane18]

hello... is what i asked above possible?