teratail header banner
teratail header banner
質問するログイン新規登録

質問編集履歴

2

2015/09/19 10:58

投稿

nakamura03
nakamura03

スコア25

title CHANGED
File without changes
body CHANGED
@@ -15,7 +15,7 @@
15
15
  $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
16
16
 
17
17
  $stmt = $pdo->prepare('
18
- SELECT tables.*, members.name, tmembers.id
18
+ SELECT tables.*, members.name, members.id
19
19
  FROM tables, members
20
20
  WHERE tables.userid = members.id and tables.id = :id
21
21
  ');

1

2015/09/19 10:58

投稿

nakamura03
nakamura03

スコア25

title CHANGED
File without changes
body CHANGED
@@ -15,9 +15,9 @@
15
15
  $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
16
16
 
17
17
  $stmt = $pdo->prepare('
18
- SELECT ttables.*, tmembers.name, tmembers.id
18
+ SELECT tables.*, members.name, tmembers.id
19
- FROM ttables, tmembers
19
+ FROM tables, members
20
- WHERE ttables.userid = tmembers.id and ttables.id = :id
20
+ WHERE tables.userid = members.id and tables.id = :id
21
21
  ');
22
22
  $stmt->bindParam(':id', $_SESSION['id'], PDO::PARAM_STR);
23
23
  $stmt->execute();