Simple PHP / MySQL help needed

Some php / mysql work


I operate a tiny webshop with a custom ordersystem.

The backend is a *very* basic table which lists all the important details of a transaction (ie: name, address, email, etc). Your job is basically to modify this table a little for me.

(If you are *seriously* interested, I can give you access to that tabel so you can have a look)

1. RIght now each transaction is one single row. This means that the table is very wide and thus it gets hhard to work wiith. Please adjust the table so that it fits on a mid-sized screen (width). I suggest that each transaction is slpit up in two rows.

2. Coloro codes for different transaction statuses. Eg. the wholte transaction (row) should ie. be green if the checkbox for "paid" and the checkbox for "shipped" is checked. Here are the different statuses we need: (paid, not shipped ; not paid, not shipped ; not paid, shipped ; paid, shipped ; not paid, not shipped). A different color for each status.

3. Right now the transactions are sorted by tranaction number. Problem iis that when I delete a transaction, the next transaction that is created gets that old ttransaction number and thus the sorting doesn't make sense anymore. What I need is the transactions to be sorted by date.

4. Filter: I want to be able to filter by different criteria: paid / shipped / date

5. By default I only want to see the last 150 transactions. Using a dropdown I want to be able to see more thhan that though.

6. I currently have a checkbox next to each transaction and you can check multiple transactions and then hit the print button..then all the bills are printed. Only problem: as not all bills are A4 size, the beginning of the 2nd bill gets pprinted on the end of the first A4 paper. That doesn't worl. I want each bill to be printed on a seperate A4 sheet. I know this might be tricky but II will be satisfied if you have a soloution that makes printing individula bill easier.

7. Print Adress labels. Just like printing the bills just that I want like 10 address labels on one page. A new checkbox is required and a "print address labels" button.

OK, this looks like a lot but honestly, most of this is very basic php / mysql. Nothing tricky here at all. I just don't have the time to do and test this.

TIMEFRAME: max 5 days.

Payment via Escrow.

Skills: AJAX, PHP, System Admin, Website Design, XML

See more: when is escrow paid, via escrow, transaction escrow, php on iis, php mysql job, php checked checked, php and mysql no codes, paid help, max.sense, first mid, escrow help, escrow adress, bill payment escrow, beginning php and mysql 5, access to php mysql, what is a pending transaction, job needed now, job help, what escrow means, payment via escrow, escrow transactions, escrow ie, a&t labels, worl, test paper

About the Employer:
( 19 reviews ) Dausenau, Germany

Project ID: #235837

23 freelancers are bidding on average $133 for this job


Kindly check PMB

$150 USD in 5 days
(347 Reviews)

Hello. Check PM, please.

$100 USD in 3 days
(222 Reviews)

Get it done professionally and get it done right! We've left you a PM, please check it, thank you. Timothy from ~BliSsGraphicStudio~

$250 USD in 5 days
(131 Reviews)

Please view PMB

$200 USD in 5 days
(66 Reviews)

We can fix all issues as specified. Thank you.

$150 USD in 5 days
(20 Reviews)

not sure about A4 problem

$50 USD in 2 days
(107 Reviews)

I´m an expert php, asp, javascript, ajax programmer and web designer so I can get your work done. The client satisfaction is always my goal. Please see PM for a sample of my work.

$180 USD in 5 days
(5 Reviews)

Dear Sir, First of all, please check a few samples of my work at, [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] http: More

$150 USD in 3 days
(32 Reviews)

Please see PMB.

$50 USD in 3 days
(20 Reviews)

Hello, As you mentioned this is a very straight forward project. I do have some feedback in a PM. Looking forward to your reply. - Steve

$145 USD in 3 days
(1 Review)

I can offer it

$45 USD in 3 days
(11 Reviews)

Hello, We understood your requirement. We can do this in 5 days. Please check the PM for IMPORTANT MESSAGE. Regards, [url removed, login to view]

$125 USD in 5 days
(1 Review)

We are team of professionals expertise in developing web based application using PHP/ Coldfusion and J2EE and in web designing using Photoshop, Dreamweaver MX and Flash MX. After reading your project description we are More

$75 USD in 5 days
(5 Reviews)

i am the guy 4 the job.

$100 USD in 3 days
(0 Reviews)

i will do it for you please pm.

$30 USD in 5 days
(0 Reviews)

Hello! I am interested. Check PM, please.

$100 USD in 2 days
(0 Reviews)

check your PMs

$200 USD in 5 days
(0 Reviews)

sir i can do this project

$100 USD in 30 days
(0 Reviews)

Hi. We just say - let's rock the project. thanks

$200 USD in 2 days
(0 Reviews)

Hi im a Computer Enginner and i had a lot of experience with PHP,MySQL and carts. Expect a profesional work and quality. Best if you can give me access to you store. You can check my background on Internet.

$210 USD in 2 days
(0 Reviews)