[SOLVED] MySQL query for time chart |
2/3/2021 20:23:34 | |
| PHPRunner General questions | ||
|
D
DealerModules authorDevClub member
I have a field called 'datepromised' that has data like:
|
||
|
N
|
Nir Frumer 2/4/2021 |
|
hi |
|
|
|
Sergey Kornilov admin 2/4/2021 |
|
What Nir says, you need some sort of a temporary/additional table that would contain all 24 hours. Then you LEFT JOIN the results of your query with this table and those entries that don't have a value will have NULLs in the results. |
|
|
D
|
DealerModules authorDevClub member 2/4/2021 |
|
Thanks Nir and Sergey. |
|