Find Jobs
Hire Freelancers

Write a PHP/MySQL query for a search field on a web page

$10-30 AUD

Completed
Posted almost 10 years ago

$10-30 AUD

Paid on delivery
I'm working on a PHP/MySQL web database project and I need a bit of help with fetching records from the database. The database stores people's names, with the following fields: known_as (what the person may be known as ) given_names (person's given names) surname (a display surname) surname_1 (first single surname) surname_2 (second single surname) surname_3 (third single surname) surname_4 (fourth single surname) surname_alias (alias surname) entry (text) url I need to write a MySQL query to do the following after a user has done a web search on this database, then print the results out on a web page using PHP: Select any records where (surname, surname_1, surname_2, surname_3, surname_4 or surname_alias) is LIKE 'search_query'. If records exist, it should display the surname that matched the search_query (from any of the surname fields above), then the person's given name and known as name, and it should be ordered by the matched surname field, then the given name field (as a hyperlink pointing to the 'url' field). Let me know if you have any questions about this task, thanks. I'm not looking to build a whole system, I just want the correct MySQL query and PHP code to display that results from the above scenario, thanks.
Project ID: 5914621

About the project

3 proposals
Remote project
Active 10 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
Awarded to:
User Avatar
Hi Good day I am ready to help you right away. Please see my past projects. Looking forward to hear from you. Thanks Rinsad
$34 AUD in 1 day
4.9 (352 reviews)
7.4
7.4
3 freelancers are bidding on average $56 AUD for this job
User Avatar
Hi , We have 40+ skilled web designer & development team, so please give few minutes for technical discussion of your requirement. Waiting for your reply & chance for further discussion.
$24 AUD in 1 day
5.0 (4 reviews)
0.4
0.4

About the client

Flag of AUSTRALIA
Carnegie, Australia
5.0
51
Payment method verified
Member since Nov 29, 2012

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.