[SOLVED] now() function

[ohdang888]

how do i use a now() function???

 

i tried the code below, but i got this error

 

Fatal error: Call to undefined function now()

 

 

what did i do wrong?

 

$now = now();

 

 

[teng84]

now is not PHP function its is MySQL

 

if you want to use that in your query and store in a var you have to put a " or ' around that

$now = 'now()';

[ohdang888]

do i need to put anything in the ()???

[teng84]

do i need to put anything in the ()???

 

what? like i said this is not php function you cant use that in your script or maybe your looking for date function of php eg ..date('m-d-Y')

<a href="http://dev.mysql.com/doc/refman/6.0/en/date-and-time-functions.html#function_now">now </a>is sql func once again

 

 

[KrisNz]

As Teng mentioned, you might be looking for the date function. The php equivalent of now() is 

date("Y-m-d H:i:s");

[teng84]

here's another one dont you think these treads are different?