Glad you worked it out!
If it's simply for a single row, I wouldn't fetchall so there's no need to iterate just for one entry. When you use fetchall, you'll need to iterate through each result.
Have fun with your system!
Looking at some of the recent posts by @MiamiH8T, he seems to be having problems with his SWF and the 'Silverwave Plus Emu'.
I'd double check to make sure that I'm not purchasing an existing emu simply renamed. Unless of course, he picked up programming and whipped up an emu in a week or he's...
I don't know what that site uses (And you don't have to use what they use to have a great site)
If you're looking for an opensource shopping cart, I'd recommend OpenCart. It's opensource, PHP based and used by quite a few reputable sites too.