Tagged Questions
2
votes
1answer
46 views
Add value from dropdown to html attribute
I'm trying to add a dropdown value to a attribute in the table below. But it doesn't seem to work using the .attr() from jQuery
This is the jquery:
$("#datasize").change(function(){
var ...
1
vote
1answer
22 views
Use fields from second table if entry already exists
I'm working on a forum right now and I try to create an Overview with the latest reply of each threat if exists.
I got two tables, one for the first thread and one for all replies.
TABLE1 (THREADS)
...
0
votes
1answer
37 views
Understanding Aliasing and Tables, SQL
I'm trying to an output table with each row representing posts in a thread and the columns subdividing the thread into question, answers, and comments. I have the question and answer part down, now I ...
0
votes
2answers
37 views
Select the second highest value in MySQL
I actually try to get the second highest value of a table with this request :
SELECT MIN(`mensualite`) AS min, MAX(`mensualite`) AS max FROM `mensualites`
WHERE((`financement` = "1200")
AND ...
-1
votes
2answers
31 views
Issue with show all users in the table with pdo
I have the next issue, when I need the code show me all the users in the table always show me one data the first one or the last one if I change the ASC to DESC inside of SELECT..
I need to show me ...
0
votes
3answers
37 views
MySQL select records from one table that don't exist in another table
I have two tables on two different databases.
I wish to select the values from the field MLS_LISTING_ID from the table mlsdata if they do not exist in the table ft_form_8.
There are a total of 5 ...
0
votes
2answers
39 views
How to create a dummy value column in MySQL depending on the Table specific information was selected from?
I have two tables that contain information about users. One table, current_users keeps track of current users and the other table, new_users, contains data of users who have recently submitted their ...
1
vote
1answer
43 views
SELECT from Union x 3 using filter of another table
Background
I have a web application which must remove entries from other tables, filtered through a selection of 'tielists' from table 1 -> item_table 1, table 2, table 3.... now basically my result ...
0
votes
1answer
27 views
Update Query when username changes
Here is a query I'm trying.
Please don't laugh as I'm currently clueless, lol.
UPDATE toondb SET ttnusername = (select username FROM user WHERE userid='1') WHERE (select username FROM user WHERE ...
-3
votes
2answers
83 views
Using * in SELECT queries [duplicate]
I read somewhere that never use * to return all columns in a table–it’s lazy. In this case, if I need all 5 columns and there won't be any changes to the table later, are there any performances ...
0
votes
1answer
44 views
SQL MS ACCESS - Select Last Updated Row with condition
First of all thank you for any support you're able to provide.
I'm working on building a workload tracking system, I have a table that currently has listed all the tasks to be completed (each with a ...
0
votes
2answers
19 views
Selecting entries from a table by checking condition on another table
I have two tables:
Table1
ID ServiceID
01 21
02 22
03 23
Table2
ID Value
01 NULL
02 value2
03 NULL
I want to select those ServiceIDs from Table1 the IDs of which ...
0
votes
3answers
55 views
Select statement format Error with spaces
Why do I get an error when writing my select statement like this - Note the space/tab/newline next to my table name "Personnel Number"
(I know that naming convention is bad, but I had to do it, since ...
0
votes
1answer
45 views
Where (or even any kind of join) doesn't work with Temp table in SQLite?
I have to collect data from many sources into a temp table before performing another SELECT on this table and another table. The temp table has a column called RoomID while the table (which I want to ...
-1
votes
3answers
52 views
Selecting data from database by ID
I know this question maybe be easy but since I'm new to PHP and MySQL I don't know a solution to this.
I want to retrieve data from a table, but only for that one user. It's a system to check if their ...
