Retrieving lastvisit, should be easy...

[mr e]

Ok this is my code



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



But everytime I call $userlastvisit it says "1018586613" I have tried $user[lastvisit], $user[lastvisitdate], $user['lastvisit'], and $user['lastvisitdate']. I'm probably making this harder than it should be, but help please. :ogre:

[Chen]

First of all, use the query_first() method instead of query() and then fetch_array(), since you are only getting one row of data. :)

Anyway, what you get (that long number) is in Unix Timestamp, and needs to be converted. Use:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------


FORMAT is the format of the date / time, see the manual entry for date() for more info.

[mr e]

:D Thanx FireFly, that was MUCH easier than what I thought it would be. :bandit:

But about the query_first, if I use that I get an error in db_mysql about a bad argument, so I had to just use query.

[Chen]

If you use query_first() you don't need fetch_array(), because it does that internally.

So instead of:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------


You just use this:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[mr e]

Oh ok I got it now, sorry I'm still trying to learn all this coding.

[jjj0923]

Firefly - what a timely post.

Thanks for this information.

While we're on the subject, I was working over the weekend trying something along the same lines.

I have Photopost installed along with vbulletin and I want to pop-up a little javascript message or display a blinking "photo gallery" graphic if there have been new photos posted in the gallery since the users last visit.

The problem I was running into was selecting the photopost db in index.php. It would appear to get selected properly (since servername, username & password) are the same, but then I went to select data from the photpost db, I would get a message returned a string that said something like "Resource ID 27".

I'm fairly confident the select_db was working ok becuase if I did not reselect the Vbulletin db at the end of my code, vb would throw errors.

any ideas????

thanks if advance Firefly!

- jeff

[Chen]

Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------


$result isn't what you are looking for, you first need to fetch the row:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------


And then use $result['fieldName'].

[jjj0923]

cool - thanks!

now where do you want me to send contributions for that condo????

:) - jeff