Find Jobs
Hire Freelancers

Wordpress Custom Field Parameter

$5-10 USD

Closed
Posted about 14 years ago

$5-10 USD

Paid on delivery
Hi there, I have a website built on wordpress. I am using a custom field to query my database for product information. As my custom field query changes on every page I would like to be able to combine 2 custom fields to make the 'final' query. I would like to have a master custom field that would ideally be held in an include file. Then a second custom field would be used to populate the variable data within the master. ## Deliverables Here is the example custom field I am currently using: select p.*, m.*, d.* from datafeeds as d, products as p left outer join meta as m on [login to view URL] = [login to view URL] where p.datafeed_id = [login to view URL] and ((match([login to view URL]) against ('+brief' in boolean mode)) and (match([login to view URL]) against ('+lepel +bikini' in boolean mode)) or ((match([login to view URL]) against ('+lepel' in boolean mode)) and [login to view URL] like '%bikini%' or (match([login to view URL]) against ('+bikini' in boolean mode)) and [login to view URL] like '%lepel%')) order by p.display_price asc limit 2000 Where the word "lepel" is the variable that will change on every page. I need a master custom field that can be altered from one location, thus a master, something like this: select p.*, m.*, d.* from datafeeds as d, products as p left outer join meta as m on [login to view URL] = [login to view URL] where p.datafeed_id = [login to view URL] and ((match([login to view URL]) against ('+brief' in boolean mode)) and (match([login to view URL]) against ('+CustomField2 +bikini' in boolean mode)) or ((match([login to view URL]) against ('+CustomField2' in boolean mode)) and [login to view URL] like '%bikini%' or (match([login to view URL]) against ('+bikini' in boolean mode)) and [login to view URL] like '%CustomField2%')) order by p.display_price asc limit 2000 And I can the specify the 2nd custom query on each page individaully and they will be pulled into the master custom field.
Project ID: 3130509

About the project

Remote project
Active 14 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED KINGDOM
Truro, United Kingdom
5.0
87
Payment method verified
Member since Mar 5, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.