I realise that CC Zona answered this question earlier but I haven't
understood.
I have attempted to use the date_format in generating the query
variable and applying the result with a while loop to display the date
data in an html table as dd-mmm-
Generating the query variable
include
"boclair" [EMAIL PROTECTED] wrote in message
000e01c0b5d0$720921c0$[EMAIL PROTECTED]">news:000e01c0b5d0$720921c0$[EMAIL PROTECTED]...
| I realise that CC Zona answered this question earlier but I haven't
| understood.
|
| I have attempted to use the date_format in generating the query
| variable
It has been pointed out to me that there is an error. I had failed to
include the two date fields in the select. The actual scripting is.
The query
include ("inputs/connect.php");
|$plantavail = mysql_query("SELECT * date_format(online,'%d-%b-%Y') AS
logon,
date_format(offline,'%d-%b-%Y') )