03-16-2023, 09:32 PM
I may have found the problem, in the error the link to call the php file is as follows.
http://192.168.179.34/php/schedulesSort.php?s=schName&a=1& =1678987612522
I didn't expect to see =1678987612522 at the end, that's the unix timestamp and it lines up close to when you posted. I don't send that to the php file so not sure why it's there, only the sort column (in this case schName) and ascending (1) or descending(0) sort is sent. But when I run that link in my browser the query runs so it doesn't seem to be affecting it. However that space before the = sign gets replaced with %20 as spaces aren't allowed. I'm wondering if that's what's breaking the php query as it likely won't auto replace the space.
So I need to figure out why that's being included and why it's not for me, arggg. Can you run that link in your browser, I suspect you'll see [] as there are no records to return but that'll verify the database and query are ok.
http://192.168.179.34/php/schedulesSort.php?s=schName&a=1& =1678987612522
I didn't expect to see =1678987612522 at the end, that's the unix timestamp and it lines up close to when you posted. I don't send that to the php file so not sure why it's there, only the sort column (in this case schName) and ascending (1) or descending(0) sort is sent. But when I run that link in my browser the query runs so it doesn't seem to be affecting it. However that space before the = sign gets replaced with %20 as spaces aren't allowed. I'm wondering if that's what's breaking the php query as it likely won't auto replace the space.
So I need to figure out why that's being included and why it's not for me, arggg. Can you run that link in your browser, I suspect you'll see [] as there are no records to return but that'll verify the database and query are ok.