current date

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
irealms
Forum Contributor
Posts: 215
Joined: Mon Apr 28, 2003 7:10 am
Location: Leeds

current date

Post by irealms »

i have an insert query and one the variables i want to end is the current date, how would i do this?
User avatar
DuFF
Forum Contributor
Posts: 495
Joined: Tue Jun 24, 2003 7:49 pm
Location: USA

Post by DuFF »

If the field is the date type then using the PHP function NOW() will work fine.
User avatar
irealms
Forum Contributor
Posts: 215
Joined: Mon Apr 28, 2003 7:10 am
Location: Leeds

Post by irealms »

so my query would be?

$newuploadquery = "INSERT INTO groups (groupname,username,dateadded,uploadedfile) VALUES ('$_SESSION[groupname],'$_SESSION[valid_user]','NOW()'";
User avatar
DuFF
Forum Contributor
Posts: 495
Joined: Tue Jun 24, 2003 7:49 pm
Location: USA

Post by DuFF »

Delete the quotes around NOW(). Example of mine that works:

query = "INSERT INTO files VALUES ('','$file','$category','0','0','0',NOW(),'$review')";
User avatar
irealms
Forum Contributor
Posts: 215
Joined: Mon Apr 28, 2003 7:10 am
Location: Leeds

Post by irealms »

still getting error with

$newuploadquery = "INSERT INTO uploads (groupname,username,dateadded,uploadedfile) VALUES ('$_SESSION[groupname],'$_SESSION[valid_user]',NOW(),'$file_name')";

now error is :

query [INSERT INTO uploads (groupname,username,dateadded,uploadedfile) VALUES ('admin,'osmadmin-ryan',NOW(),'corgonsblade.jpg')] failed: You have an error in your SQL syntax near 'osmadmin-ryan',NOW(),'corgonsblade.jpg')' at line 1
User avatar
irealms
Forum Contributor
Posts: 215
Joined: Mon Apr 28, 2003 7:10 am
Location: Leeds

Post by irealms »

when i tried:

$currentdate = NOW();
$newuploadquery = "INSERT INTO uploads (groupname,username,dateadded,uploadedfile) VALUES ('$_SESSION[groupname],'$_SESSION[valid_user]','$currentdate','$file_name')";

i got an undefined function error
User avatar
irealms
Forum Contributor
Posts: 215
Joined: Mon Apr 28, 2003 7:10 am
Location: Leeds

Post by irealms »

also tried using

$currentdate = date("Y-d-m");

which seems to show the right date but i'm getting a syntax error
User avatar
irealms
Forum Contributor
Posts: 215
Joined: Mon Apr 28, 2003 7:10 am
Location: Leeds

Post by irealms »

woot it works, was missing a '
Post Reply