How to insert the date ...

nomad9

... into a field DATE in a mysql db. ???

I want to put the actual date for further research in the db.

But i don't know how ???

cgraz

NOW()

INSERT INTO your_table (date_field) VALUES(NOW())

Cgraz

nomad9

oh ... just that 🙂

thank

Steve

nomad9

another question : can we just get the value of the current month ???

I've got a tracking system and i want that when a user click on a link (ex. home), it add a click to the value of the appropriate month (ex. 04) where StatsName equal home.

thank

enterume

with PHP is :

date("m")

with mysql:

DAYOFMONTH(now())

nomad9

i've got an error and i don't know where :

//Variable
$statsClick = "Stats"date("m")";

//Update Stats
$sql = "UPDATE Stats SET '".$statsClick."'='".$statsClick."'+1 WHERE StatsName = '".$link."'";
$result = mysql_query($sql,$db) or die(mysql_error()); 

... my field is named Stats04

and this is the message error :

Parse error: parse error, unexpected T_STRING in /home/www/cabanons.com/v2/php/tracker.php on line 7

enterume

try this :

//Variable
$statsClick = "Stats".date("m");

//Update Stats
$sql = "UPDATE Stats SET ".$statsClick."=(".$statsClick."+1) WHERE StatsName = '".$link."'";
$result = mysql_query($sql,$db) or die(mysql_error()); 

... my field is named Stats04

nomad9

ok here's what i've got now enterume

The script look like it work but the nothing is updated in my db ???

enterume

try to echo your $sql after it execute, so you can check whether the WHERE clause is correct.

Assume you have update permission to execute it.

nomad9

cool now it's working 😃

thank for the trick : with echo, we can see if our statement are good, most of the time it's just a syntax error.

Now I can go sleep :o

Thank again

Steve