Simple MySQL query and One Simple PHP code

₹100-400 INR / hour

已完成

已发布

超过 5 年前

₹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

项目 ID: 18277669

关于此项目

8提案

远程项目

活跃5 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@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 在40天之内

5.0

(19条评论)

4.3

8威客以平均价₹163 INR/小时来参与此工作竞价

@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 在1天之内

5.0

(3条评论)

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 在1天之内

0.0

(0条评论)

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 在24天之内

0.0

(0条评论)

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 在10天之内