I have a tickets table with this info: ticket_id | user_id | used_at ---------------------------------------- xxx | xxx | datetime xxx | xxx | datetime xxx | xxx | datetime I want to get a list of all users who has…
I am a beginner trying to build very simple inventory system using PHP + SQL I have 2 warehouse. I added 2 tables, 1 for each warehouse contains (item id)-(in)- (out) like shown below table1 item id in out item1…
SELECT DISTINCT info_person.userUsername, infoExamResult.resultPoint, infoExamResult.resultPercentage, infoExamResult.optAnswer FROM info_person INNER JOIN infoExamResult ON infoExamResult.personID = info_person.personID where infoExamResult.datetimeStart BETWEEN "2024-03-18" AND "2024-03-26" and infoExamResult.optAnswer = "COMMIT" ORDER BY info_person.userUsername Outcome which resultPoint are Score and resultPercentage are Percent of max score…
I am developing a react website and I am trying to customize select option based on my own Figma design. enter image description here This is my Figma design and I made it like this : const CustomDatePicker = ({…
I have a table sample below: Table_A col1 col2 881 113 988 899 113 765 765 765 122 881 300 400 765 910 910 345 999 988 What I want to achieve here, is to get the last chaining data…
So I have a MYSQL table, and one of the columns (call it TAGS) is an array which contains a list of tag names. For example, a given entry could have a TAGS column value of "TAG A, TAG B,…
new to php and MYSQL,and would like some help, so please be gentle I have some code which populates a HTML table using php echo. The statement is: $query= "SELECT Distinct AgeGrp, Gender,Dist, Stroke, First, Family, Name, Year, Time, Event,…
I would like to calculate the fraction of rows fulfilling some criteria. So something like this: (SELECT COUNT(*) FROM table WHERE col_name > crit) / (SELECT COUNT(*) FROM table) However, this creates a syntax error when I tried it. How…
I have a select element on my web page that allows the user to select multiple options. I want to obtain an array with the values of all the options that are currently selected. I have tried using the selectedOptions…
While working white Availability of Resources. I got struct here. Let me explain so expect to get some help here. Considering a table Availability as below create script with sample records for better understanding. CREATE TABLE availibility ( id int…