Timestamp issue with MySQL

[ralf11]

I am trying to get the date printed in a html output, which is pulled from mysql db. With my current code, the date result comes out blank, no errors or anything (but everything else works). I'm fairly new to this so dont flame me if its a simple mistake. I havent been able to find a solution in any documentation or other help threads. Heres the code.

function showThenews() {

$timestamp = dbQuery("SELECT DATE_FORMAT(timestamp,'%W, %D, %M, %Y') FROM Thenews AS timestamp"); 

$ThenewsQuery=dbQuery("SELECT * FROM Thenews ORDER BY id DESC");

while ($Thenews = mysql_fetch_array($ThenewsQuery)) {

?>
<table border="0" width="100%">
<tr>
<td width="100%">
<p align="center"><?=$Thenews[title]?> - <? echo $timestamp[timestamp] ?></td>
</tr>
<tr>
<td width="100%"><?=$Thenews[text]?>
</td>
</tr>
</table>
<br>
<?

}

}

[Anon]

As you have an expression in your query, the column will not have a name unless you use an alias, i.e.

$timestamp = dbQuery("SELECT DATE_FORMAT(timestamp,'%W, %D, %M, %Y') as timestamp FROM Thenews AS timestamp");

[ralf11]

Tried that fix. Still have the same problem, nothing is outputted.

And if it counts for anything, I ran "SELECT DATE_FORMAT(timestamp,'%W, %D, %M, %Y') as timestamp FROM Thenews AS timestamp" with phpMyAdmin, and it worked Giving me a valid response. Its just getting it into the html which is troubling.

[Anon]

I spotted another problem.
You need to fetch the value as well. $timestamp is just the handle.

Why do you have two queries? It should be sufficient with one

function showThenews() {

$ThenewsQuery=dbQuery("SELECT title,news,DATE_FORMAT(timestamp,'%W, %D, %M, %Y') as timestamp FROM Thenews ORDER BY id DESC");
while ($Thenews = mysql_fetch_array($ThenewsQuery)) {

?>
<table border="0" width="100%">
<tr>
<td width="100%">
<p align="center"><?=$Thenews[title]?> - <? echo $TheNews[timestamp] ?></td>
</tr>
<tr>
<td width="100%"><?=$Thenews[text]?>
</td>
</tr>
</table>
<br>
<?

}

}