[RESOLVED] help regarding date echo

kingdm

Good day,

Can someone assist me regarding this problem.

The problem is I want to echo the date on my database.

In my registration I used the CURDATE() to insert the current date into the database specifically table date_membered.

Everything is fine, the date_membered contains the current date in this format (2009-12-23).

Now I want to print it in this format (December 23, 2009), how can I do this? Thanks a lot.

Merry Christmas.

dagon

date_format()

kingdm

thanks for the reply dagon, but it seems I don't understand where to use the date_format().

kingdm

What seems to be the problem here in my script :

include 'db_connect.php';

$sql_user = mysql_query("SELECT DATE_FORMAT(date_membered,   '%M %e %Y') AS FormatTime FROM users WHERE id = '".$_SESSION['id']."'");
$result=mysql_query($sql_user);

$getdate = mysql_fetch_array($result);
$date_membered = $getdate['FormatTime'];

echo $date_membered;

I get this error :
Warning: mysql_query() expects parameter 1 to be string, resource given in C:\xampp\htdocs\pamscorp\my_application.php on line 6

Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in C:\xampp\htdocs\pamscorp\my_application.php on line 8

Rodders

See my response in your other thread.

kingdm

That would be my lesson of the day Thanks Rodders.

After doing this, the warning is now gone. Thanks buddy. I got the same input from NogDog on another forums I posted.

Seems like I need to learn a lot of basics, anyway thanks. Really appreciated your input. Finally got rid of this warning.

Merry Christmas amigo.