MySQL help: seemingly simple
I have a real problem. It's stupid, but it doesn't work and I can't figure it out. I'm storing a hit counter in a database (don't ask why). I can get the number to go up each time, I just can't get it to display on the page. My table has one row in it and two columns (id and hits). id = 0 and hits = the number of hits, obviously.
I've tried "SELECT hits FROM table" and "SELECT hits FROM table WHERE id = '0'" and basically everything I can think of, and every time I get the same result: a string that says "Resource id #2" Any idea why this is? And any idea how to fix this? Thanks a ton.