PHP/MySQL int to ASCII?

HiImFreddy

Hi all, first-time poster here. Just to warn you, I'm a Graphic Design major who did some coding WAY back... Don't hurt me. 🙂

Well, I just set up an Apache/MySQL server on my laptop and I made my first PHP/MySQL webpage... So while I have a ton of questionmarks in my head at this point, I'll start with the one at the top of my list:

I want to track usage on a website and while I know I'm a long way from there, I made a column on my MySQL table be an INT value (sorry if I'm raping the proper terminology BTW). The problem is, when I try to do a:

PRINT "$clicks";

it's blank. Now I can pretty much guess it's because it's an INT instead of a VARCHAR, but how would I make the conversion with PHP so it can be output in the HTML?

Is this making any sense? Thanks in advance for any help you can give. 🙂

matbennett

The print statement should work fine on a an INT value (PHP is really forgiving in this way).

I would imagine that the problem is that the value of $clicks has not been set correctly. Can you quote the code that you are using to pull the value from the database and assign it to $clicks.

It may also be worth checking that the print statement is being performed (not buried in an unrun loop or anything). An easy way to do this is just to do:

print "clicks = $clicks";

Then, if you just get clicks = it is a problem with the value being set.

I'm not expert, but I can take a look.

HiImFreddy

Hmm.... Interesting.

I must have screwed up somewhere, so I'll give it another shot tomorrow. Thanks for the info and I'll see if it works.

Thanks again!

HiImFreddy

Yeah, it was a stupid newbie mistake. 🙂

Thanks again for the help. I would have been spending all day looking for a solution for a problem that didn't exist.

matbennett

In my book it only counts as a stupid mistake when you have made it for the third or forth time!

HiImFreddy

Heh, good point. 🙂

I'm actually sorta happy how far I've gotten up to this point with what I've been attempting. While the code is just hnorribly ugly to look at, I'm starting to understand how the whole process works.

I just gotta push myself to make forward strides on a daily basis.

Thanks again!