Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. waubain

    Reset cumulative sum to zero on every year

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

    Reset cumulative sum to zero on every year

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

    Reset cumulative sum to zero on every year

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

    Reset cumulative sum to zero on every year

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

    mysqli_multi_query not not returning any results

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

    mysqli_multi_query not not returning any results

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

    Show rows results on same row when Group BY fields

    That did the trick. Thank you for your help.
  8. waubain

    Show rows results on same row when Group BY fields

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

    Show rows results on same row when Group BY fields

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

    First image in slide gallery not showing - Uncaught TypeError: slides[(slideIndex - 1)] is undefined

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

    First image in slide gallery not showing - Uncaught TypeError: slides[(slideIndex - 1)] is undefined

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

    Convert Indexed Multidimensional Array to Multidimensional Array with Key Value pair

    Perfect! Thank you.
  13. waubain

    Convert Indexed Multidimensional Array to Multidimensional Array with Key Value pair

    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...
    • waubain
    • Thread
    • Replies: 2
    • Forum: PHP
  14. waubain

    Images not loading on AJAX call

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

    Images not loading on AJAX call

    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...
    • waubain
    • Thread
    • Replies: 3
    • Forum: PHP
  16. waubain

    3 state slider toggle switch - move slider to state when hover

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

    id tag not loading new data with new ajax call

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

    id tag not loading new data with new ajax call

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

    id tag not loading new data with new ajax call

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

    Prevent user from getting a 404 error if click on a hover text displaying a hidden image.

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

Part and Inventory Search

Back
Top