Joe's Randomness that is blog

11/02/2005

The New Job

So I've been at my new job for 2.5 weeks. I think I made the right decision coming here. I don't wake up in the mornings and feel sick at the thought of going to work. And apart from much less stress, I like the environment here. Its much more relaxed. And because of that, I feel as though I can get more work done.

So, my job here when I started was to finish building the front and back-ends of a website, elitevaluecards.com. There was a lot done, but the database had yet to be started so I had to finish up probably close to 80% of the back-end programming, along with creating the database. Glad to say, I did that in about 1.5 weeks. We officially took the site live yesterday afternoon and I haven't seen any problems with it yet (that weren't able to be fixed immediately).

Right now, I'm working on fixing the website of the guy that was here before me made. Seems like there's a lot of session problems so people get logged in when they shouldn't and get logged off when they do certain things. Yay for having to deal with code thats supposedly complete but doesn't work correctly! I think I may just try to re-create everything on my own for when we set up a subdomain for our primary website. Would be fairly simple I think and then I'd have a better understanding of exactly whats going wrong if something did happen.

Until then, we will limp along with our semi-working website.

Questions I have been unable to answer:
1)Is there a simple way to synch two databases on seperate servers (when the server's don't allow remote access)?
2)Is there a reason in MySQL 4.25 that TRIM(username) wouldn't turn the username 'somedoofus ' (notice the space) into 'somedoofus'?
3)If I want to see if the last time something was updated (I have a date for the last update, format 05/05/2005) and check if that last update was greater than 2 weeks ago, shouldn't the SQL be something like date_sub(last_update, interval 14 day)? Because thats not working. . .