[RESOLVED] Another Date conversion question

msimonds

I have a field in my news table that is date_entered

When the news item is entered into the database, it inserts the date into the database with NOW();

$query = "INSERT INTO blog_entries (blog_id, title, entry, date_entered) VALUES (0,'{$_POST['title']}', '{$_POST['entry']}', NOW())";

and when I pull the news/blog entries out of the database it is not showing the date entered:

if ($r = mysql_query ($query))  // Run the query.
                {
                	// Retrieve and print every record.
                	while ($row = mysql_fetch_array ($r))
                    {
                		echo "<p><h3>{$row['title']}</h3>{row['date_entered']}<br />
                		{$row['entry']}<br />
                		</p><hr />\n";
                	}

            }
            else
            { // Query didn't run.
            	die ('<p>Could create the table because: <b>' . mysql_error() . "</b>. The query was $query.</p>");
            } // End of query IF.

I know that this is a simple conversion, but I am having a simple brain F***T

any help would be apprecaited!!! the date format is 2006-08-29 08:29:14

TIA,
Mike

NogDog

echo "<p><h3>{$row['title']}</h3>{[color=red]$[/color]row['date_entered']}<br />

msimonds

Thanks nogDog, but i want to convert the date format!! that is what I am having problems with

I want to show (example) August 29, 2006

msimonds

I tired this:

$query = "SELECT blog_id, title, entry, DATE_FORMAT(date_entered, '%d.%m.%Y')
                          FROM blog_entries ORDER BY date_entered DESC";

but the date does not work!! when I echo out the $row['date_entered'], it is now blank

msimonds

I think I was able to format it correctly. I just want to make sure from others on this forum that this is okay:

while ($row = mysql_fetch_array ($r))
                    {
                        list($id, $title, $entry, $date) = $row;
                        $date = date("F d, Y");
                        $title    = htmlspecialchars($title);
                        $entry = htmlspecialchars($entry);
                        $entry = nl2br($entry);
                        echo "<p><h3>{$title}</h3>{$date}<br />
                		{$entry}<br />
                		</p><hr />\n";
                	}

from the query:

$query = "SELECT blog_id, title, entry, DATE_FORMAT(date_entered, '%d.%m.%Y')
                          FROM blog_entries ORDER BY date_entered DESC";

Installer

DATE_FORMAT(date_entered, '%M %e, %Y') AS formatted_date

msimonds

perfect, Thanks Installer!!!!!!