I have a web app, that logging some events (not important what). My web server is in different timezone , i want to log date and time of my timezone. I created simple DB table with fields: ID - BIGINT…
Trying to connect to a mysql db on a raspberry pi, from a Synology NAS. The SELECT shows nothing, and the connect.php shows no errors. Both work fine from a different Pi to the host Pi. I've tried with an…
In my code I use $user_id = $_SESSION["USER_ID"]; to get the users id that is valid. If I use echo function in PHP it displays the correct id but when I try to use it in query it says it…
I am trying to retrieve tickets from a database that are created in the last 6 weeks. Therefore i am trying to use an delimiter which filters that period but the database time is based on an UNIX timestamp and…
I have the following query: with current_round as ( select * from match_case_1 where round_id = 12696 ) select * from current_round cr where ( not exists(select * from current_round where gameweek is null) ) or ( exists(select * from…
I have a database where in the accounts table the "username" is the "id". Now I need to add to the table the field "name" which will work as the "id", so if I create a new account, I need…
I'm just playing around with SQL for the first time at the moment and I've been trying to add new columns to an existing table for a student registry sort of deal. I've followed a few tutorials online and they're…
I have two different table in phpmyadmin. One is tbl_user and another is donate. Now I want to take the column donation_date from tbl_user and all columns from the donate table. I want to join one column (donation_date) from tbl_user…
The problem is when I run the code it checks to see if any person has been in department 1 then stops but only want persons that have been in all four departments SELECT p.person_id AS ID, CONCAT(p.firstname, " ",…
I keep having an issue with my SQL query, and I'm not able to resolve it myself after various attempts and research. The error: Warning: #1292 Truncated incorrect DOUBLE value: 'TITLE1_00' Warning: #1292 Truncated incorrect DOUBLE value: 'TITLE2' Warning: #1292…