I need help... with DATE coding

AlGale

Hi.

I have scoured the forum for some coding to display the date a certain recordset was updated. I have a tstamp field of type TIMESTAMP, and using coding from another post I have used:

$result = mysql_query("select DATE_FORMAT(date,'%d-%m-%Y') AS mydate from RWelcome");
echo "<table><tr><td>Site Updated: ".$result[mydate]."</td></tr>

I get no errors, but the output is just

Site Updated:

No date comes with it. The TIMESTAMP is working, as I have checked that it is automatically updating whenever a change is made. Any ideas anyone?

Many thanks.

Chris_Evans

$result = "SELECT DATE_FORMAT(date,'%d-%m-%Y') AS mydate FROM RWelcome";
$query = mysql_query($result) or die(mysql_error());
while($row = mysql_fetch_array($result)) {
echo "<table><tr><td>Site Updated: ".$row['mydate']."</td></tr>";
} mysql_free_result($result);

First off, you didn't ask PHP to display mysql_error() which would give you an error if there is a problem with the syntax (I haven't checked the syntax).

Secondly, if you want every row found to echo out the result, you need a while loop as shown.

Chris

yelvington

More specifically:

mysql_query returns a resource, not an array.

A resource is an abstraction that you can regard as an imaginary bucket of results that could contain any number of records, including zero.

In EVERY case, even if there is only one row returned, you must use a "fetch" function, such as mysq_fetch_array, mysql_fetch_object, etc., in order to get at the underlying data.

See the appropriate manual pages for code examples.

AlGale

Chris,

Thanks for the coding. Incidentally, I did get errors with a couple of the lines (forgot which ones, it was late yesterday), but with tweaks it is now working. Thanks.

yelvington,

Thanks for the explanation.

P.S. - how do I mark this as resolved???

Drebin

P.S. - how do I mark this as resolved???

The link to mark it as resolved it at the bottom right under the 'email this page' link,