All oDesk Jobs » Search Results » Job Facts

oDesk Verified
Payment Method

Flag as inappropriate

Open

Date Posted:	April 3, 2009
Planned Start Date:	April 3, 2009
Estimated Delivery Date:	April 4, 2009
Type:	Fixed-Price
Main Category:	Web Development
Sub Category:	Web Programming
Skills:	PHP MySQL
Estimated Budget:	$1
Last Buyer Activity:	April 4, 2009
Candidates:	6 - average $3.52
Interviews:	none


In Progress

Start Date:	April 4, 2009
Agreed Amount:	$1.11
Hired Provider:	Andrey Pasyukov
Payments:	$1.11 (1)
Refunds:	none

Completed

End Date:	April 4, 2009
Feedback to Provider:	5.00
Feedback to Buyer:	5.00
Amount Paid:	$1.23
Payout Ratio:	111%

Member Since:	January 12, 2009
Country:	United States (GMT-06)
City:	chicago

Jobs Posted:	35
Jobs Filled:	29
Jobs Not Yet Filled:	1

Current Team size:	3
Hours billed, last 30 days:	0
Total oDesk Hours:	163.50
Feedback Score:	4.79 (17)

Feedback from Buyer:

5.0

Skills:		5.0
Quality:		5.0
Availability:		5.0
Deadlines:		5.0
Communication:		5.0
Cooperation:		5.0

Andrey completed the assignment quickly and it worked perfectly. He understood my requirements communicated well and delivered code quickly and accurately so that I could stay on schedule. Excellent work..I would recommend him to all other buyers and I will hire again for future projects.

Feedback from Provider:

5.0

Skills:		5.0
Quality:		5.0
Availability:		5.0
Deadlines:		5.0
Communication:		5.0
Cooperation:		5.0

I would like to work with you.

I would like the 3 seperate query's below combined onto 1 line of code and I do not know how to do this. I am currently using 3 seperate buttons to do these query seperately.

$query = "DELETE FROM `comments` WHERE `userID`=$id";
$query = "DELETE FROM `timesheet` WHERE `userID`=$id";
$query = "DELETE FROM 'users' WHERE 'id'=$id";

keep it simple because I already have all other code.

This is what I want to do:
I want one line of code that will access 3 different tables and delete all data for 1 user.
The user will be identified by the variable $id and I will create a button to delete all data.

My target price is $1. First programmer who delivers working code at target price gets 5.0 positive feedback. No interview required. You can put it in your cover letter if you like. If it works-You get hired.

