dodgeitorelse3

Have you tried to echo query to verify what it is using for login credentials?

I think you are going to want to run your if/else statement on your results instead of in your query.

Also with chart.js all arrays used for chart must have exact same number of items in each array.

is the filename from files table stored with file extension?

check your semi colons ( ; )

Show what you have tried so far please

OP is most likely after rows 11 through 20 (after last 10)

@OP, you have a comma before name in your query

What are you selecting from joborder?

var labelsdb = <?php echo json_encode($labelsdb); ?>; //array from database for dates and times var datadb = <?php echo json_encode($datadb); ?>; // array from database for number of players var datadon = <?php echo json_encode($datadon); ?>; // array from database for number of players var datadoff = <?php echo json_encode($datadoff); ?>; // array from database for number of players var ctx = document.getElementById("myChart"); // points to canvas ctx.style.backgroundColor = "#2F3136"; //canvas background color var myChart = new Chart(ctx, { type: 'lin

this is using chartjs

I have this code. The players works and scales to the left side 0-23 but online scales to left side 0-23 instead of right side 0-1. What am I doing wrong? //arrays used in javascript //$labelsdb = array('2018-12-20 00:11', '2018-12-20 00:37', '2018-12-20 00:43', '2018-12-20 03:15', '2018-12-20 03:42', '2018-12-20 03:56', '2018-12-20 04:17', '2018-12-20 04:33', '2018-12-20 07:23', '2018-12-20 10:00', '2018-12-20 12:23', '2018-12-20 14:00', '2018-12-20 18:42', '2018-12-20 19:17', '2018-12-20 23:53'); //$datadb = array(2,12,2,7,23,5,8,2,0,4,0,8,1,0,3); //$datadon = array(1,0,1,1,1,1,1,0,1,

🥴

Assuming you ran a query to get $result your first option has no value set. The second option should have the echo inside quotes just like your submit does.

Did you bother to test the 2 suggestions?