質問編集履歴
2
補足
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -62,7 +62,9 @@
|
|
|
62
62
|
|
|
63
63
|
|
|
64
64
|
|
|
65
|
-
|
|
65
|
+
### 補足
|
|
66
|
+
|
|
67
|
+
|
|
66
68
|
|
|
67
69
|
```php
|
|
68
70
|
|
1
SQL文にLIMITを追加
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -59,3 +59,29 @@
|
|
|
59
59
|
|
|
60
60
|
|
|
61
61
|
foreachで回さずに一行だけ取得して表示させる方法をご教授いただければ幸いです。
|
|
62
|
+
|
|
63
|
+
|
|
64
|
+
|
|
65
|
+
【補足】
|
|
66
|
+
|
|
67
|
+
```php
|
|
68
|
+
|
|
69
|
+
$sql = "SELECT SUM(complete) as total01, SUM(profit) as total02 FROM report LIMIT 1";
|
|
70
|
+
|
|
71
|
+
$res = $dsn->query($sql);
|
|
72
|
+
|
|
73
|
+
```
|
|
74
|
+
|
|
75
|
+
|
|
76
|
+
|
|
77
|
+
上記で1行だけ取得した後の表示方法は
|
|
78
|
+
|
|
79
|
+
```php
|
|
80
|
+
|
|
81
|
+
echo $res
|
|
82
|
+
|
|
83
|
+
```
|
|
84
|
+
|
|
85
|
+
|
|
86
|
+
|
|
87
|
+
で宜しいでしょうか？
|