Provider	From/To	Job Title	Billed	Feedback
113033	03/2009 - Present	Virtual Admin - Assorted Tasks - Virtual Assistant	$14 (3.17 hrs @ $4.44/hr)	Job in progress
125900	04/2009 - Present	Virtual Admin - Assorted Tasks - Virtual Assistant	$5 (2.33 hrs @ $2.22/hr)	Job in progress
184263	04/2009 - Present	PHP MySql programmer to work with me.	$58 (1.00 hrs @ $57.84/hr)	Job in progress
249979	07/2009 - 08/2009	Create Relevant Incoming Links to Website	$67 (20 hrs @ $3.33/hr)	3.9 L Buyer-to-Provider Feedback: 5.0
300581	07/2009 - 08/2009	Create Relevant Incoming Links to Website	$140 (70 hrs @ $2.00/hr)	5.0 Very good buyer! L Buyer-to-Provider Feedback: 5.0
332327	07/2009 - 08/2009	Create Relevant Incoming Links to Website	$38 (23 hrs @ $1.67/hr)	5.0 L Buyer-to-Provider Feedback: 5.0
344986	07/2009 - 08/2009	Create Relevant Incoming Links to Website	$33 (12 hrs @ $2.78/hr)	5.0 beth snaper is great . He has paid promptly and one time provide all the instruction. L Buyer-to-Provider Feedback: 5.0
355425	07/2009 - 07/2009	Create Relevant Incoming Links to Website	$6 (2.33 hrs @ $2.78/hr)	No feedback given L Buyer-to-Provider Feedback: 5.0
334130	07/2009 - 07/2009	Create Relevant Incoming Links to Website	$3 (1.33 hrs @ $2.00/hr)	5.0 Thanks to Me. Dan Myers, he is an excellent buyer. I am keenly interested to work with him in his future project. L Buyer-to-Provider Feedback: 5.0
341296	07/2009 - 07/2009	Create Relevant Incoming Links to Website	$25 (5.67 hrs @ $4.44/hr)	5.0 It is great experience to work with Beth Snaper..... L Buyer-to-Provider Feedback: 5.0
298479	04/2009 - 04/2009	Combine 3 query into 1 - Keep it simple	$1 (fixed-price)	5.0 I would like to work with you. L Buyer-to-Provider Feedback: 5.0
276594	03/2009 - 03/2009	Need Clear Instructions for Website Access	$7 (fixed-price)	No feedback given L Buyer-to-Provider Feedback: 5.0
250558	03/2009 - 03/2009	Craigslist Poster	$4 (2.00 hrs @ $2.00/hr)	5.0 I'm very glad to work with Beth, she's nice to work with, and a good buyer, thanks a lot! L Buyer-to-Provider Feedback: 5.0
260594	03/2009 - 03/2009	Virtual Admin - Assorted Tasks - Virtual Assistant	$7 (3.17 hrs @ $2.34/hr)	5.0 It was great working with Mr.Dan.Got clear cut requirements and got clarifications as and when it is required.Looking forward to work with him again. L Buyer-to-Provider Feedback: 5.0
269263	03/2009 - 03/2009	Virtual Admin - Assorted Tasks - Virtual Assistant	$2 (0.33 hrs @ $5.19/hr)	5.0 BethSnaper motivated me to get more opportunities from odesk by giving an initial work to me. I thank BethSnaper for provided opportunity and hope ... L Buyer-to-Provider Feedback: 5.0
280816	03/2009 - 03/2009	Virtual Admin - Assorted Tasks - Virtual Assistant	$5 (2.00 hrs @ $2.35/hr)	5.0 It's a great privilege to work for bethsnaper! Dan is such a pleasant manager. He is highly knowledgeable, very accomodating and encour... L Buyer-to-Provider Feedback: 5.0
245688	03/2009 - 03/2009	PHP MySQL programmer to create input boxes - easy	$9 (4.50 hrs @ $2.08/hr)	5.0 Excellent Buyer!!! Project specs were very precise. Provided everything I need it and answered questions promptly. I look forward to working with D... L Buyer-to-Provider Feedback: 5.0
255867	03/2009 - 03/2009	PHP MySQL programmer to create input boxes - easy	$6 (3.50 hrs @ $1.67/hr)	5.0 L Buyer-to-Provider Feedback: No feedback given
73743	03/2009 - 03/2009	Need Clear Instructions for Website Access	$2 (fixed-price)	5.0 i am looking forward to working with you again. cheers!! L Buyer-to-Provider Feedback: 5.0
184263	03/2009 - 03/2009	PHP MySQL programmer to create input boxes - easy	$7 (2.00 hrs @ $3.46/hr)	5.0 Very Cooperative. Great Buyer to work with. Thanks L Buyer-to-Provider Feedback: 5.0
288995	03/2009 - 03/2009	PHP MySQL programmer to create input boxes - easy	$17 (5.17 hrs @ $3.33/hr)	5.0 Dan is an excellent manager that Ive worked in this project. He gave me all the details that I need completely and clearly. L Buyer-to-Provider Feedback: 5.0
162253		PHP MySQL programmer to create input boxes - easy	$1	5.0 Although this ended up being a short project, I found Dan to be flexible and easy to work with. I would have no problem working with him agai... L Buyer-to-Provider Feedback: 5.0

Title	Name	Initiated By	Date
GRAPHIC DESIGNER-WEB MASTER-WEB DESIGNER-DEVELOPER-SEO	Thomas Johnson	Provider	April 3, 2009
Web a desktop applications PHP/visual net/sql server/crystal reports	Alan Claros	Provider	April 4, 2009
PHP•MySQL•JOOMLA•WORDPRESS•JAVA•.NET•MSSQL•HTML•CSS ≈ PRO	David Tuan	Provider	April 4, 2009
Experienced C/C++, Java, PHP/MySQL programmer	Andrey Pasyukov	Provider	April 4, 2009
Certified PHP, MySQL, AJAX, Wordpress and CMS Developer	Waqas Mushtaq	Provider	April 4, 2009
Senior web developer with PHP,MySQL, HTML, AJAX skills	Peter S.	Provider	April 4, 2009

PHP Programmers

MySQL