July 22, 2008 - 10:12am
July 22, 2008 - 10:28am
Ok, I figured it out. For
Ok, I figured it out. For what-ever reason it wouldn't just assign the formatted value to the date element. I manually assigned it and things are working fine now:
CODE
$query = mysql_query("SELECT DATE_FORMAT(date, '%W %M %D %Y') AS cleanDate, name, complaint FROM pix_ar_ ORDER BY id DESC LIMIT 250");
I'm still not sure why it wouldn't work in the first place. That's all valid sql. Maybe this is a host setting?
July 22, 2008 - 11:59am
That's a great question. I
That's a great question. I run into this same problem when working in an Oracle database. The client we use at work does not allow for fields that aren't named. I have to explicitly name it for the query to run. I would love to know why this is if anyone could shed some light on it.
July 28, 2008 - 1:00pm
Hi PaulI can't produce any
Hi Paul
I can't produce any problems (though it is a good idea to give your result columns a nice name /smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> )
Can you try this test code?
CODE
<?php
$dbcon = mysql_connect('localhost', 'user', 'pass');
mysql_select_db ('dbname', $dbcon);
$queryres = mysql_query("SELECT DATE_FORMAT(date, '%W %M %D %Y'), name, complaint FROM pix_ar_ ORDER BY id DESC LIMIT 250", $dbcon);
while ($row = mysql_fetch_array($queryres)) { ?>
<p><?php echo $row['DATE_FORMAT(date, \'%W %M %D %Y\')']; ?></p>
<pre><?php print_r($row); ?></pre>
<?php
} ?>
$dbcon = mysql_connect('localhost', 'user', 'pass');
mysql_select_db ('dbname', $dbcon);
$queryres = mysql_query("SELECT DATE_FORMAT(date, '%W %M %D %Y'), name, complaint FROM pix_ar_ ORDER BY id DESC LIMIT 250", $dbcon);
while ($row = mysql_fetch_array($queryres)) { ?>
<p><?php echo $row['DATE_FORMAT(date, \'%W %M %D %Y\')']; ?></p>
<pre><?php print_r($row); ?></pre>
<?php
} ?>
Does anybody else see an error in my statement here? It's not throwing an error, but at the same time, it's not returning any values. The data is stored in datetime format: '2008-07-21 11:26:34'.
I'm Not Allowed On The Couch