Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>probable cause: it is selecting data from 2 tables (tbl_teams and tbl_games) <br> The condition is that tbl_teams.team_ID equals team2_ID <em>and</em> team1_ID. Unless there are games where the same team was on both sides, that's never going to work. </p> <p>You didn't specify what you want the query to return, so I'll assume you just want the results for both teams.</p> <p>What you probably want is a join that involves 3 sets of data: game, the first team, the second team. in SQL this can be done using an alias.</p> <p>try this:</p> <pre><code>SELECT tbl_games.game_ID, tbl_games.game_date, team1.team_name as "team1_name", team2.team_name as "team2_name" FROM tbl_teams as team1, tbl_teams as team2, tbl_games WHERE tbl_games.team1_ID = team1.team_ID AND tbl_games.team2_ID = team2.team_ID AND tbl_games.team1_score IS NULL AND tbl_games.team2_score IS NULL; </code></pre> <p>Adding the "is null" will reduce the results. If all games have a score, you won't get any results.</p> <p>Another potential issue with your query is that the field names are between single quotes. I'm not sure those are removed by php before actually executing the query. If they're not, that's bad; anything between single quotes is treated as a string. That would mean the condition <code>'tbl_games.team1_score' IS NULL</code> is actually comparing string 'tbl_games.team1_score' with null and not the content of the field named team1_score.</p> <p>Edit: added the is NULL to the where clause as in the example data you do have nulls.</p>
    singulars
    1. This table or related slice is empty.
    1. POWhat's wrong with my join statement? It returns BOOLEAN in PHP
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USr.m
    1. USr.m
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWhat's wrong with my join statement? It returns BOOLEAN in PHP
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COWhy did you remove the `tbl_games.teamN_score IS NULL` condition from the WHERE clause?
      singulars
      1. PO
      1. USBarmar
    2. CO@Barmar: ups, you're right. I didn't see the example set in the question. I figured it could have been a possible cause. I'll edit it back in.
      singulars
      1. PO
      1. USr.m
    3. COThis worked perfectly, thank you. :-)
      singulars
      1. PO
      1. USMike Ashfield
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload