Hi,

  how can we use function now(), it is used for current date.
Actually i want to add the current date in the query like this.
"insert into info id=8,date=".now()."name=name";

Now() is an MySQL function, NOT a PHP function...

NOW() Returns the current date and time as a value in 'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS format, depending on whether the function is used in a string or numeric context.

Try:
"INSERT INTO info ( id, date, name ) VALUES ( 8, NOW(), name );";


Links of interest:
    Date and Time Functions: http://dev.mysql.com/doc/refman/5.0/...functions.html
    PHP: date - Manual: http://www.php.net/date
    SQL Insert Into: http://www.w3schools.com/sql/sql_insert.asp

- A.Kahtava

This is also possible, using now()...

mysql> desc birth;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| uid | int(11) | YES | | NULL | |
| uname | varchar(30) | YES | | NULL | |
| bdate | date | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
3 rows in set (0.03 sec)

mysql> insert into birth values
    -> (0,'z',now());
Query OK, 1 row affected (0.08 sec)

mysql> select * from birth where uid=0;
+------+-------+------------+
| uid | uname | bdate |
+------+-------+------------+
| 0 | z | 2006-03-30 |
+------+-------+------------+
1 row in set (0.05 sec)

Regards
Milind