Barand

This will set an active flag in your elements array
$res = $db->query("SELECT article_id , branch_id , article_name , 0 as active FROM article"); $Elements = []; foreach ($res as $el) { $Elements[$el['article_id']] = $el; } $activeId = 50; setActiveElement($Elements, $activeId); function setActiveElement(&$els, $id) { $els[$id]['active'] = 1; if ($els[$id]['branch_id'] != 0) { setActiveElement($els, $els[$id]['branch_id']); } } As you can see, 1, 38 and 50 are now set "active"
 
Array ( [1] => Array ( [article_id] => 1 [branch_id] => 0 [article_name] => Knowledge Base - How To [active] => 1                                                          <--------------- ) [38] => Array ( [article_id] => 38 [branch_id] => 1 [article_name] => Bugs [active] => 1                                                          <--------------- ) [46] => Array ( [article_id] => 46 [branch_id] => 0 [article_name] => Client Information [active] => 0 ) [49] => Array ( [article_id] => 49 [branch_id] => 1 [article_name] => Features [active] => 0 ) [50] => Array ( [article_id] => 50 [branch_id] => 38 [article_name] => Another Branch [active] => 1                                                          <--------------- ) [52] => Array ( [article_id] => 52 [branch_id] => 0 [article_name] => @Test [active] => 0 ) [53] => Array ( [article_id] => 53 [branch_id] => 52 [article_name] => testing [active] => 0 ) [54] => Array ( [article_id] => 54 [branch_id] => 46 [article_name] => Testing Audit [active] => 0 ) [55] => Array ( [article_id] => 55 [branch_id] => 0 [article_name] => Testing [active] => 0 ) [57] => Array ( [article_id] => 57 [branch_id] => 55 [article_name] => New Article [active] => 0 ) )

you could try using the "required" property
<select name="select" required> <option value="">Please select the level</option> <option value="Administrator">Administrator</option> <option value="License">License</option> <option value="Scorer">Scorer</option> <select>

Rearrange the array so you gather the values for each record together
$other_image = Array ( 'img' => Array ( '0' => '1526973657.jpg', '1' => '1526973661.jpg', '2' => '1526973665.jpg' ), 'path' => Array ( '0' => '../post-upload/1/', '1' => '../post-upload/1/', '2' => '../post-upload/1/' ), 'type' => Array ( '0' => 1, '1' => 1, '2' => 1 ), 'thumb' => Array ( '0' => 'thumb_1526973661.jpg', '1' => 'thumb_1526973665.jpg', '2' => 'thumb_1526973668.jpg' ) ); $record_vals = []; // values for each record to be inserted foreach ($other_image as $name => $values) { foreach ($values as $k => $v) { $record_vals[$k][$name] = $v; } } Now you have an array that you can loop through to insert the records
$record_vals = Array ( [0] => Array ( [img] => 1526973657.jpg [path] => ../post-upload/1/ [type] => 1 [thumb] => thumb_1526973661.jpg ) [1] => Array ( [img] => 1526973661.jpg [path] => ../post-upload/1/ [type] => 1 [thumb] => thumb_1526973665.jpg ) [2] => Array ( [img] => 1526973665.jpg [path] => ../post-upload/1/ [type] => 1 [thumb] => thumb_1526973668.jpg ) )

How do you know which user is logged in? You have called session_start() but I see no references to any $_SESSION variables.
 
You should be storing the ID of the user on login then using that id in your queries. (... WHERE ID = $_SESSION['userid'] ) or, better yet, use a prepared query passing the id as a parameter.
 
You will be expecting only a single profile result so why have the while() loop? A single fetch is all you need.
 
The first mention of username in that query is a column name and should NOT be in quotes. Your syntax following LIKE is also wrong.
 
Don't use a nastyfrisk (SELECT * ) in your queries - specify the columns you need.
 
As for your error messages - if your $result contains a boolean (false) value then the query didn't work.

Rather than hardcoding the date as I did above
 
$sunday = (new DateTime('last sunday'))->format('Y-m-d');                                             $arr = array_filter($arr, function($v) use ($sunday) { return $v < $sunday;}, ARRAY_FILTER_USE_KEY);

You are missing an all-important line
$sql = "SELECT `$mySelect` as mySelect FROM employees"; $result = mysqli_query($link, $sql);                      //          add this line to query the database  If still not working, post the code you now have.                                      

In your printme.php, build the <canvas>...</canvas> element as a string then output the string.
 
I have never used canvas, but here is an example using SVG, which is fairly similar.
 
SAMPLE.HTML
 
