sashavalentina Posted February 9, 2022 Share Posted February 9, 2022 SELECT SUM(purchase_price) as total_price FROM ordered_items WHERE payment_term = 1 AND order_display = 'SHOW'AND order_datetime >= '" . $from_date . "' AND order_datetime <= '" . $to_date . "' "; Quote Link to comment https://forums.phpfreaks.com/topic/314532-why-my-total_price-is-shown-as-null/ Share on other sites More sharing options...
requinix Posted February 9, 2022 Share Posted February 9, 2022 https://www.google.com/search?q=mysql+sum+returning+null Quote Link to comment https://forums.phpfreaks.com/topic/314532-why-my-total_price-is-shown-as-null/#findComment-1593999 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.