MySQL help: seemingly simple

[wiseguy316]

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.

[DR_LaRRY_PEpPeR]

why are you storing a hit counter in a database??? sorry.

you're probably doing something like this, right:

$hits = mysql_query("SELECT hits FROM table");
echo $hits; 

well, you need to fetch the row before you can display anything. mysql_query() only returns a resource id (which you're seeing). so you need to use something like this:

$result = mysql_query("SELECT hits FROM table WHERE id=0");
$row = mysql_fetch_array($result);
echo $row['hits']; 

[wiseguy316]

Thank you so much! Yes, that's exactly what I was doing. I wasn't sure that I'd need to do the fetch since I was only dealing with a single number. Thanks again! (As you can tell, I'm really a newbie with MySQL.)