Custom php/mysql Script for tracking email

I need two main functions, link tracking and email open tracking, this will be done using a transparent gif, and link tracking, where UID's are passed. ## Deliverables Email Opening Tracking I need a php script written that allows me to track clicks from emails. so I want to add links and it generate me a tracking url eg: I add: [[login to view URL]][1]**!UID -> [[login to view URL]][2]!UID** ** Then when people visit** [[login to view URL]][1]**!UID**** I want a php script run, that first Enters the UID date and time, and can run a series of other sql queries (I must be able to add quieries to run for each link, and reference the UID in the query.)** **It needs to do a query to get the email address and info from that UID eg:** **Select* FROM lm_users WHERE UID = ‘%UID%’** **Add all this info into an array that can be read from by mycustom sql scripts** **Example query to be run:** ** ** INSERT INTO <em>lm_users</em> (col1,col2,col3) VALUES($name,$email,$info); ** The user is then taken to the final link. If they click a second time, It will need to record this and have the option of running more queries. The second php script I need is: I want to place a small tracking gif in my emails, and when it loads it runs a php script, that records the email was opened (again UID will be included) each time image loads to register the fact. then once registered, it must be able to run a series of mysql quieries that i define. and return an image header.**