I have cracked it Andy, by using substr to take apart the 14 digit timestamp 10 04 2004 - 21:23:50 is now showing, and each record is different Thanks anyway, stick around for more questions here is one <td><?php $link = '<a href="' ; $link = $link . $row[2] . '">' ; $link = $link . '</a>' ; echo $link ; ?></td> is not working, I want to output $row[2] as a hyperlink as it is the refering URL, but the above is just showing blank in the output, with no link and no text in the output table
-- www.phpexpert.org/truefaith.htm "True Faith is not just when you believe in God and yourself, it is when others begin to believe in you as well" - Damian John Paul Brown 2004 "Andy Ladouceur" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > And these are UNIX timestamps? Odd. I can't see date giving the wrong > output, could you post the timestamp you're using? > > Thanks > > Andy > > Damian Brown wrote: > > > I have tried that, but it gives a date in the future > > and all records have the same time > > the code is > > > > <td><?php echo date ("l dS of F Y h:i:s A", $row[5]) ; ?></td> > > > > and it gives an output of > > > > Monday 18th of January 2038 10:14:07 PM > > > > I need it to proces the timestamp in the database table so that it shows the > > different times > > Thanks in advance for a solution > > > > > >>The second parameter of PHP's date() function takes a timestamp as an > >>argument, this may be what you're looking for? > >> > >>Andy > >> > >>Damian Brown wrote: > >> > >>>I need to output a date and time that shows more clearly than just > >>>outputting the timestamp > >>> > >>>what is the correct way to go about it ? > >>>I have looked at getdate(), but I haven't fathomed it out yet ! > >>> > >>>-- > >>>www.phpexpert.org/truefaith.htm > >>>"True Faith is not just when you believe in God and yourself, it is when > >>>others begin to believe in you as well" - Damian John Paul Brown 2004 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php