Recent content by waubain

Thanks everyone for responding. I will give these options a try.

I am not sure what you are asking, but will try again, Here is sample data. If I change the WHERE statement to fit each year of interest, it works, but there are too many years to query individually. WHERE WxDate >= '2022-01-01' ANd WxDate < '2022-08-01' DROP TEMPORARY TABLE IF EXISTS...

Sorry for the vagueness. In agriculture the cumulative Growing Degree Days (GDD) has correlation with crop growth development and emergence of certain pests. GDD can be calculated multiple ways, but the simplest is GDD = ((Max Temperature for Day + Min Temp for Day / 2) - 50(fifty is a...

I am trying to find on what date each year since 2009 when the GDD (growing degree days) is <= 1035. I can get the following to work for one year, but will not work for multiple years. I am trying to figure out how to reset the @cum = 0 for every year and then display my date result by year...

I found this link which helped. It also explains the need for mysql_multi_query to prevent sql injection. Link I don't fully understand the syntax, but I got it working. Here is a part of the code. // Create connection with variables in _your_keys.php $conn = new...

The below query was working in myphpadmin, but when I moved it to .php page it did not. I found out why and tried to use the mysqli_multi_query, but the query still returns "Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result" Can someone explain what I am doing wrong? Or is...

That did the trick. Thank you for your help.

Skip, Thanks for the reply. I only get results for ObsDate, Location, and Temp_4. The other Temp_ columns are NULL. I am using PHPadmin to test this so not sure if the problem is on my side or something else. Here is the MySQL I am using to test and the resulting table DROP TEMPORARY TABLE...

I am collecting soil temperatures at different depths. Different crops have different temperature depths. My data structure looks like this for each record for each location and depth. The data is the same for each day for this example. ObsDate: Location: (field location) Depth: (for this crop...

Feherke, thank you for the suggestions. It works as requested.

I am using the framework from this Link with changes to make it more dynamic. I display outside cam images on my weather page. There is a toggle button between Day and Month images. When the page loads I am getting an Uncaught "TypeError: slides[(slideIndex - 1)] is undefined". If either the...

Perfect! Thank you.

I have an indexed array like this Array ( [0] => Array ( [0] => 2021-07-06_18-00.jpg [1] => Tuesday Jul 06, 2021, 6:00 pm ) [1] => Array ( [0] => 2021-07-05_12-00.jpg [1] => Monday Jul 05, 2021, 12:00 pm ) [2] => Array ( [0] => 2021-07-04_12-00.jpg [1] => Sunday Jul 04, 2021...

Yes, I am getting the expected data when directly accessing both PHP files in a browser. I will give the JS forum folks a try. Thanks for responding.

I am trying to display either daily or monthly webcam images depending on the status of a toggle switch. The default is Daily when the page loads and displays today's images as it should when the page first loads. The problem is when the button is toggled, the Monthly images do not load or...