USE the OR attribute

Tells the query to look for this OR that value

SELECT *
FROM status_options_various
WHERE menu_group = 8 (this)
OR menu_group = 9 (that)

This will combine the output together and show both


To select values from 2 different fields use the AND attribute - Select This AND This

SELECT *
FROM status_options_various
WHERE menu_group = 8 (this)
AND menu_tax = 9 (this)

SELECT marketing_email, COUNT(marketing_email) 
FROM Email_Marketing 
GROUP BY marketing_email 
HAVING COUNT(marketing_email) > 1;

This will count and display duplicate records and the individual totals for each duplicate

if you have a field that show certain values multiple times yet you only want to know those values not all of the same values in the field then use the SELECT DISTINCT

lets say you have 10 records in a table have a column field - category and in that field 5 are RED and 5 are Blue values and you want a list of the type of values used then use the SELECT DISTINCT  to show you just the different values - Red or Blue in the category field and not list all the values

SELECT DISTINCT category (this is the field)
FROM models (this is the table)


SELECT DISTINCT it_sub_cat_name
FROM it_sub_category
ORDER BY it_category_id ASC

is how you'd write the mysql

Facebook like button

Step 1: Include the JavaScript SDK on your page once, ideally right after the opening body tag.

<div id="fb-root"></div>
<script async defer crossorigin="anonymous" src="https://connect.facebook.net/en_US/sdk.js#xfbml=1&version=v12.0&appId=152908674906753&autoLogAppEvents=1" nonce="k2AeS07s"></script>

Step 2: Place this code wherever you want the plugin to appear on your page.

<div class="fb-like" data-href="https://www.facebook.com/imaginationtables" data-width="" data-layout="button" data-action="like" data-size="large" data-share="true"></div>

put this in the the head section


<script>
         /**
          * If browser back button was used, flush cache
          * This ensures that user will always see an accurate, up-to-date view based on their state
          * https://stackoverflow.com/questions/8788802/prevent-safari-loading-from-cache-when-back-button-is-clicked
          */
         (function () {
            window.onpageshow = function(event) {
               if (event.persisted) {
                  window.location.reload();
               }
            };
         })();
      </script>


Apple's own fix suggestion is to add an empty iframe on your page:

<iframe style="height:0px;width:0px;visibility:hidden" src="about:blank">
    this frame prevents back forward cache
</iframe>

The log image url needs to be something of this nature: https://yourweb/picture.jpg 
If the file itself is not a .png .jpg or .gif then the logo image will not display properly.

Note:
Logo Image URL - Choose an image with a maximum size of 190 pixels wide by 60 pixels high. The image will appear at the top of the order summary. We recommend providing an image that's stored on a secure (https) server.

Header Image URL - Please specify an image that I
s a maximum size of 750 pixels wide by 90 pixels high. Larger images will be cut to this size. The image you choose will appear at the top left of the payment page. We recommend providing an image only if it is stored on a secure (https) server.

In the button coding add this line for logo or header display"

 <input type="hidden" name="image_url" value="https://yourwebsite.com/assets/cart_images/logo_paypal.png" />

Here, if you want to control it through HTML: do like below Option 1:

<meta http-equiv="expires" content="Sun, 01 Jan 2021 00:00:00 GMT"/>
<meta http-equiv="pragma" content="no-cache" />
 
And if you want to control it through PHP: do it like below Option 2:

header('Expires: Sun, 01 Jan 2021 00:00:00 GMT');
header('Cache-Control: no-store, no-cache, must-revalidate');
header('Cache-Control: post-check=0, pre-check=0', FALSE);
header('Pragma: no-cache');

AND Option 2 IS ALWAYS BETTER in order to avoid proxy based caching issue.

<a href="#" title="delete" class="delete" onclick="return confirm('Are you sure you want to delete this item')">Delete [/url]

Add Bold to your button link

Had this error using Pear Mail solved it by including E_STRICT in the error_reporting - so place this at the beginning of your page code (this actually stops several different levels of error messages from appearing on your page is errors occur:

<?php
ob_start();
error_reporting(E_ALL ^ (E_NOTICE | E_WARNING | E_DEPRECATED | E_STRICT));
?>

Bold portion helps with header already sent errors by slowing things down when loading a page

http://<?php echo $_SERVER['HTTP_HOST'];?><?php echo $_SERVER['REQUEST_URI'];?>

will produce

http://yourdomain.com/thepage.php?acct=5

most likely an easier way to do this but this works too