[Resolved] date functions

OwenTheSamoan

I'm confused as hell when it comes to date fuctions. I am using a field in my table "join_date" in which I collect the date of when a member joins. I use this function to insert the info now() I have been trying different ways to pull up the info and print it out with the day of the month and the month in an abbreviated version, but I can't seem to get it right. What am I doing wrong? Thanks in advance for any help.

$query = "SELECT dayname(postdate), dayofmonth(postdate), monthname(postdate), year(postdate) from table";

$day = ($dayname(postdate));
$month = ($monthname(postdate));
$date = ($dayofmonth(postdate));
$year = ($year(postdate));

echo (date("D. M d. , Y"));

drew010

try this:

<?php
//...

$query = "SELECT UNIX_TIMESTAMP(postdate) FROM table WHERE something";

$res = mysql_query($query);

$date = mysql_fetch_row($res);

echo date("D. M d. , Y", $date[0]);

?>

of course you need to change the where clause, check that the query was successful and then use date.

OwenTheSamoan

Thanks, but when I ty it I get this----

mysql_fetch_row(): supplied argument is not a valid MySQL result resource

planetsim

DId you change the query he gave you? More than likely its because of the query

$res = mysql_query($query)or die(mysql_error());

Will give you the reason why.

OwenTheSamoan

Yes I did change it, but it still didn't work

TheDefender

... and what was the error given to you by the code planetsim gave you?

OwenTheSamoan

It was the same exact error message even after I made the change

TheDefender

Ok, so what is your exact code? Also if you echo $query, what does it echo out? That may be a good place to look to figuring this out.

OwenTheSamoan

ok, when I just echo "query" I get the select statement that I was using. When I echo "result" I get nothing. I am using "datetime" for the type of field in my table. does that help? I appreciate this. thanks

OwenTheSamoan

I have to apologize, it works perfectly. I spelled one of the fields incorrectly, but it works fine. Thank you to everyone that has helped!