Select The | Freelance Jobs

Data Changes & Sql Statements

July 13th, 2009 Comments off

Use the database and tables from last week’s assignment to write SQL statements and enter records into the Employee table for workers identified in the employee files for the administrative offices and the Del Mar store. Check results by selecting all columns from both tables.

Simple Webshop With 1 Product

July 9th, 2009 Comments off

Hello,

I’m looking for a programmer to make us a simple website with cool layout to sell and design Textile Wristbands. It doesn’t need alot of pages, maybe 3-4 only. But it need’s these functions:

It needs these functions:
1) Online design tool to put text on a wristband (like for example http://www.xsband.com/main.php)
2) We would like to offer some pre-existing designs, that can be edited (only tekst can be changed)
3) The user should be taken through a process of chosing first the text or design on the wristband or upload his own design, then he needs to select the amount of wristbands, then he needs to select the kind of closure (metal of plastic) and then he can select extra’s like unique numbering, glow in the dark bands, closure tools etc… After this he select the shipping method and payment method. I would prefer to have all these steps and options on 1 page.
4) After an order has been placed, the user and us receive an invoice for the order.
5) We would like to use online payment too, so the option should be there to implement this in the very near future
6) We need to able to translate the website in multiple languages (dutch, french, english on the first stage). The user should be able to switch to a new langugage easely.

something like: http://www.emfabs.nl/index.html but compacter and online ordering option.

Competition Site

July 2nd, 2009 Comments off

I am reposting this cause of a few problem i had personally stopped me from accepting a bid in time last time i posted this…

I am Looking to create a competition Site, Based on the idea of http://www.milliondollarhomepage.com

Except this site will be a competition site, with a daily competition for users to click the correct pixel on the image and win a Daily prize amount.

with there being a million pixels from them to choose from.. only members can win (free sign up) but anyone should be able to click any pixel in the image..

Members with have a set number of clicks upon sign up (to be determined in an admin area) members use these clicks to attempt to select the winning pixel.. if they select the wrong pixel it will open a web link to an advertiser… and if they select the winning pixel it will open a page to claim their winnings.. When a Pixel is clicked it cannot be clicked again by that user within the competition period, these will be known as dead pixels and will be backed out (with a colour determined by admin) Also a recorded of the pixels they click will be avail in number form.

Users also upon sign up get there own recruitment page that will be the 1000000 pixel image, and every person that views the Members recruitment page gets the user free Clicks (amount determined in admin area) if a new member signs u thro their recruitment page they will get more clicks (again determined by admin).. Users also get free clicks every hrs (determined by admin)..

the advertising area on the boards will be sold in 50×50 areas… advertisers sign up via buy space and select the 50×50 area they want then they upload their image and website link.. advertisers are allowed to buy more than on area (amount determined by admin by using paypal) advertisers show be able to view stats total page views links clicked etc for what area they bought..

There will also be an admin area where everything on website can be controlled price, winning pixel, bonus pixels, ban members, amount of clicks for new members – recruiting – page views, and have all stats, members etc etc

This is an outline of the kind of thing i am looking for time period for this is around August time.. if you have any questions let me know..

Categories: Joomla, MySQL, Perl/CGI, PHP, SQL Tags: Admin, admin area, advertisers, area, click, clicked, clicks, competition, competition site, competition site joomla, determined, etc, free, Image, image and, members, page, pixel, pixels, recruitment, recruitment page, select, select the, site, site joomla perl, the winning pixel, time, users, Views, winning, winning pixel

Sql Good 3

June 18th, 2009 Comments off

(You are to put all your screen snapshots for the items below, each showing the required SQL statements and results, in order, in a single Microsoft Word file. Failure to do so may result in lost points on this assignment.)

Using the database and tables from Week Two, write SQL statements and enter the records into the Employee table for the workers identified in the Employee Files for the administrative offices and the Del Mar location. Check the results by selecting all of the columns from both of your tables. You should now have 17 total employees and 9 total job titles (2 points)

Using the database and tables in Week Two, write SQL queries using Between, Like and Union: (1 point each)

Categories: SQL Tags: and group, and group them, and then salary, and uses, and uses between, and uses like, classification, column order should, Count, count last, count last name, Data, Database, database and, employees, employees last, employees last names, example, example database, exempt, for the, Group, group employees, group them, job, job classification, job classification select, joins, joins two, last, last name, last names, name, name and, names, Order, points, Query, query that, query that joins, record, record selection, restrict, restrict record, restrict record selection, salary, salary within, salary within their, select, select the, selection, selection use, SQL, sql good, sql query, sql query that, Tables, that joins, the column order, the employees, the employees last, the example, the example database, total, two tables, uses, using, using the, week, Write

Competition Site

May 14th, 2009 Comments off