multiple where condition in result query

Your syntax for where is wrong it should be

$user1 = $wpdb->get_results("select product,checked_by,submit_date,unit_data,temperature_in,temperature_out,time_in, time_out,category from diary_user_form_storage  where category_name="opening" OR category_name="closing"  order by submit_date");

Related Posts:

  1. Deprecated: mysql_connect()
  2. dbDelta support for FOREIGN KEY
  3. is it possible to run some php code within a wordpress page?
  4. How to correctly submit a search form and display the result in an independent page
  5. Query both first_name and last_name from wp_usermeta at the same time
  6. How to use update and delete query in wordpress
  7. How to implement WP_List_Table? WP_List_Table giving array instead of a value in listing table
  8. Does WordPress cache get_user_meta() results?
  9. simple wordpress ajax plugin not working when not logged in
  10. Using Echo in ShortCode – Stuck
  11. MySQL query performed 4 times inside loop
  12. Show only one post for each author ( Page loads too slow )
  13. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  14. Insert post without actions/hooks
  15. Modern Tribe Calendar wp-query with meta query not working at all
  16. WP database error for comments_popup_link()
  17. Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
  18. No wp-config.php file on local install of wordpress – site still displays
  19. Use ajax to update_post_meta
  20. Insert all post IDs in new database table
  21. register_activation_hook isn’t adding table to DB
  22. Is the outdated PHP mysql extension a requirement for WordPress 4.6?
  23. What SQL / WordPress queries would need a nonce?
  24. Different database query in function.php using mysqli
  25. Query String being Removed Creating a Pagination Issue within a Custom Plugin
  26. Converting MYSQL to WordPress $WPDB
  27. Why is variable not working on custom sql query using wpdb?
  28. Get WooCommerce product details and transfer them to a custom DB table
  29. How can I export posts with featured images, without download them
  30. How to securely provide a $_POST var in WP_Query with PHP 7?
  31. Create WP_Query to search for posts by their categories or their parent/child categories
  32. What is a valid parent for get_terms()?
  33. WSoD being caused by this piece of code
  34. How to display data from custom table in wordpress phpmyadmin
  35. Calculating a large number of MYSQL queries as customshort codes, slow
  36. Update results, Before deleting the related category [closed]
  37. Sum the total amount of a specific product purchased per user and display in table
  38. Replacing mysql_escape_string in a custom plugin when moving to PHP7
  39. Weird 404 URL Problem – domain name being placed at end of urls
  40. database sent to a JSON file
  41. inserting a post from an extern php file but post content doesn’t show on wp site
  42. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  43. $wpdb->insert() does not Insert record in a table
  44. WordPress SQL injection
  45. php include not working in custom page
  46. Make a database query using WordPress
  47. Force Users To Relogin
  48. Basic wpdb update question
  49. A $_POST should occur when submit form but is not?
  50. Pull MySQL data from multiple tables and merge into 1 PHP array
  51. Using CFDB7 vs Custom MySQL Database [closed]
  52. Using wordpress function to retrieve data
  53. form $_post action value gets truncated after it passes through two forms
  54. Adding data to custom wordpress database table
  55. Add row to custom database Table and delete all rows older than 1 day
  56. select a single val though a table in wordpress
  57. making php value numeric
  58. populate select options from extra mysql table data
  59. Removal of all posts content in bulk, keeping the posts itself
  60. How to store checkbox data for individual users?
  61. WordPress low speed after migrating to new host
  62. Please help! I have a problem with getting wordpress databas
  63. How to run complex query using PHP
  64. Usermeta data unserialize, extract and display in table in WordPress
  65. Conditional formatting on data fetched from MYSQL
  66. Can I split a huge wp_postmeta table across different databases or servers?
  67. I can’t separate the array by commas
  68. WordPress mysql deos not work with php7
  69. How can i limit the number of posts to the most recent 6 in my query?
  70. Error inserting into custom table – Object of class wpdb could not be converted to string [closed]
  71. WP + MySql db / PHP
  72. The plugin generated 225 characters of unexpected output during activation
  73. Insert data from form to database
  74. append data to mysql table via submit button coded in php – not working
  75. WordPress select query issue
  76. (Who to follow) Twitter widget
  77. How to do a MySql query in WordPress?
  78. Add two or multiple functions in WordPress Post or Page
  79. How can I display a query in a page?
  80. Send data from plugin to external database
  81. How to properly send many mysql queries via php and what happens with ajax requests after they are sent?
  82. Conditional statement within WP SQL query
  83. How to set max users to 17.000
  84. Passed variable gets undefined variable error on insert on next page
  85. directorypress theme error mysql_error() [closed]
  86. How to set up an auto delete post?
  87. WordPress upload images not displaying
  88. two wordpress sites, two themes, one database, same content
  89. how to check for wordpress Query errors
  90. Cannot Upload Custom Header Image into WordPress Dashboard
  91. Custom query_posts() parameter
  92. MySQL update text field with ‘
  93. Query Concatenation
  94. Predefine Magazine Style Layouts
  95. Parse error: syntax error, unexpected ‘}’ in C:\xampp\htdocs\admin\products.php on line 148 [closed]
  96. Display total count of products in orders of a specific order status
  97. Getting invalid user ID error when creating a new user with wp_insert_user
  98. Custom form that stores data in mysql database
  99. Putting form result in my database
  100. How can I update a value of a field depending on outside source?