Date problems

[objelland +]

What version of 68 Classifieds are you running?
Example: V4.1.6 Designer

What template are you using?
default

Please describe in detail the issue you are having:
Hi all,
I am trying to pull the expiration date out of the class_producst table like this:

$sSQL= "SELECT expiration FROM ".PREFIX."products WHERE section = '4704' and id = ".$userid." LIMIT 1";
$result=$db->query($sSQL);
$rs=$result->fetch();
$origDate = explode("-", $rs['expiration']);
$expiration= mktime(0,0,0,$origDate[1],$origDate[2],$origDate[0]);
$expiration = strftime("%Y-%m-%d",$expiration);

Then I am assignng the result to the template like this:

$class_tpl->assign('expiration',$expiration);

My problem is, "no matter what I do" the result of the query returns "1970-01-01".
I know this is the start of the Unix time age, but how can I get this solved? There is probably some function or convert string that I am not aware of. Can somebody please help me out with this?

Thank you!

Regards ,
Oyvind

[Eric Barnes]

I would just pull it out as it is stored and then use smarty date format to change it:
Smarty

{$expiration|date_format:"%A, %B %e, %Y"}

[objelland +]

Originally Posted by Eric Barnes

I would just pull it out as it is stored and then use smarty date format to change it:
Smarty

{$expiration|date_format:"%A, %B %e, %Y"}

Hi,

My problem is not the display of the data, but the result of the query. The expiration field in the class_products table contains the value "2009-12-12", but the SQL Query returns "1970-01-01"...

Regardsm

Oyvind

[Lhotch +]

Originally Posted by objelland

Hi,

My problem is not the display of the data, but the result of the query. The expiration field in the class_products table contains the value "2009-12-12", but the SQL Query returns "1970-01-01"...

Regardsm

Oyvind

How did you determine that?

[Lhotch +]

actually, looking at your query a bit closer I see why, the products table doesnt have a field called expiration.

[objelland +]

Originally Posted by Lhotch

actually, looking at your query a bit closer I see why, the products table doesnt have a field called expiration.

Well, I am running a version that has that field in the producst table. I know my version isn't supportet (developer 3.1.5b), but I was still hoping for some help here

Thanks,

Oyvind

[Lhotch +]

Originally Posted by objelland

Well, I am running a version that has that field in the producst table. I know my version isn't supportet (developer 3.1.5b), but I was still hoping for some help here

Thanks,

Oyvind

In your first post you have version 4.1.6, now your saying your running 3.1.5.

Not giving us these sort of details up front means you contribute to people possibly spending time trying to help you by looking at info that isnt even relevant and in turn wastes their time. That lack of respect for other peoples time certainly isnt going to make people help you.

[objelland +]

Originally Posted by Lhotch

In your first post you have version 4.1.6, now your saying your running 3.1.5.

Not giving us these sort of details up front means you contribute to people possibly spending time trying to help you by looking at info that isnt even relevant and in turn wastes their time. That lack of respect for other peoples time certainly isnt going to make people help you.

I can see that you are getting upset with me waisting your precious time. I have just one question for you "WHAT HAPPEND TO ALLOWING PEOPLE TO MAKE MISTAKES???? "
You are probarbly using this forum every singel day, at least it looks like it based on the number of threads you have posted. Could it be possible that other people aren't as into the forum rules as you are?? Just a question from me to you..... Could it be possible that I over looked the version 4.1.6 part because it is default in when posting a new thread?

Oyvind

[Lhotch +]

Originally Posted by objelland

"WHAT HAPPEND TO ALLOWING PEOPLE TO MAKE MISTAKES???? "

I make mistakes all the time.....like posting in this thread.

[Eric Barnes]

Look in the database and double check that the date value is actually something other than the really old one.

Next try to just echo it without having it run through this code:

$origDate = explode("-", $rs['expiration']);
$expiration= mktime(0,0,0,$origDate[1],$origDate[2],$origDate[0]);
$expiration = strftime("%Y-%m-%d",$expiration);