Psycho

There could be any number of reasons why - many that have nothing to do about technology, but with organization politics and/or division. For example, you may have different groups responsible for the "desktop" vs. "mobile".
 
Plus, when mobile first became a major factor, responsive design was not at the forefront. It was all about the phone since tablets were still gaining momentum. Thus the goal was to support the desktop and phones - not everything in between. it was quicker to get an adaptive rewrite to production. Also, responsible web design requires a unique skillset for which there was not a huge amount of expertise initially.
 
Once the adaptive web designs were done to meet the immediate need, there was less of a priority to go back and rewrite once again to be responsive. So, the early mobile adopters may be slower to responsive.
 
Lastly, many of the companies you cite have specific mobile applications. Many sites try to push mobile users to install their mobile apps instead of expanding their generic web content to be optimal for small displays.

@SamuelLopez:
 
Are there more than just the two statuses? If not, you should change the field to a Boolean. E.g. name the field "passed" and use 1 (TRUE) to indicate passed and 0 (FALSE) to indicate not passed.
 
@Barand,
 
Correct me if I am wrong, but I don't think the IF() statements are needed - just the conditions. A condition will resolve to either TRUE (1) or FALSE (0). So, this should work as well:
 
 
SELECT projectid as project       , SUM(Status_ID=1) as passed      , SUM(Status_ID=2) as failed FROM tbltesttransactions GROUP BY projectid

I gave you a complete, correct answer. But, since you apparently didn't understand it you dismissed it. What you are trying to do (include the URLs in the conditional logic) is a poor implementation. If you ever need to add/edit/remove any of the URLs used for this purpose you would need to modify the logic. Instead, I gave you a solution that allows you to modify the conditions (i.e. the URLs) without ever having to touch the logic. All you would ever need to do is modify the array "$admin_urls" to add/edit/delete any URLs you want used for the conditional check and the logic will work.
 
And simple does not mean less lines of code - it typically means more lines. I can cram a whole bunch of conditions, loops, whatever onto a single line. That makes it more complicated to read, debug, edit. A simple solution is one that removes complexity. Usually it means each line of code has a specific purpose.
 
EDIT: The only flaw I see in what I provided was that I read the logic as wanting to see if the session value was in the list of tested URLs. I now see that you wanted to verify it was not in that list of values. Simple enough change
 
//List of admin urls to test for $admin_urls = array('http://www.golden-wand.com/Pages/admin.php', 'http://www.golden-wand.com/Pages/admin-test.php');   //One simple if() condition if($_SESSION['admin']=='1' && !in_array(strtolower($_SESSION['url']), $admin_urls)) {     echo "<input type=\"button\" value=\"Admin Page\" class=\"button hvr-wobble-skew\" onclick=\"location.href='http://www.golden-wand.com/Pages/admin.php'\">\n"; }

Try this:
 
 
<?php   //Define the number of columns allowed $max_columns = 3;   //Query the data $query = "SELECT ID, FirstName, LastName, MonthEx FROM Members ORDER BY LastName"; $result = mysqli_query($Garydb, $query);   //Put results into an array $rows = array(); while($rows[] = mysqli_fetch_array($result, MYSQLI_ASSOC)) {}   //Determine the number of rows $max_rows = ceil(count($rows) / $max_columns);   //Separate data array into chunks for each column $data_chunks = array_chunk($rows, $max_rows);   //Generate HTML output (into a variable) $output = ''; //Iterate over the array chunks while not empty while(count($data_chunks[0])) {     //Open new row     $output .= "<tr>\n";     //Get next record from each chunk     foreach($data_chunks as &$chunk)     {         //Remove the first element off of the current chunk         $data = array_shift($chunk);         if(empty($data)) { continue; }         //Create the          $output .= "<td>{$data['FirstName']} {$data['LastName']}</td>";         $output .= "<td><a href='update.php?update={$data['ID']}'>EDIT</a></td>";         $output .= "<td><a href='delete.php?delete={$data['ID']}'>DELETE</a></td>\n";;     }     //Close the row     $output .= "</tr>\n"; }   ?> <html> <head></head>   <body>   <table border='1'>   <?php echo $output; ?> </table>   </body> </html>

You only need to include a link to a txt file if you are wanting us to run some specific tests on your site. You do not need it to ask a question about some code.
 
You may have a failure on both conditions:
 
