I have a problem when I have to select everything from one table (persons) then count how many objects they own by counting their occurrences on other tables (pens, chairs, books) The current data is as followed: select * from persons; +—-+——-+ | id | name | +—-+——-+ | 1 | Alex | | 2… Read More MySQL query to count occurrences from multiple tables

SELECT * FROM tblPosts WHERE tblPosts.usersID = (SELECT tblFriends.friendsID WHERE tblFriends.myID = ‘$myID’) ORDER BY tblPosts.date DESC; This doesn’t through an error but it also doesn’t work. I think I need a join statement maybe? There are several fields in tblPost. ID, Comment, Date, userID, etc… Using my $myID variable I want to output <<<while($row… Read More SELECT * FROM tblPosts WHERE tblPosts.usersID = (SELECT tblFriends.friendsID WHERE tblFriends.myID = '$myID') ORDER BY tblPosts.date DESC;

I have a table call it Table A. Table A with an ID column ID1 associated with a row. That table looks like the following: ID1 A1.0 B2.0 C3.0 A1.0 … I have a second table call it Table B that has an ID and a corresponding value. That table looks like the following: Value… Read More Using SQL check to see if an ID in Table A exists in Table B. If that ID exists in Table B return corresponding value

Edit: In the preview the tables are shown correct. Could a mod can please correct it? I don’t know what I did wrong. I have three tables. Table 1: tbl_user id username 1 User A 2 User B Table 2: tbl_location id location 1 City 1 2 City 2 3 City 3 Table 3: tbl_userlocation… Read More MySQL Join two Tables, give all entries of table 1

I have 2 tables, first one is called members: id name show 1 John 1 2 Wil 1 3 George 1 4 Chris 1 Second is called score: id user_id score 1 1 90 2 1 70 3 2 55 4 3 30 5 3 40 6 3 100 7 4 30 user_id from score… Read More Select multiple tables with only unique users and ordered by latest id