<!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Sample SVG with AJAX</title> <style type='text/css'> div {     width: 40%;     height: 150px;     margin: 20px;     padding: 20px;     border: 1px solid gray;     float: left; } </style> <script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script> <script type='text/javascript'>     function draw()     {         var color = $("#colorselect").val();         var sides = $("#sideselect").val();                  $.get (             "sample_svg.php",             { "color" : color ,               "sides" : sides             },             function(resp) {                 $("#graphics").html(resp);             }         )     }          $().ready( function() {                  $("#colorselect").change( function() { draw(); })         $("#sideselect").change( function() { draw(); })     }) </script> </head> <body> <div>     Color: <select id='colorselect'>                <option value='0'>- choose -</option>                <option value='red'>Red</option>                <option value='blue'>Blue</option>                <option value='green'>Green</option>             </select>     <br><br>     Sides: <select id='sideselect'>                <option value='0'>- choose -</option>                <option value='3'>Three</option>                <option value='4'>Four</option>                <option value='5'>Five</option>                <option value='6'>Six</option>                <option value='7'>Seven</option>                <option value='8'>Eight</option>             </select> </div>   <div id="graphics">     <!-- graphic goes here --> </div>   </body> </html>  
SAMPLE_SVG.PHP (called via ajax)
 
<?php $color = isset($_GET['color']) ? $_GET['color'] : '#888'; $sides = isset($_GET['sides']) ? $_GET['sides'] : 0; exit( writeSVG($color, $sides) );            //output the SVG code function writeSVG($color, $sides) {     $svg = "<svg width='100' height='100' viewBox='0 0 100 100'>         <rect x='0' y='0' width='100' height='100' fill='#CCC'/>\n";     if ($sides < 3 || $sides >   {         $svg .= "<circle cx='50' cy='50' r='50' stroke='black' fill='$color'/>\n";     }     else {         $path = "M 100 50 ";         $theta = 2 * M_PI / $sides;         $svg .= "<circle cx='50' cy='50' r='50' stroke='black' fill='none'/>\n";         for ($i=1; $i<$sides; $i++) {             $x = 50 + 50 * cos($i * $theta);             $y = 50 - 50 * sin($i * $theta);             $path .= "L $x $y ";         }         $path .= "z ";         $svg .= "<path d='$path' fill='$color' />\n";     }         $svg .= "</svg>\n";     return $svg; } ?>

This was a problem that piqued my interest. I started out comparing start and end times, looking for overlaps and so on. I was doing quite well with my test scenario until I got to the final regular show that was interrupted twice by special shows. It was there my algorithm collapsed in a heap.
 
At tat point I embarked on a brute force solution, splitting the day into timeslots (15 minute slots to accomodate my data times). These slots were then filled with priority special shows and remaining empty slots filled by the regualr schedule.
 
Data and Results
 
mysql> select * from regular_show;                                   mysql> select * from special_show; +--------+-----------+---------------------+---------------------+   +--------+-----------+---------------------+---------------------+ | idshow | title     | start_time          | end_time            |   | idshow | title     | start_time          | end_time            | +--------+-----------+---------------------+---------------------+   +--------+-----------+---------------------+---------------------+ |      1 | Regular 1 | 2018-04-03 09:00:00 | 2018-04-03 11:00:00 |   |      1 | Special 1 | 2018-04-03 08:00:00 | 2018-04-03 10:00:00 | |      2 | Regular 2 | 2018-04-03 11:00:00 | 2018-04-03 12:00:00 |   |      2 | Special 2 | 2018-04-03 11:00:00 | 2018-04-03 12:00:00 | |      3 | Regular 3 | 2018-04-03 12:00:00 | 2018-04-03 15:00:00 |   |      3 | Special 3 | 2018-04-03 14:00:00 | 2018-04-03 16:00:00 | |      4 | Regular 4 | 2018-04-03 15:00:00 | 2018-04-03 16:00:00 |   |      4 | Special 4 | 2018-04-03 19:00:00 | 2018-04-03 20:00:00 | |      5 | Regular 5 | 2018-04-03 16:00:00 | 2018-04-03 18:00:00 |   |      5 | Special 5 | 2018-04-03 20:30:00 | 2018-04-03 21:00:00 | |      6 | Regular 6 | 2018-04-03 18:00:00 | 2018-04-03 20:00:00 |   |      6 | Special 6 | 2018-04-03 21:15:00 | 2018-04-03 21:30:00 | |      7 | Regular 7 | 2018-04-03 20:00:00 | 2018-04-03 23:00:00 |   +--------+-----------+---------------------+---------------------+ +--------+-----------+---------------------+---------------------+ ** RESULTS           Special 1                8:00am to 10:00am            Regular 1               10:00am to 11:00am            Special 2               11:00am to 12:00pm            Regular 3               12:00pm to 2:00pm             Special 3                2:00pm to 4:00pm             Regular 5                4:00pm to 6:00pm             Regular 6                6:00pm to 7:00pm             Special 4                7:00pm to 8:00pm             Regular 7                8:00pm to 8:30pm             Special 5                8:30pm to 9:00pm             Regular 7                9:00pm to 9:15pm             Special 6                9:15pm to 9:30pm             Regular 7                9:30pm to 11:00pm      
My code
 
