Hi,
I have the following query :
for($i = 0; $i <=$num_results; $i++)
{
$row = mysql_fetch_object($result);
echo "<table width =\"100%\" border =\"0\" cellpadding = \"3\">\n"
."<tr>\n"
."<td bgcolor = \"#eeeeee\" align = \"left\">$row->id</td>\n"
."<td bgcolor = \"#eeeeee\" align = \"left\">$row->Nombre</td>\n"
."<td bgcolor = \"#eeeeee\" align = \"left\">$row->Apellido</td>\n"
."<td bgcolor = \"#eeeeee\" align = \"left\">$row->Direccion</td>\n"
."<td bgcolor = \"#eeeeee\" align = \"left\">$row->Ciudad</td>\n"
."<td bgcolor = \"#eeeeee\" align = \"left\">$row->Telefono</td>\n"
."<td bgcolor = \"#eeeeee\" align = \"left\">$row->Mail</td>\n"
."<td bgcolor = \"#eeeeee\" align = \"left\">$row->Pais</td>\n"
."<td bgcolor = \"#eeeeee\" align = \"left\">".date("r",
$row->date)."<td>\n"
// My problem is it's getting the wrong date no matter what I do, every line
displays Jan 2038 !!!
."</tr>\n"
."</table>\n";
If I try another strings i got errors the row $date is in MYSQL unix
timestamp. and i would like to format it.
BTW I would like a better alignment and format also ...
TIA
Regards,
Rick
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
