Hint: Use 'j' and 'k' keys
to move up and down

Yaz's Blog

I am a php developer. I am a geek. I am a fiction reader. A movie and tv addict.
An XBOX360 player. A snowboarder. A cyclist. A Softball player. A Venezuelan-Canadian.

Tagged with:  #music  #work

That call was awesome.......

  • us: the program was running and it sends about 1 e-mail a second.
  • them: ok, i think it was going for about 5 minutes, so it sent 800 e-mails
  • us: um...not really...no

No MySQL Test Syntax Functions…

I normally don’t post things about work or my career here, but this doesnt really fit anywhere else.

I’ve been working on this one php script for about 2 days. It basically updates very critical information about an user on several tables. Not something unusual but I’ve always been scared of testing scripts that affect our main user tables. And yeah we do have backups but this would be one of those times when reverting would be a b!tch.

So I decided to go hunting for a function that would test my MySQL query without actually running the query. And to my amazement, it doesn’t exist! Not only am I amazed, I’m shocked somebody hasn’t created a native php function.

God knows how much time did I spend figuring out why my queries were breaking when I started coding. It would be incredibly useful, since like me, I’m sure there are a lot of people out there that would like that safety feature. For now though, I’m just going to have to run the script and hope for the best.