All Questions
334 questions
1
vote
1
answer
72
views
MySQL Select All Fields of ALL Tables which have records Order By Table [duplicate]
I am in need of a query to select all Tables, field names, from all tables where table has data.
I would like to be able to have Table, Field where given table has data rows in my result set.
I looked ...
- 2,878
1
vote
2
answers
90
views
How can i query the dates between 2 columns with same username in mysql
I have a mysql table which has 'username', 'acctstarttime' and 'acctstoptime'(and an 'id') datetime columns. I need to get records that its acctstarttime or acctstoptime between other 'acctstarttime' ...
1
vote
1
answer
260
views
Fetching my Data in the table to Input boxes based on their ID
Main Goal: I want to view the whole details of my specific row data in my table into a new form(input text) based on their ID.
Here is my code to fetch my data into table
<?php
include '...
- 13
0
votes
1
answer
67
views
Cannot Set value of the text input using jquery?
When the user add the question, I want to store it in database.One of the column of database is "Time" having datatype datetime.
<div asp-validation-summary="All" role="...
- 31
0
votes
0
answers
61
views
Javascript selectquery date between
I am having trouble on query BETWEEN two dates, what I want is when the user have event will return true and if not then false
The startDate value in my database are 2022-05-01 23:59
the date i get on ...
user15404864
1
vote
1
answer
102
views
repairing data search code from mysql database using dropdown list
I'm trying edit a code from this tutorial: [https://www.youtube.com/watch?v=fSIg5y5QXbc&ab_channel=Webslesson][1]. The problem is a sytuation when two or more countires have the same state name (...
- 21
2
votes
2
answers
41
views
subquery double where + aggreate functions
I have table and rows
CREATE TABLE `TEST_TRANSACTIONS`.`Users` (
`id` INT NOT NULL AUTO_INCREMENT,
`balance` INT NOT NULL,
`payed` INT NOT NULL,
`isSimpleUser` INT NOT NULL,
`approvedAdminId`...
- 914
0
votes
0
answers
78
views
how to run sql query based off what is selected in HTML dropdown that is populated with data from db
I currently have a dropdown that is populated with options from a mySQL database and I would like to dynamically pass whatever is currently selected to a php function and print the result underneath ...
- 15
1
vote
1
answer
75
views
Fetching PHP code from table field in database
I have a table notifications where I have a field notification which has value:
<?php echo '.$user['name'][0].' ?>, you are <?php echo popularity(); ?>% popular today.
The output is: , you ...
- 482
1
vote
0
answers
134
views
PHP password_hash causing problems
I'm gathering data from a form using POST method and when the data is entered in to the form and submitted, the data is added to the database correctly.
If I run it as below, I don't receive an alert ...
- 314
0
votes
1
answer
82
views
how to show a leave info that starts from the end of month and ends with the first of month?
I have a form where a user can see how many leave of him has been approved. but the problem start when the user apply for leave selecting the date that start with the end date of the month and ends ...
0
votes
0
answers
72
views
How can I get MySQL data into Javascript using AJAX?
I have setup a leaflet.js map. One is able to add markers to it like this:
L.marker([51.5, -0.09]).addTo(map).bindPopup("hello world").openPopup();
I have a given number -- lets say 5 -- ...
- 141
-1
votes
1
answer
33
views
SQL Query failing due SET Statement [closed]
Whats wrong with this query?
UPDATE
reinigung
SET
`val1` = '[["Datum","20.04.2021","Kalenderwoche",16,"","",""],["","...
- 11
0
votes
1
answer
430
views
Mysql Full outer join two subqueries
I know mysql does not support full outer join, and doing this you have to basically left join/right join and do union. I have two tables one contains all possible keys with labels for them for the ...
- 27
0
votes
2
answers
51
views
QUERY DATABASE: How can I get multiple data from 2 tables with an id that does not exist in a table
Hello i've got the following two tables:
TABLE: computers
| id | pc | user_id |
|:---|:---- -|:----|
| 1 | M-1 | 25 |
| 2 | P-1 | 15 |
| 3 | C-2 | 36 |
| 4 | A-5 | 0 |
| ...
- 3