Search results for query: *

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...

I am trying to create a 3 state toggle switch where the slider temporarily moves when the cursor hovers over the option, but returns to original state when cursor is moved away. See this link as an example: Link I found this switch example Link, but the slider only moves when the option is...

I am embarrassed to say I found the problem. I was calling the wrong php file. I was calling the original which was fixed on the current month and not the beta php file, so thus the output never changed. Although it is not working as I expected, the data does change. Thank you for trying to help.

The Status is 200 and the date listed in the "file" column matches the date on the request each time I click on the previous or next button. My PHP code works perfectly the first time loading the html page and also if I run it by itself, so I don't think it is the PHP code. I do not know...

In my retirement, I am building a local weather site. Data is loaded to a MySQL database. Everything works fine, so I wanted to add a previous and next buttons see past monthly data. The data loads on initial page loading, but when I click the previous button the date changes, but the previous...

feherke, I found the extra space and removed it and I no longer get the error. Thank you.