Terminé

Finish SQL query

Hi

we need an experianced SQL coder to finish a query for us.

the query:

select *

from exp_category_posts

inner join exp_weblog_titles

on exp_category_posts.entry_id = exp_weblog_titles.entry_id

where exp_category_posts.cat_id IN (43,65) AND

[url removed, login to view] LIKE "%Woolwich%"

The variables "43","65" and "Woolwich" are pulled in from form variables. the query brings back all records that have cat_id 43 or 65. But what i need is for the query to return all results that have cat_id= 43 AND 65.

also sometimes only one variable is passed. depending on what the user searched.

i will provide you with database access or a SQL dump

feel free to ask any questions

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

must work on all versions of internet explorer and firefox on both pc and mac

Compétences : CSS, Ingénierie, MySQL, PHP, Architecture Logicielle, Tests de Logiciels

en voir plus : what is package in sql, hire a sql coder, SQL Query, sql select, access sql query, sql query access, query query, access finish, access web query, sql questions, site query form, return query database php, ready php query form, sql query access database, sql coder, web query form, finish access, access database mac, access 2007 sql, finish software

Concernant l'employeur :
( 12 commentaires ) United Kingdom

Nº du projet : #3510043

Décerné à:

bgeorge

See private message.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(247 Commentaires)
6.5

20 freelance font une offre moyenne de $13 pour ce travail

phpguru2012

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(208 Commentaires)
6.5
baburam

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(100 Commentaires)
5.5
SajidYousuf

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(16 Commentaires)
4.5
dbasolutionsvw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(16 Commentaires)
4.3
nicolasi

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(18 Commentaires)
4.2
vw6742929vw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(7 Commentaires)
3.6
technopirate

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(7 Commentaires)
3.7
shockeruvw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(25 Commentaires)
3.4
srisavw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(9 Commentaires)
3.3
midavik

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(6 Commentaires)
3.5
RushDevTeam

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(10 Commentaires)
3.2
vw2216359vw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(10 Commentaires)
2.9
devquote

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(9 Commentaires)
2.3
mevtho

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(3 Commentaires)
1.8
shpala

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(3 Commentaires)
1.4
vw6764939vw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(6 Commentaires)
0.8
chunlinyao

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(2 Commentaires)
0.9
jeffintampa

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)
0.0
jfurr

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0