Date Problem Pls help

[Sorrow]

Hi here is my problem. I have a date in my database in the format (2008-11-30) and for each entry that I have in my database when it is displayed on my webpage I need to have it displayed like That (November 30 2008) I have found How to get the format of the date change

SELECT MONTHNAME(TestDate), DAYOFMONTH(TestDate), YEAR(TestDate) FROM Test 

 

But I cant figure out how to use it In this code(it has to be at the release date replacing {$row['NPReldate']}) since each entry are displayed one after the other on the same page

		<?php

include 'opendb.php';

$query  = "SELECT * FROM NowPlaying ORDER BY NPIndex DESC";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
  echo " 	<font face = 'Verdana'><table width='350' border = '0' cellspacing='5'>

<tr>
  <td width = '300' colspan = '2'><center><b>{$row['NPTitle']}</center> </td></tr><tr><br>
  <td rowspan = '5'><a href = '{$row['NPCase']}'><img src='{$row['NPCase']}' width='125' height='200' border = '0' align='top'></a></td>

<td>
<tr><td><b>Director :  </b>{$row['NPDirector']}<br></td></tr>
<tr><td><b>Writers  :  </b>{$row['NPWriters']}<br></td></tr>
<tr><td><b>Production Company :  </b>{$row['NPStudio']}<br></td></tr>
<tr><td><b>Actors   : </b>{$row['NPActors']}<br></td></tr>
<tr><td colspan = '2'><b>Release Date : </b>{$row['NPReldate']}<br></td></tr>
</td>
</tr>
<tr>
<td width ='300' colspan='2' align='justify'> Plot : ";
echo nl2br($row['NPPlot']);
echo "</td></tr><tr><td></td></tr>
</table><br><br><br></font>


";
}
mysql_close($con);

?>

 

Anyone has any Idea pls Thank you in advance

[crochk]

I could be missing something, but why don't you just put it into your database in the correct format.

[xtopolis]

Use DATE_FORMAT(column,'%format %format') (etc) , instead.

 

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format

 

should be DATE_FORMAT(TestDate,'%M %e %Y')

 

 

 

fyi, his column is in the 'correct' format.

[Sorrow]

Ok thank you I get that but how do I use this with the current query that I have so I could get the date displayed with the rest of the infos??

[xtopolis]

Don't SELECT *

 

Do

SELECT columnname, columnname, etc, etc, DATE_FORMAT(NPReldate,'%M %e %Y') FROM ... etc

 

That's afaik.  * shouldn't be used unless you really are selecting all columns from the database.  And I don't know how you would SELECT * and append a format to one of the columns.

 

Everything else should be fine as is.

[Sorrow]

Ok i got this to work but in my code

<tr><td colspan = '2'><b>Release Date : </b>{$row['NPReldate']}<br></td></tr>

 

But What do I replace {$row['NPReldate']} with because I tried {$row['NPReldate']} and  DATE_FORMAT( NPRelDate, ' %M %D %Y' ) also and it is not working

[xtopolis]

Make it

DATE_FORMAT( NPRelDate, ' %M %D %Y' ) AS 'NPRelDate'

 

(sorry, I thought you would know to do that)

[Sorrow]

thank you I used to know it but I havent programmed for a couple of years lol thank you man