Simple MySQL query and One Simple PHP code

₹100-400 INR / hour

Dokončeno

Zveřejněno

před více než 5 roky

₹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

IČ projektu: 18277669

O projektu

7 nabídky

Vzdálený projekt

Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

Uděleno:

@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 v 40 dnech

5,0

(27 recenze)

5,2

7 freelanceři nabízejí v průměru ₹147 INR/hodinu za tuto práci

@techshomez

I will get it done in less than 1 hour..

₹100 INR v 1 dni

5,0

(4 recenze)

3,9

@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 v 1 dni

5,0

(7 recenze)

3,0

@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 v 1 dni

0,0

(0 recenze)

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 v 24 dnech

0,0

(0 recenze)

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 v 10 dnech