Affiliate PHP program project - Please help
| From: | r | Date: | Sat, 01 Jun 2002 22:13:05 +0000 |
| Subject: | Affiliate PHP program project - Please help | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-100213@lists.php.net to get a copy of this message | ||
Hi PPL,
I'm doing an affiliate program for a small company in PHP, but am stuck a
bit in the logic or thinking process....
I have a table with IdNo,clicks,month,year
the affiliates will get a link like this
http://mysite.com/affiliates/aff.php?IdNo=775
every time I get a click from 775 in the table I am updating the table with
something like clicks=clicks+1 where month=6 and year=2002 and IdNo=775
My question is how do I get the current month/year from php or do I have to
query the database before every update to get month() and month(day)?
will I have to use something like
(for month) $mon=date(m);
(for year ) $yer=date(Y);
plus the main reason I am writing is to ask you gurus if I have the right
idea to make this work or is it done in some other way? Maybe you have done
a similar program and and can give me some valuble info/insight or wise
words? ;-)
OT- do you have any idea on how to contral the cursor in a form with 10
textfields? is it possible without javascript?
Thanks in advance for ANY help on this,
Have a great day,
-Ryan.