Tracking script

[danx30]

Okay here's how it goes.  A user with a username visits my website.  That username is saved into a cookie.  They visit my affiliate, signup with the affiliate and I have it set with the affiliate for pixel tracking and point it to a .php page with the code.  They give me 2 pixel tracking options:

 

<SCRIPT language="javascript" src="http://www.myserver.com/tracking.php"></SCRIPT>

and

< IMG src="http://www.myserver.com/tracking.php" height="1" width="1">

 

I'm not sure which one to use.  Below is my tracking.php script.

 

<?php

$n1 = $HTTP_COOKIE_VARS["cookiename"];

mysql_connect("127.0.0.1", "username", "password") or die(mysql_error());

mysql_select_db("db") or die(mysql_error());

mysql_query("UPDATE users SET click5='1' where name='$n1'");

php?>

 

Which will save read the users name from the cookie and save a 1 into the database in the right spot under their name.  All well and good.  But with pixel tracking do I have to have a code in there to actually draw a 1X1 pixel, or should it just work as is?

[redarrow]

It not that easy sorry m8,

 

As what i can see from your idear is that a user pay's you a price for them to place a picture up on

you website and according to the size of the grid they choose you charge them a fee, i think that what

you want am i correct?

[danx30]

Wow, no.  lol

 

The users of my website already have a username and I track what they do on the website and save that into a mysql database.  However some links on my page point to affiliates.  I want to track when they sign up with the affiliate.

[danx30]

Anyone understand what I'm talking about?

[danx30]

I'm begging here people!  PLEASE HELP!