Thank you for watching.
I want to use the following SQL in PHP. How can I drop it and it will work without problems?
<? php Applicable SQL ?>
Corresponding source code
After uploading, the page will not work.
I think it's probably different from the description method.
What I tried
SELECT billdate, --slip date duedate, --Customer closing date (1-31) CASE WHEN duedate = 31 THEN DATE_FORMAT (billdate,'% Y year% m month') --The end is slip month = billing month WHEN duedate<31 AND DAY (billdate)<= duedate THEN DATE_FORMAT (billdate,'% Y year% m month') --Voucher date<= Voucher month = billing month WHEN duedate<31 AND DAY (billdate)>duedate THEN DATE_FORMAT (DATE_ADD (billdate, INTERVAL 1 MONTH),'% Y year% m month') --Voucher date other than the end date>Voucher month = billing The month after the month END AS monthly FROM FROM earnings JOIN customers ON customers.id = earnings.customer_id WHERE duedate>0 GROUP BY billdate, due date
I looked it up, but I didn't get caught in the part of how to drop it, so I stumbled at the beginning.
I have no knowledge about SQL.
You may have heard something strange, but if i am familiar with it, I would appreciate your help.
Answer # 1
A table that links the closing date for several years from the beginning with the start date and end date of the period
It is easiest to make it.
- i would like to know if there is a download method for old php (5640) for windows
- php - i would like to know about relative paths
- php - i want to operate the browser on the server side
- php - i would like to know in which language this voting system can be done
- php - i would like to use gpio of raspberry pi on the web
- php - [laravel] i want to pass a value from view to controller (operate the previous month and next month of the calendar with b
- php - cannot operate the database with local by flywheel
- php - i would like to send the repeated contents in form
- php - i would like to know the wordpress development procedure on site
- mysql - i would like to know the sql that calculates the total from four tables
- php - woocommerce for japan: i would like to add the day of the week to the "date format" of the shipping method
- php - a new project is created in laravel 803 i would like to create it in 830
- i would like you to explain the parts that you could not understand in the php reference book
- php - i would like to know how to get each past numerical value with "ahrefs api"
- php - i want to give a user with wordpress "editor" permission to operate some menus of "appearance> customize
- php - i want to implement an editing function i would like advice
- php - i would like to know how this code works
- i would like to know the cause of the error php
- php - how to operate an array
- php : Personal conclusion from request
- Remove duplicate names from SQL speakers, PHP
- php : How to convert SQL to Laravel request?
- php : Why the WHERE selection does not work in SQL request
- php : Checking the presence of a column in the table and multiple Like
- Fix php text encoding
- php : How to remove from the Chat table from the ID card received from the Select request?
- php : Question marks when receiving data from the base
- Output of a single record from SQL on PHP