Welcome Guest, Not a member yet? Register   Sign In
Search Results
    Thread: How to show date rows equals current date?
Post: RE: How to show date rows equals current date?

Two thumbs up sir, the code now working smoothly. Thank you a lot. I hope in the future if I need some help I can find you. God bless you more as you are very generous to others.
20,015 Views
36 Replies
03-08-2019, 09:22 AM
jelz2018
    Thread: How to show date rows equals current date?
Post: RE: How to show date rows equals current date?

I'm having problem adding it. It gives me error. I added it after the last close parenthesis.
20,015 Views
36 Replies
03-07-2019, 10:08 PM
jelz2018
    Thread: How to show date rows equals current date?
Post: RE: How to show date rows equals current date?

The code is now perfectly working sir without any error. One last hit sir, do I need to put an (AND) if let's say I will add another condition like if 'approved' column will be equal to 1 which approv...
20,015 Views
36 Replies
03-07-2019, 07:43 PM
jelz2018
    Thread: How to show date rows equals current date?
Post: RE: How to show date rows equals current date?

This is the result when running the 2nd code
20,015 Views
36 Replies
03-07-2019, 12:48 AM
jelz2018
    Thread: How to show date rows equals current date?
Post: RE: How to show date rows equals current date?

Hello sir this the result when running the first code
20,015 Views
36 Replies
03-07-2019, 12:45 AM
jelz2018
    Thread: How to show date rows equals current date?
Post: RE: How to show date rows equals current date?

Thanks sir for assisting me on this one I really appreciate it.
20,015 Views
36 Replies
03-06-2019, 10:44 PM
jelz2018
    Thread: How to show date rows equals current date?
Post: RE: How to show date rows equals current date?

Sir the code is working without error now, but still not recognizing date range. eg March 6-8, 2019.
20,015 Views
36 Replies
03-06-2019, 10:14 PM
jelz2018
    Thread: How to show date rows equals current date?
Post: RE: How to show date rows equals current date?

I got this error sir PHP Code: -- Error: Every derived table must have its own alias --
20,015 Views
36 Replies
03-06-2019, 09:00 PM
jelz2018
    Thread: How to show date rows equals current date?
Post: RE: How to show date rows equals current date?

No it's okay sir, I'm really thankful for helping me on this. It's highly appreciated.
20,015 Views
36 Replies
03-06-2019, 08:57 PM
jelz2018
    Thread: How to show date rows equals current date?
Post: RE: How to show date rows equals current date?

PHP Code: -- select count(employee_id) as count from (select employee_id,year,month,      case when LOCATE('-',multiple) > 0 then substring(multiple,1,locate('-',multiple) - 1)      else multip...
20,015 Views
36 Replies
03-06-2019, 08:55 PM
jelz2018
    Thread: How to show date rows equals current date?
Post: RE: How to show date rows equals current date?

Sir php_rocs this shows when I use the codes. PHP Code: -- MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version f...
20,015 Views
36 Replies
03-06-2019, 07:52 PM
jelz2018
    Thread: How to show date rows equals current date?
Post: RE: How to show date rows equals current date?

salain Wrote: (03-05-2019, 11:22 PM) -- Hi, I would suggest you change the structure of your table to have 2 date columns (start_date and end_date). This way you can use simple date functions fr...
20,015 Views
36 Replies
03-06-2019, 01:14 AM
jelz2018
    Thread: How to show date rows equals current date?
Post: RE: How to show date rows equals current date?

I need all the days included in the date range sir. Like for example if an employee leave let say March 7-9, 2019 he will be on the dashboard for days 7,8 and 9. I'm ok which one you will suggest sir ...
20,015 Views
36 Replies
03-05-2019, 06:59 PM
jelz2018
    Thread: How to show date rows equals current date?
Post: RE: How to show date rows equals current date?

It's working sir but not working in date ranges. I don't know how to make it work. I tried to file a leave with date range eg. March 5-6, 2019 not working.
20,015 Views
36 Replies
03-04-2019, 05:32 PM
jelz2018
    Thread: How to show date rows equals current date?
Post: RE: How to show date rows equals current date?

And also do the multiple column will be recognized by the system as the day column?
20,015 Views
36 Replies
03-03-2019, 06:48 PM
jelz2018
    Thread: How to show date rows equals current date?
Post: RE: How to show date rows equals current date?

php_rocs Wrote: (03-02-2019, 07:20 PM) -- @jelz2018, Combining them isn't the problem.  I noticed in your example image that you had a date of 11-13, that is going to be a problem.  I do have a su...
20,015 Views
36 Replies
03-03-2019, 06:30 PM
jelz2018
    Thread: How to show date rows equals current date?
Post: RE: How to show date rows equals current date?

I need your help about this.
20,015 Views
36 Replies
03-02-2019, 07:00 PM
jelz2018
    Thread: How to show date rows equals current date?
Post: RE: How to show date rows equals current date?

php_rocs Wrote: (03-01-2019, 07:23 AM) -- @jelz2018, What are the field names for the Month, Day and Year?  This will be helpful in figuring out how the query statement should be written. -- The fi...
20,015 Views
36 Replies
03-01-2019, 05:43 PM
jelz2018
  Question Thread: How to show date rows equals current date?
Post: How to show date rows equals current date?

We have a human resource management system that need some modifications. I'd like to show all personnel on leave using the date stamp. PHP Code: --
20,015 Views
36 Replies
02-28-2019, 07:35 PM
jelz2018
    Thread: Chronological order of data base on the date
Post: RE: Chronological order of data base on the date

Sir it's working now perfectly I just forgot to remove $i++ after I remove it it's working perfectly. I'm very thankful to you sir. God bless you.
7,441 Views
12 Replies
12-09-2018, 07:28 PM
jelz2018

Theme © iAndrew 2016 - Forum software by © MyBB