Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <pre><code> $results= mysql_query("SELECT 'tbl_games.game_ID', 'tbl_games.game_date', 'tbl_teams.team_name' FROM tbl_teams, tbl_games WHERE 'tbl_games.team1_ID' = 'tbl_teams.team_ID' AND 'tbl_games.team2_ID' = 'tbl_teams.team_ID' AND 'tbl_games.team1_score' IS NULL AND 'tbl_games.team2_score' IS NULL"); </code></pre> <p>should be:</p> <pre><code> $results= mysql_query("SELECT `tbl_games`.`game_ID`, `tbl_games`.`game_date`, `tbl_teams`.`team_name` FROM tbl_teams, tbl_games WHERE `tbl_games`.`team1_ID` = `tbl_teams`.`team_ID` AND `tbl_games`.`team2_ID` = `tbl_teams`.`team_ID` AND `tbl_games`.`team1_score` IS NULL AND `tbl_games`.`team2_score` IS NULL"); </code></pre> <p>You were using the wrong type of quotes, and the <code>.</code> must not be inside the quotes.</p> <p>Since none of your table or column names are reserved words, you could do it without the quotes entirely:</p> <pre><code> $results= mysql_query("SELECT tbl_games.game_ID, tbl_games.game_date, tbl_teams.team_name FROM tbl_teams, tbl_games WHERE tbl_games.team1_ID = tbl_teams.team_ID AND tbl_games.team2_ID = tbl_teams.team_ID AND tbl_games.team1_score IS NULL AND tbl_games.team2_score IS NULL"); </code></pre> <p>I think the actual query you may want is this:</p> <pre><code>SELECT tbl_games.game_ID, tbl_games.game_date, tbl_teams.team_name FROM tbl_teams, tbl_games WHERE (tbl_teams.team_ID = tbl_games.team1_ID AND tbl_games.team1_score IS NULL) OR (tbl_teams.team_ID = tbl_games.team2_ID AND tbl_games.team2_score IS NULL) </code></pre> <p>This finds all the games that each team is scheduled to play in, and they have a null score.</p> <p><a href="http://www.sqlfiddle.com/#!2/4b0c1/4" rel="nofollow">SQLFIDDLE</a></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. USBarmar
    1. USBarmar
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThis doesn't have any effect on the output. It still prints nothing to the screen. Based on the data and table structure, should it? I may have written it wrong.
      singulars
      1. PO
      1. USMike Ashfield
    2. CO`SELECT tbl_games.game_ID, tbl_games.game_date, tbl_teams.team_name FROM tbl_teams, tbl_games WHERE tbl_games.team1_ID = tbl_teams.team_ID AND tbl_games.team2_ID = tbl_teams.team_ID;` returns 0 rows, but `SELECT tbl_games.game_ID, tbl_games.game_date, tbl_teams.team_name FROM tbl_teams, tbl_games WHERE tbl_games.team1_ID = tbl_teams.team_ID;` returns the desired result, minus the sames of team 2 for each game.
      singulars
      1. PO
      1. USMike Ashfield
    3. COBetter still, he should remove the backticks. The backticks add nothing.
      singulars
      1. PO
      1. USAndy Lester
 

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