subject:"\[PHP\] adding the date to a database"

RE: [PHP] adding the date to a database

2001-07-18 Thread Don Read

On 18-Jul-2001 Brad Wright wrote: > Hi, > I have a database with a 'date' field. What is the syntax for using the > (mysql) function 'getdate()', to insert the date into the DB table. > the syntax I'm currently using is: > $query = "Insert INTO visits (visName, date) > values ('$name

Re: [PHP] adding the date to a database

2001-07-18 Thread Christopher Ostmo

Brad Wright pressed the little lettered thingies in this order... > Hi, > I have a database with a 'date' field. What is the syntax for using the > (mysql) function 'getdate()', to insert the date into the DB table. > the syntax I'm currently using is: > $query = "Insert INTO visits (visName, da

[PHP] adding the date to a database

2001-07-18 Thread Brad Wright

Hi, I have a database with a 'date' field. What is the syntax for using the (mysql) function 'getdate()', to insert the date into the DB table. the syntax I'm currently using is: $query = "Insert INTO visits (visName, date) values ('$name', getdate()) " ; $result = mysql_query($query,