Simple MySQL query and One Simple PHP code

₹100-400 INR / hour

Completed

Posted

over 5 years ago

₹100-400 INR / hour

Hi! I want hire someone who can write one small query and one small function which can provide me required data in table. I have one table called number_list in which I have id, name, number and one another table called number_status in which I have id, number, start_time and end_time. I want display data in my table called name, number and Number Status (if there row in number_status (filedname end_time = empty then I want show status as online else offline). There multiple rows in number_status so I want select only recent one. I have written my question on stackover flow. [login to view URL] Max Budget is INR 100. Because I dont think its take more than 5 minutes for expert. If You have read and able to do it, Please write "fix in budget" so I can talk and hire You. Thanks

Software Architecture

Project ID: 18277669

About the project

8 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

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:

@ShilanTitaju

fix in budget Hello sir/madam, I have read and UNDERSTOOD your project requirements carefully. I also looked at your stack overflow link. Do you need to select the latest row in mysql ? I think I can help you in this matter. Regards, Shilan

₹101 INR in 40 days

5.0

(19 reviews)

4.3

8 freelancers are bidding on average ₹163 INR/hour for this job

@sfeuh

Hello; if you want you can contact me now i am available right now. i can start now if you want just contact me by chat. thank you

₹111 INR in 1 day

5.0

(3 reviews)

1.7

@prasadroy2

I will do it in Rs100 I love coding..Here are my good things that you may like: ✓ I always bid with affordable price. ✓ I Always accept payment after 100% work completed. ✓ I always used latest technology to complete your task/project. ✓ I always follow good coding standards ✓ I always deliver your work in committed time span. ✓ I have 3+ yr experience in web technology. ✓ I always offer free ssl certificate to my clients so customers can access website using https:// ✓ Always online and give support after work done because I like long time relationship with my clients. ✉ Contact Me: Thank you. Prasad R.

₹111 INR in 1 day

0.0

(0 reviews)

0.0

@devygroup

I have read your question, I think it is easy, let me solve your question, I have one table called number_list which have fields like id, name, number and one another table called number_status in which fields like id, number, start_time and end_time. I want display name, number and start_time and end_time in my one page. But there number_status have multiple row for same number so I want only select most recent row from it. I am trying query like below

₹388 INR in 24 days

0.0

(0 reviews)

0.0

@pramodhuilgol

I can do this for u, I have a good experience in this, I work in PHP & NodeJs I can help you in these domain with DB as mysql and mongoDB need help in these tech text me

₹111 INR in 10 days