date() & TIME()

[Anon]

I want to change the format of the date that entering to the DB/
the Tipe at the DB is INT.
with this script the react is 01/01/70
but I want this format d/m/y with the date of to day
can u please correct my script?
i'm tring for about 3 weeks to fo that, but still 01/01/70
thanks - avi

---

the script:

<?
$time=date('d-m-y',time(3600));
mysql_connect("","","")or die(mysql_error());
mysql_select_db("date")or die(mysql_error());
mysql_query("insert into date values('$id','$date')")or die(mysql_error());
$query = mysql_query("select * from date");
while($result=mysql_fetch_array($query))
{
echo($result["id"])."&nbsp;";
echo date('d/m/y',$result["date"])."<br>";
}
?>

[dolce]

Don't really get why you are trying to insert a date into an INT field in the database (if I get you correcly, it is an int field)... and therefore the insert statement most probably simply fails...

try storing the timestamp instead, just store the time() valus in the DB, and format it to your needs after extraction with the date() function 🙂

[Anon]

it doesnt work, i put it into the timestamp' but it the same.
what should i do to extract it to the format 25/11/01 and the date of of to day' can u please correct my script?
thanks

[Anon]

please help me

[johnh]

I am not usually the type to say this, but you need to RTFM. It is very clear on http://www.php.net/. Check out the Time and Date functions that are built in.

You should also consider changing some varaiables. You have your database name as "date" and you have a field in your database with the name of "date", and you are inserting into "date", which seems to be your table name also? That's not quality programming.

Here is what I would do.
<?PHP

$time = time();

mysql_connect("","","")or die(mysql_error());

mysql_select_db("date_database")or die(mysql_error());

mysql_query("insert into date_table values('$id','$time')")or die(mysql_error());

$query = mysql_query("select * from date_table");

while($result=mysql_fetch_array($query))
{
echo($result["id"])." ";
echo date('d/m/y',$result["date_field"])."<br>";
}
?>