Displaying timestamp data in a date/time format

Anon

Hi,

I'm a beginner, and I badly need some help. I want to display timestamp data (and other fields) from a record in a friendly way (yyyy-mm--dd hh:mm:ss). It just doesn't work. Can anyone correct my code? I'd appreciate any help, as this is a school work for me and I need to be in a hurry.

Thanks a lot,

Akos, Hungary

<head><title>Hibalista</title></head>
<body bgcolor="white">
<center><h1>Hibalista</h1>
<br>
<table border="3" cellspacing="5" cellpadding="5">

<?
$dbhost = MYHOST ;
$dbuser = MYUSER ;
$db = mysql_connect($dbhost,$dbuser) or die("Hiba a kapcsolódáskor!") ;
$dbname = "gepek" ;
mysql_select_db($dbname,$db) ;
$query = "select sorszam,bejelento_email_cime,date_format(rogzites_ideje,'%Y-%m
date_time,leiras,leltari_szam,hibakod from hiba" ;
$result = mysql_query($query,$db) ;
while ($adat = mysql_fetch_array($result))
{ ?>
<tr><td><? echo $adat["sorszam"] ?></td>
<td><? echo $adat["bejelento_email_cime"] ?></td>
<td><? echo $adat["date_time"] ?></td>
<td><? echo $adat["leiras"] ?></td>
<td><? echo $adat["leltari_szam"] ?></td>
<td><? echo $adat["hibakod"] ?></td>
</tr>
<? } ?>
</table>
<br>
<a href="admin_menu.html">Vissza</a>
</center>
</body>

Anon

What does "It just doesn't work" mean?

There is something spooky about your $query string:

$query = "
select
sorszam,
bejelento_email_cime,
date_format(rogzites_ideje,'%Y-%m
date_time,
leiras,
leltari_szam,
hibakod from hiba
";

An ending ) is missing.

Also, try $adat[3] instead of $adat["date_time"] later in the code.

Anon

There seems to be part of your php code missing.

if you want to select a date_format() item, you must give it a name:

select date_format(field,"format") as Formatted_date FROM table;

Then you can print the value using

print $adat["Formatted_date"];

Anon

Sorry to confuse you, guys! Here is the entire code. It just doesn't work means that I couldn't find a mistake. The error message is the following:

Warning: Supplied argument is not a valid MySQL result resource in /home/davida/public_html/hiba_nez.php on line 17

So what's the problem? What is that supplement error? Is it a syntactic type of error?

Thanks a lot,

Akos, Hungary

<?
$dbhost = MYHOST ;
$dbuser = MYUSER ;
$db = mysql_connect($dbhost,$dbuser) or die("Hiba a kapcsolódáskor!") ;
$dbname = "gepek" ;
mysql_select_db($dbname,$db) ;
$query = "select sorszam,bejelento_email_cime,date_format(rogzites_ideje,'%Y-%m-%d %T') as date_time,leiras,leltari_szam,hibakod from hiba" ;
$result = mysql_query($query,$db) ;
while ($adat = mysql_fetch_array($result))
{ ?>
<tr><td><? echo $adat["sorszam"] ?></td>
<td><? echo $adat["bejelento_email_cime"] ?></td>
<td><? echo $adat["date_time"] ?></td>
<td><? echo $adat["leiras"] ?></td>

<td><? echo $adat["leltari_szam"] ?></td>
<td><? echo $adat["hibakod"] ?></td>
</tr>
<? } ?>
</table>

Anon

Warning: Supplied argument is not a valid MySQL result resource in

means that your sql query is not correct.

You should always include error checking for sql statements!!!
if (!($result = mysql_query($query,$db)))
{
echo mysql_errno().": ".mysql_error()."<BR>";
}
else
{

do what you want.

};

This will tell you allmost exactly what is wrong with your query.

Anon

Thanks a lot Vincent!

You were right. The error message said that the query was denied from the user. I had to changes some privileges and it worked beautifully. Thanks again.

Best regards,

Akos, Hungary