function publish($show, $start, $end) {     $s = (new DateTime($start))->format('g:ia');     $e = (new DateTime($end))->modify('+15 minutes')->format('g:ia');     printf('%-20s %10s to %-10s<br>', $show, $s, $e ); } // *************************************** // Shortest interval used is 15 min, // so create array of 15 min // timeslots for the day // *************************************** $schedule_date = '2018-04-03'; $dt1 = new DateTime($schedule_date.'07:00'); $dt2 = new DateTime($schedule_date.'23:59'); $di =  new DateInterval('PT15M'); $dp =  new DatePeriod($dt1, $di, $dt2); $timeslots = []; foreach ($dp as $t) {     $time = $t->format('H:i');     $timeslots[$time] = ''; } // ******************************************* // get al1 shows, placing special shows first // to give them priority placement // ******************************************* $res = $db->prepare("SELECT *                     FROM                         (                         SELECT r.title                              , r.start_time                              , r.end_time                              , 2 as priority                         FROM regular_show r                         UNION                         SELECT s.title                              , s.start_time                              , s.end_time                              , 1 as priority                         FROM special_show s                         ORDER BY  priority, start_time, end_time                         ) shows                     WHERE DATE(start_time) = ?"); $res->execute( [$schedule_date] ); // ****************************************************** // place shows in their respective timeslots // only placing shows if the timeslot // is still empty // ****************************************************** foreach ($res as $r) {     $st = date('H:i', strtotime($r['start_time']));     $et = date('H:i', strtotime($r['end_time']));     foreach ($timeslots as $hm => $v) {         if ($hm >= $st && $hm < $et) {             if (empty($v)) {                 $timeslots[$hm] = $r['title'];             }         }     } } // **************************************************** // find the start and end of each show and // publish the times // **************************************************** $schedule = []; $prev = ''; foreach ($timeslots as $hm => $show) {     if (!$show) continue;     if ($show != $prev) {         $title = $show;         $st = $hm;         $prev = $show;     }     $schedule[$st] = [ $title, $hm ]; } foreach ($schedule as $st => $show) {     publish($show[0], $st, $show[1]); }

The conversion works OK then.
 
In php you would do something like this
 
$expire = '2018-03-20'; $ship = '2018-01-19'; $date1 = new DateTime($expire); $date2 = (new DateTime($ship))->add(new DateInterval('P7D')); if ($date1 <= $date2) {     // do whatever if expired } else {     // do whatever if not expired }  
However, Psycho's method of doing the test in the query looks a lot better. It then becomes
 
if ($row['expired']) {     // do this } else {     // do that }

I think you should re-read the manual

Use array_intersect to check for common values
 
$data = [   [28, 6],  [6], [61,6,28]  ];          $result = []; foreach ($data as $arr) {     $result = empty($result) ? $arr : array_intersect($result, $arr); } // view result echo '<pre>', print_r($result, 1), '</pre>';

Grouping by sku would also give the totals you expect but the values for po_no, date and vendor would be of no particular meaning as they could come from any arbitrary record in each of the groups.

A basic rule of relational database design is "do not store derived data such as counts or totals". You get them when required with a query.

Pass the id of the video in the link and then retrieve the one with that id.
 
At the moment, if more than one video in the query results you are left with values from the last row in $video and $title

What happens when you run it?
 
Whatever happens, that what it does - simple.
 
(It will stop look at other conditions as soon as it encounters a condition that evaluates as "true")

Because I gave SUM() the alias "sales" you should reference that value with $row['sales'].
 
Is the technician that appears the only one with any sales? The JOIN will only result in rows where there are matching records in both tables. If you want all technicians even if they have no sales then we need to switch to a LEFT JOIN

SELECT t.id , t.firstname . t.lastname , SUM(s.sale) as sales FROM technician t LEFT JOIN everyday_sale s ON s.technician_id = t.id GROUP BY t.id

You should be passing parameters to a search page via GET and not using POST

I am surprised either one works as they are .HTML files and not .PHP (unless your server is unusually configured)
 
If you want the form to call the same page you can just leave the action blank(action="").

You should not be storing names and schools in both tables, they belong in the player table only along with a unique id for each player. It is that id that should be in the review table and that is what you should then join on.
 
You were told before about about those concats in your where clause (so I guess telling you anything is a waste of time). It is also completely unnecessary in the group by - just
... GROUP BY apr.nameFirst, apr.nameLastDo not use "SELECT *", Specify the columns you need. This is particularly wasteful when joining tables as there will always be duplicate (matching) column values. 
As or your problem stated, try
... ORDER BY MAX(time) DESC LIMIT 10

In your form tag you have

method"POST" which is missing the "=" sign. 
As the default method is GET, the values are passed in the url instead of being POSTed.

You could use json_encode then save it to a text file. Then use json_decode after reading it back to recreate the array.

You will get "ambiguous field" error when you reference fields with the same name in two different tables. Prefix the column names with the table names (tablename1.colA , tablename2.colA) or aliases to avoid the ambiguity.
 
If you still have a problem, post the query.
 
Best wishes for 2018.

You really don't see a problem?

sprintf()
 
EG

for ($i=1; $i<=10; $i++) { echo sprintf("%03d.jpg", $i) . '<br>'; }

Use an associative array and strtr()
EG

$links = [ 'dogs' => '<a href="link1">dogs</a>', 'red dogs' => '<a href="link2">red dogs</a>', 'big red dogs' => '<a href="link3">big red dogs</a>' ]; $description = "the dogs and the red dogs were being chased by big red dogs"; $newdesc = strtr($description, $links);