Welcome Guest, Not a member yet? Register   Sign In
MYSQL select date format query
#1

[eluser]learning_php[/eluser]
Hi,

I have a database with a table called news which contains a id, date, news colums i can get the database to print to the screen witht the following:

<?PHP
sql = "select news, date FROM news";
$Q = $this->db->query($sql);
?>

<?PHP foreach ($Q->result() as $row):?>
<h1>&lt;?=$row->date?&gt;</h1>
<h1>&lt;?=$row->news?&gt;</h1>
<hr />
&lt;?PHP endforeach;?&gt;

but the date is in the format YYYYMMDD can anyone help me rewite the select statement to read DDMMYYYY?

Thanks


Messages In This Thread
MYSQL select date format query - by El Forum - 04-20-2009, 08:06 AM
MYSQL select date format query - by El Forum - 04-20-2009, 08:12 AM
MYSQL select date format query - by El Forum - 04-20-2009, 08:16 AM
MYSQL select date format query - by El Forum - 04-20-2009, 08:20 AM
MYSQL select date format query - by El Forum - 04-20-2009, 08:20 AM
MYSQL select date format query - by El Forum - 04-20-2009, 08:29 AM
MYSQL select date format query - by El Forum - 04-20-2009, 08:48 AM
MYSQL select date format query - by El Forum - 04-20-2009, 08:50 AM



Theme © iAndrew 2016 - Forum software by © MyBB