回答編集履歴

1

SQL修正

2017/05/26 04:32

投稿

m.ts10806
m.ts10806

スコア80850

test CHANGED
@@ -54,9 +54,9 @@
54
54
 
55
55
  from tbl_message_pre
56
56
 
57
- where (from_user = '山田' or from_user = '山田')
57
+ where (from_user = '山田' or to_user = '山田')
58
58
 
59
- and (from_user = '田中' or from_user = '田中')
59
+ and (from_user = '田中' or to_user = '田中')
60
60
 
61
61
  order by created_at desc
62
62