ORDER BY ~ DESCってどういう意味ですか
追記
テーブル:「name(int)」「comment(varchar)」「time(timestamp)」
リンク内容
PHP
1$mysqli = new mysqli($host, $user, $password, $dbname); 2if ($mysqli->connect_error){ 3 print("接続失敗:" . $mysqli->connect_error); 4 exit(); 5 } 6 7 $stmt = $mysqli->prepare("INSERT INTO XXX (name, comment) VALUES (?, ?)"); 8 $stmt->bind_param('ss', $_POST["name"], $_POST["comment"]); 9 $stmt->execute(); 10 11 $query = "SELECT * FROM XXX"; 12 13 $result = $mysqli->query("SELECT * FROM XXX ORDER BY time DESC"); 14if($result){ 15 while($row = $result->fetch_object()){ 16 $name = htmlspecialchars($row->name); 17 $comment = htmlspecialchars($row->comment); 18 } 19} 20 21$mysqli->close(); 22
回答6件
あなたの回答
tips
プレビュー