Use brackets to group the OR statements.
mysql_query("SELECT * FROM Drinks WHERE email='$Email' AND (date='$Date_Today' OR date='$Date_Yesterday' OR date='$Date_TwoDaysAgo' OR date='$Date_ThreeDaysAgo' OR date='$Date_FourDaysAgo' OR date='$Date_FiveDaysAgo' OR date='$Date_SixDaysAgo' OR date='$Date_SevenDaysAgo')");
You can also use IN
mysql_query("SELECT * FROM Drinks WHERE email='$Email' AND date IN ('$Date_Today','$Date_Yesterday','$Date_TwoDaysAgo','$Date_ThreeDaysAgo','$Date_FourDaysAgo','$Date_FiveDaysAgo','$Date_SixDaysAgo','$Date_SevenDaysAgo')");
Related Posts:
- How to correctly submit a search form and display the result in an independent page
- Long running queries
- Database SQL query error
- Deprecated: mysql_connect()
- is it possible to run some php code within a wordpress page?
- Query both first_name and last_name from wp_usermeta at the same time
- How to use update and delete query in wordpress
- How to implement WP_List_Table? WP_List_Table giving array instead of a value in listing table
- How to add query vars with paginated URLs?
- WordPress will not operate correctly
- How to Join two tables from separate databases within WordPress
- simple wordpress ajax plugin not working when not logged in
- MySQL query performed 4 times inside loop
- Show only one post for each author ( Page loads too slow )
- Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
- Install will not load: PHP does not have MYSQL installed
- Insert post without actions/hooks
- Import 10,000 Users into WordPress WITH a specific ID for each user
- Modern Tribe Calendar wp-query with meta query not working at all
- WP database error for comments_popup_link()
- if statement on database query
- Is the regular ajax request method safe or I should use admin-ajax.php?
- Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
- How to get the post_id from postmeta
- WordPress Ajax Custom Query – High CPU LOAD
- Insert all post IDs in new database table
- Styling images coming from another blog
- register_activation_hook isn’t adding table to DB
- Is the outdated PHP mysql extension a requirement for WordPress 4.6?
- Query String being Removed Creating a Pagination Issue within a Custom Plugin
- Ajax $wpdb not returning table data
- Converting MYSQL to WordPress $WPDB
- Custom Plugin For Converting CSV To MySQL
- Why is variable not working on custom sql query using wpdb?
- Get WooCommerce product details and transfer them to a custom DB table
- Checking for new message using AJAX and PHP. Server overload?
- How can I export posts with featured images, without download them
- What is a valid parent for get_terms()?
- Filter Select results based on selection
- mysql query from wordpress page using custom table
- How to check if a meta value has already been assigned to any user?
- Calculating a large number of MYSQL queries as customshort codes, slow
- Sum the total amount of a specific product purchased per user and display in table
- wp query foreach deleting record returning only first or last item
- inserting a post from an extern php file but post content doesn’t show on wp site
- Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
- $wpdb->wp_users returning empty value for
- $Wpdb post meta query is not working with mutliple meta keys and values? [closed]
- php include not working in custom page
- Make a database query using WordPress
- Force Users To Relogin
- Basic wpdb update question
- A $_POST should occur when submit form but is not?
- Pull MySQL data from multiple tables and merge into 1 PHP array
- Using CFDB7 vs Custom MySQL Database [closed]
- Using wordpress function to retrieve data
- form $_post action value gets truncated after it passes through two forms
- Adding data to custom wordpress database table
- Add row to custom database Table and delete all rows older than 1 day
- select a single val though a table in wordpress
- making php value numeric
- populate select options from extra mysql table data
- Compare current post Category in select menu
- Removal of all posts content in bulk, keeping the posts itself
- How to store checkbox data for individual users?
- Please help! I have a problem with getting wordpress databas
- How to run complex query using PHP
- Usermeta data unserialize, extract and display in table in WordPress
- Conditional formatting on data fetched from MYSQL
- Can I split a huge wp_postmeta table across different databases or servers?
- I can’t separate the array by commas
- WordPress mysql deos not work with php7
- How can i limit the number of posts to the most recent 6 in my query?
- Reload page with a different shortcode when a user selects from a dropdown
- Error inserting into custom table – Object of class wpdb could not be converted to string [closed]
- WP + MySql db / PHP
- The plugin generated 225 characters of unexpected output during activation
- Insert data from form to database
- append data to mysql table via submit button coded in php – not working
- WordPress select query issue
- (Who to follow) Twitter widget
- How to do a MySql query in WordPress?
- Add two or multiple functions in WordPress Post or Page
- How can I display a query in a page?
- Send data from plugin to external database
- How to properly send many mysql queries via php and what happens with ajax requests after they are sent?
- Conditional statement within WP SQL query
- How to set max users to 17.000
- Passed variable gets undefined variable error on insert on next page
- directorypress theme error mysql_error() [closed]
- How to set up an auto delete post?
- two wordpress sites, two themes, one database, same content
- Cannot Upload Custom Header Image into WordPress Dashboard
- Custom query_posts() parameter
- MySQL update text field with ‘
- Predefine Magazine Style Layouts
- Parse error: syntax error, unexpected ‘}’ in C:\xampp\htdocs\admin\products.php on line 148 [closed]
- How to set variable to specific field when querying
- How to get a database field value from a WordPress table? [closed]
- Error resetting database index using ALTER TABLE in $wpdb->query