Home | How it works | Projects archive | Contact Us
Air Compressor Bot 		 
The Career Path of Freelance Programming Jobs 

   Php File Fix
Bidding Time:
27/05/2008 22:56 - 10/06/2008 22:56
Budget:
N/A
Status:
 Closed


Job Type:
PHP, MySQL
Description:

Professional Hosting from Just Host

Hello,
I have one file that needs coded. It is attached to this project.
Here's what that file needs to do.
It is for an affiliate site. The file is the index.php file and when
a user displays his affiliate link it looks like this:
http://www.thedomain.com/index.php?referid=showme48 with the showme48 being a
userid. What I need is for the page to pull information about that
member(userid) from the database and display it on the index.php page, and if no
'referer'(http://www.thedomain.com/index.php) then pull information about the
admin into the page.
Here is how the database is structured. The rest is in the zip file.

CREATE TABLE `members` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`address` varchar(200) NOT NULL default '',
`city` varchar(100) NOT NULL default '',
`state` varchar(100) NOT NULL default '',
`zipcode` varchar(10) NOT NULL default '',
`country` varchar(50) NOT NULL default '',
`phone` varchar(20) NOT NULL default '',
`contact_email` varchar(50) NOT NULL default '',
`pword` varchar(20) NOT NULL default '',
`userid` varchar(20) NOT NULL default '',
`status` tinyint(4) NOT NULL default '0',
`referid` varchar(20) NOT NULL default '',
`verified` tinyint(4) NOT NULL default '0',
KEY `index` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

CREATE TABLE `admin` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`address` varchar(200) NOT NULL default '',
`city` varchar(100) NOT NULL default '',
`state` varchar(100) NOT NULL default '',
`zipcode` varchar(10) NOT NULL default '',
`country` varchar(50) NOT NULL default '',
`phone` varchar(20) NOT NULL default '',
`contact_email` varchar(50) NOT NULL default '',
`pword` varchar(20) NOT NULL default '',
KEY `index` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

Start your work-at-home career for $7.00. Get direct access to thousands of freelance and home-based jobs. Click here to find work now.

Related Projects:
Child Tracking System
Building A Members Area Site
Need Cronjob Setup For Phplist
Convert Db Data To Hsql
Pvt project for sana

This project is the proprietary information of . Click here to remove this project from OUR database.
Operating System:
 N/A
Database System:
 N/A
<<< back

Recent Projects Archive:

Thursday - Wednesday - Tuesday - Monday - Sunday - Saturday - Friday

View all freelance web projects
 
Home | Projects archive | RSS | Resources | Links | Contact Us © 2004-2008 ProjectsList.biz /0.998