date_format()

[RON_ron]

Can someone tell me what is the fault with my code?

 

SELECT date_format(datecolumn,'%d %M %Y') as date FROM news WHERE article_id=$id

 

$query = "SELECT * FROM  my_db ORDER BY timestamp DESC";

$results = mysql_query($query);

 

$returnS="";

while($line = mysql_fetch_array($results))

{

$returnS.= $line["subject"].",,".$line["$id"].",,".$line["article"].",,".$line["link"].",,,";

}

echo $returnS;

mysql_close($link);

?>

[wildteen88]

Can someone tell me what is the fault with my code?

Umm, not really. Why what is wrong? Post what you're trying to do and any errors you're getting.

[litebearer]

perhaps you are only getting the date info (per your query) AND not displaying it (per your $returnS)

[RON_ron]

Here's what I want to happen.  The mysql date to be in this format %d %M %Y and be in $returnS