Project Detail

Write a mysql query for me

Write a mysql query for me is project number 349070
posted at Freelancer.com. Click here to post your own project.

| More

Status: Cancelled

Selected Providers: -

Budget: $30-250

Created: 11/26/2008 at 0:33 EST

Bid Count: 25

Average Bid:
$ 39

11/27/2008 at 0:33 EST

Project Creator: smickandily offline
Employer Rating: (No Feedback Yet)

Description

Hello,

I'm looking for someone who can write a mysql query for me.

I'm developing a recipe site and am looking for a way to select recipes from a database and order them based on how many of the recipe's ingredients match the ingredients of the user's pantry table.

I have four tables in my database

recipes
id, name, prep_time

ingredient_types (static list of all ingredients in the world)
id, type

ingredients (for each recipe posted a record is created for the ingredient needed)
id, ingredient_type_id, recipe_id

pantry (a table containing records of each ingredient a user has at home)
id, ingredient_type_id

I was hoping to pull recipe data using fulltext search and in the same query check how many matches each ingredient of the recipe has to the user's pantry table and then order the output of the recipe data based on the number of ingredient matches.

Query must be

Thanks,

Report Violation

Job Type

See more: data, data base, database, list, match, mysql, number, query, recipe, record, search, site, sql query, write

Messages Posted:0

If you are the project creator or one of the bidders Log In for more options

PMB

1 day

11-26-2008 03:04 EST

9.375/10
(16 reviews)

I can do this work.Pls see the PMB for details

prashant29 offline

1 day

11-26-2008 03:18 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(7 reviews)

################ Please check your PMB ##############

allandmore offline

1 day

11-26-2008 02:26 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(2 reviews)

Hello, I can do this query for you in a day. Kindest regards, sduras

rubito offline

1 day

11-26-2008 05:03 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(2 reviews)

Hi. I can do this quickly fast.Best regards Ruben

biprosaha1986 offline

0 days

11-26-2008 15:20 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(2 reviews)

Hello sir, Ready to work with you. Thanks.

jenwork offline

1 day

11-26-2008 22:39 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

Sir,Please viw PMB

abhamohunta offline

2 days

11-26-2008 03:29 EST

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

We are a team of developers with immense expertise and experience in PHP and MySql. We have developed several complex and extensive web applications in it. We are ranked top 15th on RAC and most of the projects done there are in PHP and MySql. I have read your reqts. and will be able to do a good job. Thanks Abha Mohunta Hi Technology & Services

tn69kl01 offline

0 days

11-26-2008 01:09 EST

9/10 9/10 9/10 9/10 9/10 9/10 9/10 9/10 9/10 9/10
(1 reviews)

Hi Please see PMB.

Jakester offline

1 day

11-26-2008 00:56 EST

(No Feedback Yet)

I am great with MySQL queries and not busy now!

premshankar110 offline

7 days

11-26-2008 02:32 EST

(No Feedback Yet)

hi, Please contact me withthe details. I have certifications in SQL and PL/SQL and can provide fast solution to your problems. Regards, prem

indusentp offline

1 day

11-26-2008 02:57 EST

(No Feedback Yet)

I am very good in database managment systems and developed lot of softwares with mysql

oper offline

2 days

11-26-2008 03:01 EST

(No Feedback Yet)

Hello, please check PM, thanks, oper

indikas offline

1 day

11-26-2008 04:16 EST

(No Feedback Yet)

Hi, I can write this query within a day. Regards

suchirakaru71 offline

1 day

11-26-2008 04:22 EST

(No Feedback Yet)

hi. I'm familiar with mysql and have developed this kind of trailer made software. I can help you.

Zeeshan1985 offline

1 day

11-26-2008 05:10 EST

(No Feedback Yet)

Sir, I have already written the query in MY SQL. please see the PM

tubetube offline

1 day

11-26-2008 06:34 EST

(No Feedback Yet)

I'm a DBA. i can do this job.

Tamerlan offline

0 days

11-26-2008 14:11 EST

(No Feedback Yet)

I'm expert in SQL. Please check PM.

arvindsaharkar offline

0 days

11-26-2008 09:24 EST

(No Feedback Yet)

We can provide the query within 2-3 hrs.

SalmanGhouri offline

0 days

11-26-2008 09:32 EST

(No Feedback Yet)

i am Expert in Queries,

alex397 offline

0 days

11-26-2008 09:33 EST

(No Feedback Yet)

I am ready to start.

dashmmWEBIL offline

1 day

11-26-2008 11:00 EST

(No Feedback Yet)

please see pm

vikaskumra offline

1 day

11-26-2008 11:03 EST

(No Feedback Yet)

I can do this job for you...

rwolfe716 offline

1 day

11-26-2008 13:08 EST

(No Feedback Yet)

I can have this query done for you in less than a day.

webtrode offline

1 day

11-26-2008 17:39 EST

(No Feedback Yet)

Can have it for you in an hour or less.

nimitdudani offline

0 days

11-27-2008 01:15 EST

(No Feedback Yet)

I can do this for you

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.