I have this code for multiselect dropdown <select id="kit" name="tool_id[]" multiple class="form-control single-select selectpicker"> <option value="">Select Tool Name</option> <?php foreach($tools as $tool){?> <option value="<?php echo $tool->id;?>"><?php echo $tool->name;?></option> <?php }?> </select> I can insert data in database ,but unable to…
i have data which is below has email and working hours (in hours formate), expecting output of working_hours to hh:mm:ss select d.email,TRUNCATE(sum(e.hours),2) as "working_hours" from users d inner join proj_time e on d.id=e.user_id WHERE start_time BETWEEN CURDATE() - INTERVAL 1…
I'm trying to figure out how to select the latest DateTime value in a table and all previous data that came with it in a 30 minute window using MySQL. eg table: DateAndTime --------- 09:00:00 08:59:50 08:59:40 08:59:30 08:59:20 08:59:10…
I have a couple of docker containers for my Laravel 9 app (Nginx, PHP, MySQL, PHPMyAdmin, etc). I use spatie package to backup my database. I don't know how to set the path to the mysqldump file as it's in…
Just started learning SQL and need help on the Feb 1, 2020 part. The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key…
Can someone please help me solve a problem that I'm having with MySQL and REGEXP? I am working on cleaning MySQL table containing vehicle inventory. The table has several million rows. I am trying to come up with a regex…
I was finishing advanced IBM Task using MySQL about stored procedures, The following code cannot be executed , It counters an error in syntax I have table public_school & column schoolID (should be INT) & column Leaders_Score (should be INT)…
I have a list of countries, and for each country I have a table like this (first column: user, second column: user_type, third column: date): user user_type date user1 National 2022-10-01 user1 National 2022-10-01 user2 National 2022-10-01 user2 International 2022-10-01…
i hope someone can help with this super silly question. I have a web page nogunsdrugsbets.com where I have set a simple comment section where anybody can leave a comment but instead of people commenting (i think i have not…
I have a table named Work_Items like this: Assume there are lots of Names (i.e., E,F,G,H,I etc.,) and their respective Date and Produced Items in this table. It's a massive table, so I'd want to write an optimised query. In…