prepare("SELECT nTitle, date_format(nDate, '%d %M, %Y'), nContent FROM news order by nDate DESC"); // Bind parameters (dont change date -= date is a php function!) $stmt->bind_result($nTitle, $nDate, $nContent); // Execute the statement $stmt->execute(); while ($stmt->fetch()) { echo "

" . $nTitle . "  - (Posted: "; echo $nDate. ")
"; echo $nContent. "

"; } // Close the statement $stmt->close(); ?>