Closed SQL server admin/database job

This project was awarded to ehsankayani for $100 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
Project Description


I run a website. I have two email-related forms. One form is [url removed, login to view] and the second is [url removed, login to view]

Currently this is how the form works: When someone fills out the [url removed, login to view] form a message is sent from a noreply email to a specific email address that we get messages to. I get an email with the user's message, for example:
Name: , Email: Topic: Event Inquiry, Message: SampleCommentMessage

When someone uses the form on [url removed, login to view] I get a message from a noreply email to our email address. The message says for example:

Someone has referred a friend on NY Minute Dating.

Referred By:

Referred To:


While I get an email message of the message that is sent to us through the contact form, and I get an email when someone refers a friend to the site, the problem is that none of these messages are saved to our database in anyway.


I want to create two new pages on the admin panel. One will be called Messages and the other Friend Referrals.


When someone submits a message through the [url removed, login to view] page, the message will appear on the Messages pages in the admin. The columns will be:

Date, Name, Email address, Message.

You will create a table in the database called Messages with the tables:

Date, Name, EmailAddress, Message

The date format will be like this: Wednesday, November 23, 2011 7:00 PM End: 11:00 PM - this is how the date appears on the current pages of my admin panel.


Friend Referral page
When someone submits a message through the [url removed, login to view] form, a row will appear in the Friend Referral page with the following columns:

Date, Referred by, Email, Friend's Email

You will create a database table called ReferredBy with the following columns:

Date, ReferredBy, ReferredByEmail, ReferredToEmail, CommentForRefer

It may be a good idea for each entry on each database table to have a unique key so it can be easy to develop further more easily in future.

I want to continue receiving email messages any time someone submits through the contact form or tell-a-friend form.


I will give you a blank copy of my current database and a copy of my [url removed, login to view] in case you need to have it, and also a copy of the [url removed, login to view], [url removed, login to view], and [url removed, login to view], and tellafriend.aspx.cs. I doubt you will need to make any changes to the [url removed, login to view] file. If you do make a change, I need to give me a reason.
I will also give you a copy of my [url removed, login to view] page for my admin. Hopefully this is all you need in order to complete the job.


I will not give you direct access to my server or database. Instead, you will complete the work on your end, and then install on my computer via remote desktop. You will need to know how to run queries and other such things in order to create the table, etc. You will transfer to me updated files via Skype and I will place files on correct folder.

I need someone very capable who can complete the project in less than 2 days.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online