Do you know where your variables are? | |
PerlMonks |
MySQL logicby sulfericacid (Deacon) |
on May 27, 2005 at 20:01 UTC ( [id://461218]=perlquestion: print w/replies, xml ) | Need Help?? |
sulfericacid has asked for the wisdom of the Perl Monks concerning the following question:
I started to learn MySQL a few months back but got back tracked but now I'm ready to give it another try. Can someone assist me with the logic of how to go about setting this up? I'm converting my link tracker over to a MySQL backend to make the data more sortable. What it's doing here is checking a url_param for the referring URL and checking whether or not it was in the id row already. If it wasn't, it'll setup the current data (the ip address, the time it was clicked and will start with 1 view). If the url was already setup, it will autoincrement "views", store the current IP address in last_ip (overwriting original value) and store it with ALL ips in all_ip. I'm to the point where I bind the variables to the columns but from here I don't know what to do. Any assistance would be much appreciated.
"Age is nothing more than an inaccurate number bestowed upon us at birth as just another means for others to judge and classify us" sulfericacid
Back to
Seekers of Perl Wisdom
|
|