if($_SESSION['admin']==='1'){  
The three equal signs means it has to match the value and the type - i.e. it has to be a string value of one. A numeric value of 1 will not pass the condition.
 
On the second condition it will never match because "pages" does not equal "Pages"

The timezone offset is basically the timezone. The timezone offset is the difference from the the user's timezone and UTC time. So, you can calculate a time in the user's timezone based on the offset. But, you need to ensure the the times you are storing are in UTC time. Then, when you retrieve the time (from the database) modify it to the user's timezone.

You didn't answer my questions, so why should I take the time to answer yours? I don't see how the joined date can be used to know if a user has paid their fees (even though the field doesn't even state that it is a joined date). That date only tells you, presumably, when they joined. So, what data are you storing to know when a user has paid the fees? Are you reducing the fees field when they make payment? That's a poor way to do it since you would have no history of exactly when they were paid and how much they paid.
 
But, making a HUGE assumption that the fees field is the outstanding fees (which is a terrible process), this query would get you the list of users who have an outstanding fee and their joined date was > 30 days ago.
 
SELECT id, fname, name, fee, `date`   FROM users   WHERE fees > 0     AND date < CURDATE() - INTERVAL 30 DAY  
Or, if you want ALL the users to display in a list and show specific notices next to the ones who's fee is pending, you could either add that logic to the output processing OR you could add a dynamic field to the query result.
 
SELECT *,        (`date` < CURDATE() - INTERVAL 30 DAY and fees > 0) as fee_due   FROM `users`  
But, if you are doing as I suspect, it is a poor implementation.

The problem is not the query. The problem is likely the logic in displaying the output. I expect you have a loop to process all the records in the result set. You need to have logic so the first record in the result set display the post content and the first comment (if it exists). Each subsequent record in the result set should only display the comment.
 
But, there is a problem with the query. It uses a normal JOIN. So, if there are no records in the comments table, the post won't be returned either. This needs to use a LEFT JOIN so all relevant posts will be returned - even if they do not have comments.

There's quite a few things which need to be "fixed" in this code, not the least of which is the password verification. But, we can start with that.
 
When a user creates their password, use the function password_hash() to generate a hash value and save it to the DB. Then, when a user attempts to log in, run a DB query to find the record matching just the username. Take the hash value from the DB and the password the user provided on the login and use the password_verify() function to see if the password is valid.
 
FYI: Font tags have been deprecated for over a decade!

Give this a try
 
<?php       if (!empty($results))     {         foreach ($results as $row) {             echo "<tr>\n"             echo "  <td>{$row['user_nome']}</td>\n";             echo "  <td>{$row['user_email']}</td>\n";             echo "  <td>{$row['user_tel']}</td>\n";             echo "  <td><a data-toggle='modal' data-id='{$row['user_id']}' class='open-AddDialog btn btn-sm btn-danger center-block' href='#myModal'>Validar</a></td>\n";             echo "</tr>\n"         }     }   ?>

sigmahokies,
 
You need to understand that just because something works does not mean it is correct. I can store a user's password in plain text in the database and it will work, but is absolutely wrong. Yes you "can" pass all of the data and it will work. But, it is not correct and will eventually cause you problems either in this project or another one some time later if you do the same thing. You should treat ALL user supplied data as "dirty". It could be that something is corrupted unintentionally or, worse, it malicious data intended to do harm.
 
For your page above, it should only accept the ID for the process of setting up the form for edit. The code should do a SELECT query to get the current data instead of relying upon data submitted by the user via $_GET.
 
Here is a quick rewrite of your code in a more logical format. This is not what I would consider complete, but is more complete than the current code and shows an example of a logical flow. There may be some minor errors in syntax as I did not test it.
 
 
<?php   $Garydb = mysqli_connect("XXXXX","XXXXX","XXXXX") or die("Could not connect MySQL Database"); mysqli_select_db($Garydb, "XXXXX") or die("Could not find a Database");   $response = '';   if(isset($_GET['id'])) {     //User passed the ID of a record to be updated     //Get current values to populate form field     $id = intval($_GET['id']); $query = "SELECT First_name, Last_name, Locations, birthdate, Email          FROM  WHERE ID = {$id}";     $result = mysqli_query($Garydb, $query); if(!mysqli_num_rows($result)) {         //No record matching the passed ID         $response = 'Error: No record matching requested id.'; } else     {         //Define variables for form fields from current DB result         $row = mysqli_fetch_assoc($result);         $first_name = $row['first_name'];         $last_name  = $row['last_name'];         $locations  = $row['locations'];         $birthdate  = $row['birthdate'];         $email      = $row['email'];     } } elseif ($_SERVER['REQUEST_METHOD']!='POST') {     //User posted a form if data to be updated for a record     $id         = intval($_POST['id']);     $first_name = trim($_POST['first_name']);     $last_name  = trim($_POST['last_name']);     $locations  = trim($_POST['locations']);     $birthdate  = trim($_POST['birthdate']);     $email      = trim($_POST['email']);       if ($id && $first_name && $last_name && $locations && $birthdate && $email) {         //All the posted value are not empty/zero         //Should really have better validation logic         $update = "UPDATE Members           SET FirstName = '$first_name',                         LastName  = '$last_name',                         Locations = '$locations',                         birthdate = '$birthdate',                         Email     = '$email'   WHERE ID = $id";         if(!mysqli_query($Garydb, $query)  || )         {             //Query failed             $response = 'Error: Unable to update record.';         }         elseif(!mysqli_affected_rows($link))         {             //No records were updated. Record may have been deleted or ID manipulated             $response = 'Error: No records updated.';         }         else         {             $response = 'Record was updated.';         }     } else {         //Not all fields have values or non-zero    $response = 'Error: Missing data required for update.'; } } else {     //No POST or GET data submitted     $response = 'Error: No data received.'; } ?> <!doctype html> <html> <head> <title>Update Members info</title> </head> <body> <?php       //If there was a response, show it. Else show form.     if($response)     {         echo "<div style=\"color:red;\">{response}</div>";         //Could add a link to go back to a listing page or somewhere appropriate     }     else     {   ?>   <form action="insert.php" method="POST"> <table> <tr> <td>Identify Number:</td> <td><?php echo $id ?><input type="hidden" name="id" value="<?php echo $id; ?>"</td> </tr> <tr> <td>First Name:</td> <td><input type="text" name="first_name" value="<?php echo $first_name; ?>"></td> </tr> <tr> <td>Last Name:</td> <td><input type="text" name="last_name" value="<?php echo $last_name; ?>"></td> </tr> <tr> <td>Locations:</td> <td><input type="text" name="locations" value="<?php echo $locations; ?>"></td> </tr> <tr> <td>birthdate:</td> <td><input type="text" name="birthdate" value="<?php echo $birthdate; ?>"></td> </tr> <tr> <td>Email:</td> <td><input type="text" name="email" value="<?php echo $email; ?>"></td> </tr> <tr> <td colspan="2"><button type="submit">Update</button></td> </tr> </table> </form> <?php     } ?> </body> </html>