<!-- postbiit Array
(
    [postid] => 34773
    [threadid] => 13013
    [parentid] => 0
    [username] => 
    [userid] => 
    [title] => Re: Help needed for TimeStamp conversion between  MySQL and PHP
    [dateline] => 1057520642
    [pagetext] => On Sun, 06 Jul 2003 19:17:58 GMT, "Steven" <xueming@comcast.net> wrote:
[quote]
>TimeStamp in MySQL is unix timestamp like YYYYMMDDHHMMSS or shorter depend
>on the size, but the timestamp for PHP would be the total seconds from
>1/1/1970( or something like it).
>
>Any easy function to convert them ?[/quote]

[url]http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_functions[/url]

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) ([url]http://www.andyh.co.uk[/url])
Space: disk usage analysis tool ([url]http://www.andyhsoftware.co.uk/space[/url])

    [allowsmilie] => 1
    [showsignature] => 0
    [ipaddress] => 
    [iconid] => 0
    [visible] => 1
    [attach] => 0
    [infraction] => 0
    [reportthreadid] => 0
    [isusenetpost] => 1
    [msgid] => <iuuggvok6nmmt4bammv3dsv7u2qgtjnkdb@4ax.com>
    [ref] => <GB_Na.51191$926.6117@sccrnsc03>
    [htmlstate] => on_nl2br
    [postusername] => Andy Hassall
    [ip] => andy@andyh.co.u
    [isdeleted] => 0
    [usergroupid] => 
    [membergroupids] => 
    [displaygroupid] => 
    [password] => 
    [passworddate] => 
    [email] => 
    [styleid] => 
    [parentemail] => 
    [homepage] => 
    [icq] => 
    [aim] => 
    [yahoo] => 
    [msn] => 
    [skype] => 
    [showvbcode] => 
    [showbirthday] => 
    [usertitle] => 
    [customtitle] => 
    [joindate] => 
    [daysprune] => 
    [lastvisit] => 
    [lastactivity] => 
    [lastpost] => 
    [lastpostid] => 
    [posts] => 
    [reputation] => 
    [reputationlevelid] => 
    [timezoneoffset] => 
    [pmpopup] => 
    [avatarid] => 
    [avatarrevision] => 
    [profilepicrevision] => 
    [sigpicrevision] => 
    [options] => 
    [akvbghsfs_optionsfield] => 
    [birthday] => 
    [birthday_search] => 
    [maxposts] => 
    [startofweek] => 
    [referrerid] => 
    [languageid] => 
    [emailstamp] => 
    [threadedmode] => 
    [autosubscribe] => 
    [pmtotal] => 
    [pmunread] => 
    [salt] => 
    [ipoints] => 
    [infractions] => 
    [warnings] => 
    [infractiongroupids] => 
    [infractiongroupid] => 
    [adminoptions] => 
    [profilevisits] => 
    [friendcount] => 
    [friendreqcount] => 
    [vmunreadcount] => 
    [vmmoderatedcount] => 
    [socgroupinvitecount] => 
    [socgroupreqcount] => 
    [pcunreadcount] => 
    [pcmoderatedcount] => 
    [gmmoderatedcount] => 
    [assetposthash] => 
    [fbuserid] => 
    [fbjoindate] => 
    [fbname] => 
    [logintype] => 
    [fbaccesstoken] => 
    [newrepcount] => 
    [vbseo_likes_in] => 
    [vbseo_likes_out] => 
    [vbseo_likes_unread] => 
    [temp] => 
    [field1] => 
    [field2] => 
    [field3] => 
    [field4] => 
    [field5] => 
    [subfolders] => 
    [pmfolders] => 
    [buddylist] => 
    [ignorelist] => 
    [signature] => 
    [searchprefs] => 
    [rank] => 
    [icontitle] => 
    [iconpath] => 
    [avatarpath] => 
    [hascustomavatar] => 0
    [avatardateline] => 
    [avwidth] => 
    [avheight] => 
    [edit_userid] => 
    [edit_username] => 
    [edit_dateline] => 
    [edit_reason] => 
    [hashistory] => 
    [pagetext_html] => 
    [hasimages] => 
    [signatureparsed] => 
    [sighasimages] => 
    [sigpic] => 
    [sigpicdateline] => 
    [sigpicwidth] => 
    [sigpicheight] => 
    [postcount] => 1
    [islastshown] => 
    [isfirstshown] => 1
    [attachments] => 
    [allattachments] => 
)
 --><!-- postbiit Array
(
    [postid] => 34777
    [threadid] => 13013
    [parentid] => 34773
    [username] => 
    [userid] => 
    [title] => Re: Help needed for TimeStamp conversion between  MySQL and PHP
    [dateline] => 1057524605
    [pagetext] => "Steven" <xueming@comcast.net> wrote in message
news:GB_Na.51191$926.6117@sccrnsc03...[quote]
> TimeStamp in MySQL is unix timestamp like YYYYMMDDHHMMSS or shorter depend
> on the size, but the timestamp for PHP would be the total seconds from
> 1/1/1970( or something like it).
>
> Any easy function to convert them ?
>
> Regards,
> -Steven
>[/quote]

afaik a unix timestamp IS the number of seconds since 01/01/1970.

in a mysql query you can use FROM_UNIXTIME(unix timestamp here) and
UNIX_TIMESTAMP(mysql date column here)


    [allowsmilie] => 1
    [showsignature] => 0
    [ipaddress] => 
    [iconid] => 0
    [visible] => 1
    [attach] => 0
    [infraction] => 0
    [reportthreadid] => 0
    [isusenetpost] => 1
    [msgid] => <6Y%Na.169$_v6.7@news-binary.blueyonder.co.uk>
    [ref] => <GB_Na.51191$926.6117@sccrnsc03>
    [htmlstate] => on_nl2br
    [postusername] => Ev0
    [ip] => griffo64@hotmai
    [isdeleted] => 0
    [usergroupid] => 
    [membergroupids] => 
    [displaygroupid] => 
    [password] => 
    [passworddate] => 
    [email] => 
    [styleid] => 
    [parentemail] => 
    [homepage] => 
    [icq] => 
    [aim] => 
    [yahoo] => 
    [msn] => 
    [skype] => 
    [showvbcode] => 
    [showbirthday] => 
    [usertitle] => 
    [customtitle] => 
    [joindate] => 
    [daysprune] => 
    [lastvisit] => 
    [lastactivity] => 
    [lastpost] => 
    [lastpostid] => 
    [posts] => 
    [reputation] => 
    [reputationlevelid] => 
    [timezoneoffset] => 
    [pmpopup] => 
    [avatarid] => 
    [avatarrevision] => 
    [profilepicrevision] => 
    [sigpicrevision] => 
    [options] => 
    [akvbghsfs_optionsfield] => 
    [birthday] => 
    [birthday_search] => 
    [maxposts] => 
    [startofweek] => 
    [referrerid] => 
    [languageid] => 
    [emailstamp] => 
    [threadedmode] => 
    [autosubscribe] => 
    [pmtotal] => 
    [pmunread] => 
    [salt] => 
    [ipoints] => 
    [infractions] => 
    [warnings] => 
    [infractiongroupids] => 
    [infractiongroupid] => 
    [adminoptions] => 
    [profilevisits] => 
    [friendcount] => 
    [friendreqcount] => 
    [vmunreadcount] => 
    [vmmoderatedcount] => 
    [socgroupinvitecount] => 
    [socgroupreqcount] => 
    [pcunreadcount] => 
    [pcmoderatedcount] => 
    [gmmoderatedcount] => 
    [assetposthash] => 
    [fbuserid] => 
    [fbjoindate] => 
    [fbname] => 
    [logintype] => 
    [fbaccesstoken] => 
    [newrepcount] => 
    [vbseo_likes_in] => 
    [vbseo_likes_out] => 
    [vbseo_likes_unread] => 
    [temp] => 
    [field1] => 
    [field2] => 
    [field3] => 
    [field4] => 
    [field5] => 
    [subfolders] => 
    [pmfolders] => 
    [buddylist] => 
    [ignorelist] => 
    [signature] => 
    [searchprefs] => 
    [rank] => 
    [icontitle] => 
    [iconpath] => 
    [avatarpath] => 
    [hascustomavatar] => 0
    [avatardateline] => 
    [avwidth] => 
    [avheight] => 
    [edit_userid] => 
    [edit_username] => 
    [edit_dateline] => 
    [edit_reason] => 
    [hashistory] => 
    [pagetext_html] => 
    [hasimages] => 
    [signatureparsed] => 
    [sighasimages] => 
    [sigpic] => 
    [sigpicdateline] => 
    [sigpicwidth] => 
    [sigpicheight] => 
    [postcount] => 2
    [islastshown] => 1
    [isfirstshown] => 
    [attachments] => 
    [allattachments] => 
)
 --><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en" id="vbulletin_html"> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" /> <meta id="e_vb_meta_bburl" name="vb_meta_bburl" content="http://www.justskins.com/forums" /> <meta name="generator" content="vBulletin 4.2.2" /> <link rel="Shortcut Icon" href="http://www.justskins.com/forums/favicon.ico" type="image/x-icon" /> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/yui/2.9.0/build/yuiloader-dom-event/yuiloader-dom-event.js"></script> <script type="text/javascript"> <!--
	if (typeof YAHOO === 'undefined') // Load ALL YUI Local
	{
		document.write('<script type="text/javascript" src="clientscript/yui/yuiloader-dom-event/yuiloader-dom-event.js?v=422"><\/script>');
		document.write('<script type="text/javascript" src="clientscript/yui/connection/connection-min.js?v=422"><\/script>');
		var yuipath = 'clientscript/yui';
		var yuicombopath = '';
		var remoteyui = false;
	}
	else	// Load Rest of YUI remotely (where possible)
	{
		var yuipath = 'http://ajax.googleapis.com/ajax/libs/yui/2.9.0/build';
		var yuicombopath = '';
		var remoteyui = true;
		if (!yuicombopath)
		{
			document.write('<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/yui/2.9.0/build/connection/connection-min.js"><\/script>');
		}
	}
	var SESSIONURL = "s=b0826ca1c8c10dd90a12ba2c9827a82a&";
	var SECURITYTOKEN = "guest";
	var IMGDIR_MISC = "images/metro/blue/misc";
	var IMGDIR_BUTTON = "images/metro/blue/buttons";
	var vb_disable_ajax = parseInt("0", 10);
	var SIMPLEVERSION = "422";
	var BBURL = "http://www.justskins.com/forums";
	var LOGGEDIN = 0 > 0 ? true : false;
	var THIS_SCRIPT = "showthread";
	var RELPATH = "showthread.php?t=13013";
	var PATHS = {
		forum : "",
		cms   : "",
		blog  : ""
	};
	var AJAXBASEURL = "http://www.justskins.com/forums/";
// --> </script> <script type="text/javascript" src="http://www.justskins.com/forums/clientscript/vbulletin-core.js?v=422"></script> <link rel="stylesheet" type="text/css" href="clientscript/vbulletin_css/style00023l/main-rollup.css?d=1419360199" /> <!--[if lt IE 8]> <link rel="stylesheet" type="text/css" href="clientscript/vbulletin_css/style00023l/popupmenu-ie.css?d=1419360199" /> <link rel="stylesheet" type="text/css" href="clientscript/vbulletin_css/style00023l/vbulletin-ie.css?d=1419360199" /> <link rel="stylesheet" type="text/css" href="clientscript/vbulletin_css/style00023l/vbulletin-chrome-ie.css?d=1419360199" /> <link rel="stylesheet" type="text/css" href="clientscript/vbulletin_css/style00023l/vbulletin-formcontrols-ie.css?d=1419360199" /> <link rel="stylesheet" type="text/css" href="clientscript/vbulletin_css/style00023l/editor-ie.css?d=1419360199" /> <![endif]-->  <link href='http://fonts.googleapis.com/css?family=Open+Sans:400,300,600&subset=latin,cyrillic' rel='stylesheet' type='text/css'> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.4/jquery.min.js"></script> <script type="text/javascript">
$(document).ready(function() {
	$('a.login-window').click(function() {
		
		// Getting the variable's value from a link 
		var loginBox = $(this).attr('href');

		//Fade in the Popup and add close button
		$(loginBox).fadeIn(300);
		
		//Set the center alignment padding + border
		var popMargTop = ($(loginBox).height() + 24) / 2; 
		var popMargLeft = ($(loginBox).width() + 24) / 2; 
		
		$(loginBox).css({ 
			'margin-top' : -popMargTop,
			'margin-left' : -popMargLeft
		});
		
		// Add the mask to body
		$('body').append('<div id="mask"></div>');
		$('#mask').fadeIn(300);
		
		return false;
	});
	
	// When clicking on the button close or the mask layer the popup closed
	$('a.close, #mask').live('click', function() { 
	  $('#mask , .login-popup').fadeOut(300 , function() {
		$('#mask').remove();  
	}); 
	return false;
	});
	
	$('#navbar_username').focus(function() {
		$('#navbar_username').parent().addClass('active');
	}); 
	$('#navbar_username').blur(function() {
		$('#navbar_username').parent().removeClass('active');
	}); 
	$('#navbar_password').focus(function() {
		$('#navbar_password_hint').parent().addClass('active');
	}); 
	$('#navbar_password').blur(function() {
		$('#navbar_password_hint').parent().removeClass('active');
	}); 

});
</script> <meta name="keywords" content="H,timestamp, mysql, convert, function, easy, 1/1/1970, hassall, usage, disk, analysis, tool, http://www.andyhsoftware.co.uk/space, space, http://www.andyh.co.uk, andy, seconds, andy@andyh.co.uk, icq5747695, http://www.mysql.com/documentation/mysql/bychapter/manual_reference.htmldate_and_time_functions, size, 2003, 191758, needed, conversion, steven, wrote, depend, shorter, unix, yyyymmddhhmmss, total" /> <meta name="description" content="On Sun, 06 Jul 2003 19:17:58 GMT, &quot;Steven&quot; &lt;xuemingcomcast.net&gt; wrote: 
 
 
http://www.mysql.com/doentation/mysql/bychapter/manual_Reference.html#Date_and_time_functions 
 
-- 
Andy Hassall (andyandyh.co.uk) icq(5747695) (http://www.andyh.co.uk) 
Space: disk usage ysis tool (http://www.andyhsoftware.co.uk/space)" /> <title>Help needed for TimeStamp conversion between  MySQL and PHP - PHP Development</title> <link rel="canonical" href="http://www.justskins.com/forums/help-needed-for-timestamp-13013.html" /> <link rel="stylesheet" type="text/css" href="clientscript/vbulletin_css/style00023l/showthread-rollup.css?d=1419360199" /> <!--[if lt IE 8]><link rel="stylesheet" type="text/css" href="clientscript/vbulletin_css/style00023l/toolsmenu-ie.css?d=1419360199" /> <link rel="stylesheet" type="text/css" href="clientscript/vbulletin_css/style00023l/postlist-ie.css?d=1419360199" /> <link rel="stylesheet" type="text/css" href="clientscript/vbulletin_css/style00023l/showthread-ie.css?d=1419360199" /> <link rel="stylesheet" type="text/css" href="clientscript/vbulletin_css/style00023l/postbit-ie.css?d=1419360199" /> <link rel="stylesheet" type="text/css" href="clientscript/vbulletin_css/style00023l/poll-ie.css?d=1419360199" /><![endif]--> <link rel="stylesheet" type="text/css" href="clientscript/vbulletin_css/style00023l/additional.css?d=1419360199" /> <script type="text/javascript" src="vbseo/resources/scripts/vbseo_ui.js?v=a4"></script> <script type="text/javascript">
 YAHOO.util.Event.onDOMReady(function (){
 	vbseoui = new vBSEO_UI();
 	vbseoui.page_init(Array('postbody','blogbit','content','postcontainer','vbseo_like_postbit'), Array("php",1));
 });
</script> 
<script type="text/javascript"><!--
window.google_analytics_uacct = 'UA-519075-5'; var _gaq = _gaq || []; _gaq.push(['_setAccount', 'UA-519075-5'], ['_trackPageview'], ['_trackPageLoadTime']); (function() { var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);  })();
//--></script>
</head> <body> <script type="text/javascript">
(function(){
  var bsa = document.createElement('script');
     bsa.type = 'text/javascript';
     bsa.async = true;
     bsa.src = 'http://s3.buysellads.com/ac/bsa.js';
  (document.getElementsByTagName('head')[0]||document.getElementsByTagName('body')[0]).appendChild(bsa);
})();
</script> <div class="x-navbar"> <div class="x-navbar-inner x-container-fluid max width"> <a href="http://www.justskins.com/" class="x-brand img" title="Professional Web Applications Themes"><img src="http://www.justskins.com/press/wp-content/uploads/2014/05/justskins_logo_small.png" alt="Professional Web Applications Themes"></a> <nav class="x-nav-collapse collapse" role="navigation"> <ul id="menu-navigation" class="x-nav sf-menu sf-js-enabled"> <li id="menu-item-2360" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-home menu-item-2360"><a href="http://www.justskins.com/">Home</a></li> <li id="menu-item-2362" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-2362"><a href="http://www.justskins.com/skins">Services</a></li> <li id="menu-item-2362" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-2362"><a href="http://www.justskins.com/forums/">Forums</a></li> <li id="menu-item-2356" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2356"><a href="http://www.justskins.com/advertise">Advertise</a></li> <li id="menu-item-2357" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2357"><a href="http://www.justskins.com/contact">Contact</a></li> </ul> </nav>  </div>  </div> <div class="above_body">  <div id="header" class="floatcontainer doc_header"> <div id="top_header"> <div id="globalsearch" class="globalsearch"> <form action="http://www.justskins.com/forums/search.php?do=process" method="post" id="navbar_search" class="navbar_search"> <input type="hidden" name="securitytoken" value="guest" /> <input type="hidden" name="do" value="process" /> <input type="text" value="" name="query" class="textbox" tabindex="99"/> <input type="submit" class="searchbutton" name="submit" onclick="document.getElementById('navbar_search').submit;" tabindex="100"/> </form> </div> <div id="toplinks" class="toplinks"> <ul class="nouser"> <li>or</li> <li><a href="#login-box" class="login-window">Login</a></li> </ul> </div> </div> <div id="login-box" class="login-popup"> <a href="#" class="close"><img src="images/metro/blue/misc/close_popup.png" class="close-button" title="Close" alt="Close" /></a> <div id="login-text">Login to Your Account</div> <script type="text/javascript" src="clientscript/vbulletin_md5.js?v=422"></script> <form id="navbar_loginform" action="http://www.justskins.com/forums/login.php?do=login" method="post" onsubmit="md5hash(vb_login_password, vb_login_md5password, vb_login_md5password_utf, 0)"> <fieldset id="logindetails" class="logindetails"> <div> <div class="navbar_username_outer"><input type="text" class="textbox default-value" name="vb_login_username" id="navbar_username" size="10" accesskey="u" tabindex="101" value="User Name" /></div> <div class="navbar_password_outer"><input type="password" class="textbox" tabindex="102" name="vb_login_password" id="navbar_password" size="10" /> <input type="text" class="textbox default-value" tabindex="102" name="vb_login_password_hint" id="navbar_password_hint" size="10" value="Password" style="display:none;" /></div> <div class="login-ctrl"> <div id="remember" class="remember"> <label for="cb_cookieuser_navbar"><input type="checkbox" name="cookieuser" value="1" id="cb_cookieuser_navbar" class="cb_cookieuser_navbar" accesskey="c" tabindex="103" /> Remember Me?</label> </div> <input type="submit" class="loginbutton" tabindex="104" value="Log in" title="Enter your username and password in the boxes provided to login, or click the 'register' button to create a profile for yourself." accesskey="s" /> </div> </div> </fieldset> <input type="hidden" name="s" value="b0826ca1c8c10dd90a12ba2c9827a82a" /> <input type="hidden" name="securitytoken" value="guest" /> <input type="hidden" name="do" value="login" /> <input type="hidden" name="vb_login_md5password" /> <input type="hidden" name="vb_login_md5password_utf" /> </form> <script type="text/javascript">
			YAHOO.util.Dom.setStyle('navbar_password_hint', "display", "inline");
			YAHOO.util.Dom.setStyle('navbar_password', "display", "none");
			vB_XHTML_Ready.subscribe(function()
			{
			//
				YAHOO.util.Event.on('navbar_username', "focus", navbar_username_focus);
				YAHOO.util.Event.on('navbar_username', "blur", navbar_username_blur);
				YAHOO.util.Event.on('navbar_password_hint', "focus", navbar_password_hint);
				YAHOO.util.Event.on('navbar_password', "blur", navbar_password);
			});
			
			function navbar_username_focus(e)
			{
			//
				var textbox = YAHOO.util.Event.getTarget(e);
				if (textbox.value == 'User Name')
				{
				//
					textbox.value='';
					textbox.style.color='#000000';
				}
			}

			function navbar_username_blur(e)
			{
			//
				var textbox = YAHOO.util.Event.getTarget(e);
				if (textbox.value == '')
				{
				//
					textbox.value='User Name';
					textbox.style.color='#777777';
				}
			}
			
			function navbar_password_hint(e)
			{
			//
				var textbox = YAHOO.util.Event.getTarget(e);
				
				YAHOO.util.Dom.setStyle('navbar_password_hint', "display", "none");
				YAHOO.util.Dom.setStyle('navbar_password', "display", "inline");
				YAHOO.util.Dom.get('navbar_password').focus();
			}

			function navbar_password(e)
			{
			//
				var textbox = YAHOO.util.Event.getTarget(e);
				
				if (textbox.value == '')
				{
					YAHOO.util.Dom.setStyle('navbar_password_hint', "display", "inline");
					YAHOO.util.Dom.setStyle('navbar_password', "display", "none");
				}
			}
			</script> <div class="register-ctrl"> <a class="login-popup-register" href="http://www.justskins.com/forums/register.php" rel="nofollow">Register</a> <div class="login-popup-fb"> </div> </div> </div> <div id="breadcrumb" class="breadcrumb"> <ul class="floatcontainer"> <li class="navbithome"><a href="http://www.justskins.com/forums/" accesskey="1"><img src="images/metro/blue/misc/navbit-home.png" alt="Home" /></a></li> <li class="navbit"><a href="http://www.justskins.com/forums/">Forum</a></li> <li class="navbit"><a onclick="_gaq.push(['_trackEvent', 'Outgoing', '', 'forumdisplay.php']);" href="http://www.justskins.com/forums/#archives">Archives</a></li> <li class="navbit"><a href="http://www.justskins.com/forums/web-design-and-development-62/">Web Design and Development</a></li> <li class="navbit"><a href="http://www.justskins.com/forums/web-programming-languages-63/">Web Programming Languages</a></li> <li class="navbit"><a href="http://www.justskins.com/forums/php-development-76/">PHP Development</a></li> <li class="navbit lastnavbit"><span> Help needed for TimeStamp conversion between  MySQL and PHP</span></li> </ul> <hr /> </div> </div> </div> <div class="body_wrapper"> <div class="body_main"> <div id="ad_global_below_navbar"><div id="bsap_1258473" class="bsarocks bsap_a198964463e16954450796897d84d582" style="margin: 0 auto; width: 750px;"></div></div> <div id="pagetitle" class="pagetitle"> <!-- google_ad_section_start --><h1><span class="threadtitle"><a href="#">Help needed for TimeStamp conversion between  MySQL and PHP - PHP Development</a></span></h1> <p><em>On Sun, 06 Jul 2003 19:17:58 GMT, &quot;Steven&quot; &lt;xuemingcomcast.net&gt; wrote: 
 
	 
				&gt;TimeStamp in MySQL is unix timestamp like YYYYMMDDHHMMSS or shorter depend 
&gt;on the size, but the timestamp for PHP would be the total seconds from 
&gt;1/1/1970( or something like it). 
&gt; 
&gt;Any easy function to convert them ?
			
		 
 [url]http://www.mysql.com/doentation/mysql/bychapter/manual_Reference.html#Date_and_time_functions[/url] 
 
-- 
Andy Hassall (andyandyh.co.uk) icq(5747695) ([url]http://www.andyh.co.uk[/url]) 
Space: disk usage ysis tool ([url]http://www.andyhsoftware.co.uk/space[/url])...</em></p><!-- google_ad_section_end -->  <script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>  <ins class="adsbygoogle"
		     style="display:inline-block;width:850px;height:300px"
		     data-ad-client="ca-pub-9643598651838321"
		     data-ad-slot="7708719949"></ins> <script>
		(adsbygoogle = window.adsbygoogle || []).push({});
		</script> </div> <div id="thread_controls" class="thread_controls toolsmenu"> <div> <ul id="postlist_popups" class="postlist_popups popupgroup"> <li class="popupmenu" id="threadtools"> <h6><a class="popupctrl" href="javascript://">Thread Tools</a></h6> <ul class="popupbody popuphover"> <li><a href="http://www.justskins.com/forums/help-needed-for-timestamp-13013-print.html" accesskey="3" rel="nofollow">Show Printable Version</a></li> <li><a href="http://www.justskins.com/forums/sendmessage.php?do=sendtofriend&amp;t=13013" rel="nofollow">Email this Page&hellip;</a></li> <li> <a href="http://www.justskins.com/forums/subscription.php?do=addsubscription&amp;t=13013" rel="nofollow">Subscribe to this Thread&hellip;</a> </li> </ul> </li> <li class="popupmenu" id="displaymodes"> <h6><a class="popupctrl" href="javascript://">Display</a></h6> <ul class="popupbody popuphover"> <li><label>Linear Mode</label></li> <li><a rel="nofollow" href="http://www.justskins.com/forums/help-needed-for-timestamp-13013.html?mode=hybrid"> Switch to Hybrid Mode</a></li> <li><a rel="nofollow" href="http://www.justskins.com/forums/help-needed-for-timestamp-13013.html?mode=threaded#post34773"> Switch to Threaded Mode</a></li> </ul> </li> </ul> </div> </div> <div id="postlist" class="postlist restrain"> <ol id="posts" class="posts" start="1"> <li class="postbit postbitim postcontainer old" id="post_34773"> <div class="postdetails_noavatar"> <div class="posthead"> <span class="postdate old"> <span class="date">July 6th,&nbsp;<span class="time">07:44 PM</span></span> </span> <span class="nodecontrols"> <a name="post34773" href="http://www.justskins.com/forums/help-needed-for-timestamp-13013.html#post34773" class="postcounter">#1</a><a id="postcount34773" name="1"></a> </span> </div> </div> <div class="postbody"> <div class="postrow"> <h2 class="posttitle icon"> <img src="images/icons/icon1.png" alt="Default" /> <!-- google_ad_section_start -->Re: Help needed for TimeStamp conversion between  MySQL and PHP<!-- google_ad_section_end --> </h2> <div class="content hasad"> <div id="post_message_34773"> <blockquote class="postcontent restore"> <!-- google_ad_section_start -->On Sun, 06 Jul 2003 19:17:58 GMT, &quot;Steven&quot; &lt;xuemingcomcast.net&gt; wrote:<br /> <div class="bbcode_container"> <div class="bbcode_quote"> <div class="quote_container"> <div class="bbcode_quote_container"></div>
			
				&gt;TimeStamp in MySQL is unix timestamp like YYYYMMDDHHMMSS or shorter depend<br />
&gt;on the size, but the timestamp for PHP would be the total seconds from<br />
&gt;1/1/1970( or something like it).<br />
&gt;<br />
&gt;Any easy function to convert them ?
			
		</div> </div> </div>[url]http://www.mysql.com/doentation/mysql/bychapter/manual_Reference.html#Date_and_time_functions[/url]<br /> <br />
--<br />
Andy Hassall (andyandyh.co.uk) icq(5747695) ([url]http://www.andyh.co.uk[/url])<br />
Space: disk usage ysis tool ([url]http://www.andyhsoftware.co.uk/space[/url])<br /> <!-- google_ad_section_end --> </blockquote> </div> </div> <div id="ad_thread_first_post_content"><script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>  <ins class="adsbygoogle"
     style="display:inline-block;width:336px;height:280px"
     data-ad-client="ca-pub-9643598651838321"
     data-ad-slot="8438717148"></ins> <script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div> <div class="vbseo_buttons" id="lkbtn_1.13013.34773"> <div class="vbseo_liked" style="display:none"></div> </div> </div> </div> <div class="userinfo_noavatar"> <div class="contact"> <div class="username_container"> <span class="username guest"><!-- google_ad_section_start(weight=ignore) -->Andy Hassall<!-- google_ad_section_end --></span> <span class="usertitle">
						Guest
					</span> </div> </div> </div> <div class="postfoot"> <div class="textcontrols floatcontainer"> <span class="postcontrols"> <img style="display:none" id="progress_34773" src="images/metro/blue/misc/progress.gif" alt="" /> </span> <span class="postlinking"> </span> </div> </div> <hr /> </li> <li class="postbit postbitim postcontainer old" id="post_34777"> <div class="postdetails_noavatar"> <div class="posthead"> <span class="postdate old"> <span class="date">July 6th,&nbsp;<span class="time">08:50 PM</span></span> </span> <span class="nodecontrols"> <a name="post34777" href="http://www.justskins.com/forums/help-needed-for-timestamp-13013.html#post34777" class="postcounter">#2</a><a id="postcount34777" name="2"></a> </span> </div> </div> <div class="postbody"> <div class="postrow"> <h2 class="posttitle icon"> <img src="images/icons/icon1.png" alt="Default" /> <!-- google_ad_section_start -->Re: Help needed for TimeStamp conversion between  MySQL and PHP<!-- google_ad_section_end --> </h2> <div class="content"> <div id="post_message_34777"> <blockquote class="postcontent restore"> <!-- google_ad_section_start -->&quot;Steven&quot; &lt;xuemingcomcast.net&gt; wrote in message<br />
news:GB_Na.51191$926.6117sccrnsc03...<div class="bbcode_container"> <div class="bbcode_quote"> <div class="quote_container"> <div class="bbcode_quote_container"></div>
			
				&gt; TimeStamp in MySQL is unix timestamp like YYYYMMDDHHMMSS or shorter depend<br />
&gt; on the size, but the timestamp for PHP would be the total seconds from<br />
&gt; 1/1/1970( or something like it).<br />
&gt;<br />
&gt; Any easy function to convert them ?<br />
&gt;<br />
&gt; Regards,<br />
&gt; -Steven<br />
&gt;
			
		</div> </div> </div>afaik a unix timestamp IS the number of seconds since 01/01/1970.<br /> <br />
in a mysql query you can use FROM_UNIXTIME(unix timestamp here) and<br />
UNIX_TIMESTAMP(mysql date column here)<br /> <br /> <br /> <!-- google_ad_section_end --> </blockquote> </div> </div> <script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>  <ins class="adsbygoogle"
					     style="display:inline-block;width:336px;height:280px"
					     data-ad-client="ca-pub-9643598651838321"
					     data-ad-slot="8704225541"></ins> <script>
					(adsbygoogle = window.adsbygoogle || []).push({});
					</script> <div class="vbseo_buttons" id="lkbtn_1.13013.34777"> <div class="vbseo_liked" style="display:none"></div> </div> </div> </div> <div class="userinfo_noavatar"> <div class="contact"> <div class="username_container"> <span class="username guest"><!-- google_ad_section_start(weight=ignore) -->Ev0<!-- google_ad_section_end --></span> <span class="usertitle">
						Guest
					</span> </div> </div> </div> <div class="postfoot"> <div class="textcontrols floatcontainer"> <span class="postcontrols"> <img style="display:none" id="progress_34777" src="images/metro/blue/misc/progress.gif" alt="" /> </span> <span class="postlinking"> </span> </div> </div> <hr /> </li> </ol> <div class="separator"></div> <div class="postlistfoot"> </div> </div> <div id="below_postlist" class="noinlinemod below_postlist"> <div id="pagination_bottom" class="pagination_bottom"> </div> </div>  <div class="navlinks"> <strong>&laquo;</strong> <a href="http://www.justskins.com/forums/regexp-problems-13011.html">RegExp problems.</a>
			
			 | 
			
				<a href="http://www.justskins.com/forums/securing-the-sequence-of-13016.html">Securing the sequence of pages</a> <strong>&raquo;</strong> </div>  <div id="thread_info" class="thread_info block"> <div id="similar_threads"> <h4 class="threadinfohead blockhead">Similar Threads</h4> <div id="similar_threads_list" class="thread_info_block blockbody formcontrols"> <ol class="similar_threads"> <li class="floatcontainer"> <div class="titleblock"> <h6><a href="http://www.justskins.com/forums/translating-mysql-timestamp-to-107495.html" title="Hi All, 
 
Any thoughts on the easiest way to translate a MySQL timestamp (which looks 
like 20040422090941) to the datetime format (which looks like...">Translating MySQL timestamp to datetime</a></h6> <div class="starter_forum">
       By Joshua Beall in forum PHP Development
    </div> </div> <div class="dateblock"> <span class="shade">Replies:</span> 1
      <div class="starter_forum"> <span class="shade">Last Post:</span> April 22nd, <span class="time">02:50 PM</span> </div> </div> </li><li class="floatcontainer"> <div class="titleblock"> <h6><a href="http://www.justskins.com/forums/mysql-date-to-timestamp-146804.html" title="I would like to use php to query a database and retrieve a unix timestamp. 
 
The problem is that mysql is storing the data in the date format and...">mysql date to timestamp</a></h6> <div class="starter_forum">
       By Ben in forum PHP Development
    </div> </div> <div class="dateblock"> <span class="shade">Replies:</span> 2
      <div class="starter_forum"> <span class="shade">Last Post:</span> December 8th, <span class="time">05:22 PM</span> </div> </div> </li><li class="floatcontainer"> <div class="titleblock"> <h6><a href="http://www.justskins.com/forums/mysql-timestamp-to-desired-123463.html" title="Hi all, 
 
I have a a timestamp in a DB (14 digits) that I want to display like I 
want in my pages. I tried to use strtotime, mktime and date...">MySQL timestamp to desired date function</a></h6> <div class="starter_forum">
       By Cesar Aracena in forum PHP Development
    </div> </div> <div class="dateblock"> <span class="shade">Replies:</span> 2
      <div class="starter_forum"> <span class="shade">Last Post:</span> September 18th, <span class="time">11:39 AM</span> </div> </div> </li><li class="floatcontainer"> <div class="titleblock"> <h6><a href="http://www.justskins.com/forums/mysql-or-php-timestamp-100181.html" title="Hey everyone, 
 
I am writing an application to keep track of employee vacation leave. I have 
two timestamp(14) database fields, lets call them...">mysql or php timestamp arithmatic</a></h6> <div class="starter_forum">
       By Christian Calloway in forum PHP Development
    </div> </div> <div class="dateblock"> <span class="shade">Replies:</span> 0
      <div class="starter_forum"> <span class="shade">Last Post:</span> August 25th, <span class="time">12:06 PM</span> </div> </div> </li><li class="floatcontainer"> <div class="titleblock"> <h6><a href="http://www.justskins.com/forums/php-convert-mysql-datetime-52110.html" title="Tried passing it through strtotime? 
 
Example: 
 
echo(date('U',strtotime($string))); 
 
On Mon, 2003-07-28 at 12:06, Chris Hayes (SENSE) wrote: 
--...">[PHP] convert mysql datetime to unix timestamp</a></h6> <div class="starter_forum">
       By Adam Voigt in forum PHP Programming
    </div> </div> <div class="dateblock"> <span class="shade">Replies:</span> 1
      <div class="starter_forum"> <span class="shade">Last Post:</span> July 28th, <span class="time">04:38 PM</span> </div> </div> </li> </ol> </div> </div> <div class="options_block_container"> <div class="options_block2"> <h4 class="blockhead options_correct">Bookmarks</h4> <div id="social_bookmarks_list" class="thread_info_block blockbody formcontrols floatcontainer options_correct"> <h5 class="blocksubhead">Bookmarks</h5> <ul class="icon_list"><li class="smallfont"> <a rel="nofollow" href="http://del.icio.us/post?url=http%3A%2F%2Fwww.justskins.com%2Fforums%2Fhelp-needed-for-timestamp-13013.html&amp;title=Help+needed+for+TimeStamp+conversion+between++MySQL+and+PHP" target="socialbookmark"><img src="images/metro/blue/misc/bookmarksite_delicious.gif" alt="Submit to del.icio.us" /></a> <a rel="nofollow" href="http://del.icio.us/post?url=http%3A%2F%2Fwww.justskins.com%2Fforums%2Fhelp-needed-for-timestamp-13013.html&amp;title=Help+needed+for+TimeStamp+conversion+between++MySQL+and+PHP" target="socialbookmark">del.icio.us</a> </li><li class="smallfont"> <a rel="nofollow" href="http://www.stumbleupon.com/submit?url=http%3A%2F%2Fwww.justskins.com%2Fforums%2Fhelp-needed-for-timestamp-13013.html&amp;title=Help+needed+for+TimeStamp+conversion+between++MySQL+and+PHP" target="socialbookmark"><img src="images/metro/blue/misc/bookmarksite_stumbleupon.gif" alt="Submit to StumbleUpon" /></a> <a rel="nofollow" href="http://www.stumbleupon.com/submit?url=http%3A%2F%2Fwww.justskins.com%2Fforums%2Fhelp-needed-for-timestamp-13013.html&amp;title=Help+needed+for+TimeStamp+conversion+between++MySQL+and+PHP" target="socialbookmark">StumbleUpon</a> </li><li class="smallfont"> <a rel="nofollow" href="http://www.google.com/bookmarks/mark?op=edit&amp;output=popup&amp;bkmk=http%3A%2F%2Fwww.justskins.com%2Fforums%2Fhelp-needed-for-timestamp-13013.html&amp;title=Help+needed+for+TimeStamp+conversion+between++MySQL+and+PHP" target="socialbookmark"><img src="images/metro/blue/misc/bookmarksite_google.gif" alt="Submit to Google" /></a> <a rel="nofollow" href="http://www.google.com/bookmarks/mark?op=edit&amp;output=popup&amp;bkmk=http%3A%2F%2Fwww.justskins.com%2Fforums%2Fhelp-needed-for-timestamp-13013.html&amp;title=Help+needed+for+TimeStamp+conversion+between++MySQL+and+PHP" target="socialbookmark">Google</a> </li></ul> </div> </div> <div class="options_block"> <h4 class="collapse blockhead options_correct"> <a class="collapse" id="collapse_posting_rules" href="http://www.justskins.com/forums/help-needed-for-timestamp-13013.html#top"><img src="images/metro/blue/buttons/collapse_40b.png" alt="" /></a>
				Posting Permissions
			</h4> <div id="posting_rules" class="thread_info_block blockbody formcontrols floatcontainer options_correct"> <div id="forumrules" class="info_subblock"> <ul class="youcandoblock"> <li>You <strong>may not</strong> post new threads</li> <li>You <strong>may not</strong> post replies</li> <li>You <strong>may not</strong> post attachments</li> <li>You <strong>may not</strong> edit your posts</li> <li>&nbsp;</li> </ul> <div class="bbcodeblock"> <ul> <li><a rel="nofollow" href="http://www.justskins.com/forums/misc.php?do=bbcode" target="_blank">BB code</a> is <strong>On</strong></li> <li><a rel="nofollow" href="http://www.justskins.com/forums/misc.php?do=showsmilies" target="_blank">Smilies</a> are <strong>Off</strong></li> <li><a rel="nofollow" href="http://www.justskins.com/forums/misc.php?do=bbcode#imgcode" target="_blank">[IMG]</a> code is <strong>On</strong></li> <li><a rel="nofollow" href="http://www.justskins.com/forums/misc.php?do=bbcode#videocode" target="_blank">[VIDEO]</a> code is <strong>On</strong></li> <li>HTML code is <strong>Off</strong></li> <li><a rel="nofollow" href="http://www.justskins.com/forums/misc.php?do=linkbacks#trackbacks" target="_blank">Trackbacks</a> are <strong>On</strong></li> <li><a rel="nofollow" href="http://www.justskins.com/forums/misc.php?do=linkbacks#pingbacks" target="_blank">Pingbacks</a> are <strong>On</strong></li> <li><a rel="nofollow" href="http://www.justskins.com/forums/misc.php?do=linkbacks#refbacks" target="_blank">Refbacks</a> are <strong>On</strong></li> </ul> </div> <p class="rules_link"><a rel="nofollow" href="http://www.justskins.com/forums/misc.php?do=showrules" target="_blank">Forum Rules</a></p> </div> </div> </div> </div> </div> <div style="clear: left"> </div> </div> <div id="footer" class="floatcontainer footer"> <form action="http://www.justskins.com/forums/" method="get" id="footer_select" class="footer_select"> </form> <ul id="footer_links" class="footer_links"> <li><a href="http://www.justskins.com/forums/sendmessage.php" rel="nofollow" accesskey="9">Contact Us</a>  |  </li> <li><a href="http://www.justskins.com">Just Skins</a>  |  </li> <li><a href="sitemap/">Archive</a>  |  </li> <li><a href="http://www.justskins.com/forums/help-needed-for-timestamp-13013.html#top" onclick="document.location.hash='top'; return false;">Top</a></li> </ul> <script type="text/javascript"> <!--
		// Main vBulletin Javascript Initialization
		vBulletin_init();
	//--> </script> </div> </div>  <div class="below_body"> <div id="footer_time" class="shade footer_time">All times are GMT. The time now is <span class="time">10:15 PM</span>.</div> <div id="footer_morecopyright" class="shade footer_morecopyright">  
	Copyright � 2006 - 2014, JustSkins.com
	
</div> </div> <br /><div style="z-index:3" class="smallfont" align="center"><a href="http://www.justskins.com/forums/sitemap/f-10.html">1</a> <a href="http://www.justskins.com/forums/sitemap/f-9.html">2</a> <a href="http://www.justskins.com/forums/sitemap/f-13.html">3</a> <a href="http://www.justskins.com/forums/sitemap/f-12.html">4</a> <a href="http://www.justskins.com/forums/sitemap/f-11.html">5</a> <a href="http://www.justskins.com/forums/sitemap/f-14.html">6</a> <a href="http://www.justskins.com/forums/sitemap/f-15.html">7</a> <a href="http://www.justskins.com/forums/sitemap/f-16.html">8</a> <a href="http://www.justskins.com/forums/sitemap/f-17.html">9</a> <a href="http://www.justskins.com/forums/sitemap/f-18.html">10</a> <a href="http://www.justskins.com/forums/sitemap/f-19.html">11</a> <a href="http://www.justskins.com/forums/sitemap/f-20.html">12</a> <a href="http://www.justskins.com/forums/sitemap/f-21.html">13</a> <a href="http://www.justskins.com/forums/sitemap/f-22.html">14</a> <a href="http://www.justskins.com/forums/sitemap/f-33.html">15</a> <a href="http://www.justskins.com/forums/sitemap/f-24.html">16</a> <a href="http://www.justskins.com/forums/sitemap/f-25.html">17</a> <a href="http://www.justskins.com/forums/sitemap/f-26.html">18</a> <a href="http://www.justskins.com/forums/sitemap/f-27.html">19</a> <a href="http://www.justskins.com/forums/sitemap/f-28.html">20</a> <a href="http://www.justskins.com/forums/sitemap/f-29.html">21</a> <a href="http://www.justskins.com/forums/sitemap/f-30.html">22</a> <a href="http://www.justskins.com/forums/sitemap/f-31.html">23</a> <a href="http://www.justskins.com/forums/sitemap/f-34.html">24</a> <a href="http://www.justskins.com/forums/sitemap/f-35.html">25</a> <a href="http://www.justskins.com/forums/sitemap/f-38.html">26</a> <a href="http://www.justskins.com/forums/sitemap/f-42.html">27</a> <a href="http://www.justskins.com/forums/sitemap/f-48.html">28</a> <a href="http://www.justskins.com/forums/sitemap/f-54.html">29</a> <a href="http://www.justskins.com/forums/sitemap/f-59.html">30</a> <a href="http://www.justskins.com/forums/sitemap/f-56.html">31</a> <a href="http://www.justskins.com/forums/sitemap/f-36.html">32</a> <a href="http://www.justskins.com/forums/sitemap/f-37.html">33</a> <a href="http://www.justskins.com/forums/sitemap/f-55.html">34</a> <a href="http://www.justskins.com/forums/sitemap/f-39.html">35</a> <a href="http://www.justskins.com/forums/sitemap/f-40.html">36</a> <a href="http://www.justskins.com/forums/sitemap/f-41.html">37</a> <a href="http://www.justskins.com/forums/sitemap/f-43.html">38</a> <a href="http://www.justskins.com/forums/sitemap/f-49.html">39</a> <a href="http://www.justskins.com/forums/sitemap/f-44.html">40</a> <a href="http://www.justskins.com/forums/sitemap/f-45.html">41</a> <a href="http://www.justskins.com/forums/sitemap/f-46.html">42</a> <a href="http://www.justskins.com/forums/sitemap/f-47.html">43</a> <a href="http://www.justskins.com/forums/sitemap/f-50.html">44</a> <a href="http://www.justskins.com/forums/sitemap/f-51.html">45</a> <a href="http://www.justskins.com/forums/sitemap/f-52.html">46</a> <a href="http://www.justskins.com/forums/sitemap/f-53.html">47</a> <a href="http://www.justskins.com/forums/sitemap/f-57.html">48</a> <a href="http://www.justskins.com/forums/sitemap/f-58.html">49</a> <a href="http://www.justskins.com/forums/sitemap/f-60.html">50</a> <a href="http://www.justskins.com/forums/sitemap/f-62.html">51</a> <a href="http://www.justskins.com/forums/sitemap/f-63.html">52</a> <a href="http://www.justskins.com/forums/sitemap/f-65.html">53</a> <a href="http://www.justskins.com/forums/sitemap/f-69.html">54</a> <a href="http://www.justskins.com/forums/sitemap/f-70.html">55</a> <a href="http://www.justskins.com/forums/sitemap/f-71.html">56</a> <a href="http://www.justskins.com/forums/sitemap/f-72.html">57</a> <a href="http://www.justskins.com/forums/sitemap/f-73.html">58</a> <a href="http://www.justskins.com/forums/sitemap/f-74.html">59</a> <a href="http://www.justskins.com/forums/sitemap/f-79.html">60</a> <a href="http://www.justskins.com/forums/sitemap/f-81.html">61</a> <a href="http://www.justskins.com/forums/sitemap/f-80.html">62</a> <a href="http://www.justskins.com/forums/sitemap/f-82.html">63</a> <a href="http://www.justskins.com/forums/sitemap/f-66.html">64</a> <a href="http://www.justskins.com/forums/sitemap/f-67.html">65</a> <a href="http://www.justskins.com/forums/sitemap/f-68.html">66</a> <a href="http://www.justskins.com/forums/sitemap/f-76.html">67</a> <a href="http://www.justskins.com/forums/sitemap/f-77.html">68</a> <a href="http://www.justskins.com/forums/sitemap/f-78.html">69</a> <a href="http://www.justskins.com/forums/sitemap/f-84.html">70</a> <a href="http://www.justskins.com/forums/sitemap/f-85.html">71</a> <a href="http://www.justskins.com/forums/sitemap/f-88.html">72</a> <a href="http://www.justskins.com/forums/sitemap/f-89.html">73</a> <a href="http://www.justskins.com/forums/sitemap/f-96.html">74</a> <a href="http://www.justskins.com/forums/sitemap/f-98.html">75</a> <a href="http://www.justskins.com/forums/sitemap/f-104.html">76</a> <a href="http://www.justskins.com/forums/sitemap/f-100.html">77</a> <a href="http://www.justskins.com/forums/sitemap/f-97.html">78</a> <a href="http://www.justskins.com/forums/sitemap/f-101.html">79</a> <a href="http://www.justskins.com/forums/sitemap/f-107.html">80</a> <a href="http://www.justskins.com/forums/sitemap/f-103.html">81</a> <a href="http://www.justskins.com/forums/sitemap/f-106.html">82</a> <a href="http://www.justskins.com/forums/sitemap/f-102.html">83</a> <a href="http://www.justskins.com/forums/sitemap/f-99.html">84</a> <a href="http://www.justskins.com/forums/sitemap/f-90.html">85</a> <a href="http://www.justskins.com/forums/sitemap/f-93.html">86</a> <a href="http://www.justskins.com/forums/sitemap/f-92.html">87</a> <a href="http://www.justskins.com/forums/sitemap/f-94.html">88</a> <a href="http://www.justskins.com/forums/sitemap/f-95.html">89</a> <a href="http://www.justskins.com/forums/sitemap/f-91.html">90</a> <a href="http://www.justskins.com/forums/sitemap/f-108.html">91</a> <a href="http://www.justskins.com/forums/sitemap/f-110.html">92</a> <a href="http://www.justskins.com/forums/sitemap/f-109.html">93</a> <a href="http://www.justskins.com/forums/sitemap/f-111.html">94</a> <a href="http://www.justskins.com/forums/sitemap/f-112.html">95</a> <a href="http://www.justskins.com/forums/sitemap/f-113.html">96</a> <a href="http://www.justskins.com/forums/sitemap/f-114.html">97</a> <a href="http://www.justskins.com/forums/sitemap/f-115.html">98</a> <a href="http://www.justskins.com/forums/sitemap/f-116.html">99</a> <a href="http://www.justskins.com/forums/sitemap/f-117.html">100</a> <a href="http://www.justskins.com/forums/sitemap/f-118.html">101</a> <a href="http://www.justskins.com/forums/sitemap/f-119.html">102</a> <a href="http://www.justskins.com/forums/sitemap/f-120.html">103</a> <a href="http://www.justskins.com/forums/sitemap/f-121.html">104</a> <a href="http://www.justskins.com/forums/sitemap/f-122.html">105</a> <a href="http://www.justskins.com/forums/sitemap/f-123.html">106</a> <a href="http://www.justskins.com/forums/sitemap/f-124.html">107</a> <a href="http://www.justskins.com/forums/sitemap/f-126.html">108</a> <a href="http://www.justskins.com/forums/sitemap/f-137.html">109</a> <a href="http://www.justskins.com/forums/sitemap/f-138.html">110</a> <a href="http://www.justskins.com/forums/sitemap/f-155.html">111</a> <a href="http://www.justskins.com/forums/sitemap/f-127.html">112</a> <a href="http://www.justskins.com/forums/sitemap/f-128.html">113</a> <a href="http://www.justskins.com/forums/sitemap/f-129.html">114</a> <a href="http://www.justskins.com/forums/sitemap/f-131.html">115</a> <a href="http://www.justskins.com/forums/sitemap/f-130.html">116</a> <a href="http://www.justskins.com/forums/sitemap/f-132.html">117</a> <a href="http://www.justskins.com/forums/sitemap/f-154.html">118</a> <a href="http://www.justskins.com/forums/sitemap/f-133.html">119</a> <a href="http://www.justskins.com/forums/sitemap/f-134.html">120</a> <a href="http://www.justskins.com/forums/sitemap/f-135.html">121</a> <a href="http://www.justskins.com/forums/sitemap/f-139.html">122</a> <a href="http://www.justskins.com/forums/sitemap/f-140.html">123</a> <a href="http://www.justskins.com/forums/sitemap/f-141.html">124</a> <a href="http://www.justskins.com/forums/sitemap/f-142.html">125</a> <a href="http://www.justskins.com/forums/sitemap/f-143.html">126</a> <a href="http://www.justskins.com/forums/sitemap/f-144.html">127</a> <a href="http://www.justskins.com/forums/sitemap/f-145.html">128</a> <a href="http://www.justskins.com/forums/sitemap/f-136.html">129</a> <a href="http://www.justskins.com/forums/sitemap/f-147.html">130</a> <a href="http://www.justskins.com/forums/sitemap/f-148.html">131</a> <a href="http://www.justskins.com/forums/sitemap/f-149.html">132</a> <a href="http://www.justskins.com/forums/sitemap/f-150.html">133</a> <a href="http://www.justskins.com/forums/sitemap/f-151.html">134</a> <a href="http://www.justskins.com/forums/sitemap/f-152.html">135</a> <a href="http://www.justskins.com/forums/sitemap/f-153.html">136</a> <a href="http://www.justskins.com/forums/sitemap/f-2.html">137</a> <a href="http://www.justskins.com/forums/sitemap/f-5.html">138</a> <a href="http://www.justskins.com/forums/sitemap/f-7.html">139</a> </div>

<script type="text/javascript">
//<![CDATA[

window.orig_onload = window.onload;
window.onload = function() {
var cpost=document.location.hash.substring(1);var cpost2='';if(cpost && (typeof fetch_object != 'undefined')){ var ispost=cpost.substring(0,4)=='post';if(ispost)cpost2='post_'+cpost.substring(4);if((cobj = fetch_object(cpost))||(cobj = fetch_object(cpost2))){cobj.scrollIntoView(true);}else if(ispost){cpostno = cpost.substring(4,cpost.length);if(parseInt(cpostno)>0){location.replace('http://www.justskins.com/forums/showthread.php?p='+cpostno);};} }

if(typeof window.orig_onload == "function") window.orig_onload();
}

//]]>
</script>
</body> </html>