php date_format help

[sm00nie]

Hey all 🙂

Does anyone know how I can show the date (code below) with the corresponding article (article_id column, on the same news table) ?

As of now, it shows all the article dates, instead of just the one date thats associated with the article.

---

$sql_date = mysql_query("SELECT date_format(datecolumn, '%M %D, %Y') as date FROM news") or die (mysql_error());

while(list($date)=mysql_fetch_row($sql_date)){
echo "$date";

}

Thanks 🙂

[Weedpacket]

Don't see anything to do with dates, and everything about SQL.
SELECT date_format(datecolumn, '%M %D, %Y') as date FROM news WHERE article_id=$id

where $id is the article_id you're interested in.

For more aobut MySQL SQL, there's always it's manual.

[Mordecai]

My, my, Weedpacket, it's not like you to use the incorrect form of "its!" 😛