Showing a MYSQL - non-database result

overtoner

Ok, I'm going nuts looking for this answer, and it seems simple enough. I just want to display the result of a MYSQL command in php. Such as the following:

select FROM_UNIXTIME(985150800);

I'm trying to set a variable to be equal to that result. All php - mysql relations I have have found always contain a database call.

Thanks,
Jamie

junebug

well, it makes sense that if you trying to run a mysql command, you would send a call to the database. is there some reason you are using this way to get the date. why not use date()?

http://www.php.net/date

Anon

OK, I figured it out. I was just having trouble converting the MYSQL timestamp into a readable format. Just took me awhile to process the solution, here's what I came up with - hope it helps others.

<?
//display datetime from mysql format

function mysql_timestamp_to_time($dates)
{
return mktime( intval(substr($dates,8,2)), intval(substr($dates,10,2)) , intval(substr($dates,12,2)), intval(substr($dates,4,2)), intval(substr($dates,6,2)), intval(substr($dates,0,4)) );
}

$link = mysql_result($result,$i,"link");
$release_date = mysql_result($result,$i,"release_date");

$new_release_date = mysql_timestamp_to_time($release_date);

PRINT "".date("F jS, Y",$DDD)." <a href=\"pressreleases.php3?qs1=$unique_id\">$link</a>";
?>

Result:
July 19th, 2001
Press Release Title shows up here

Jamie