X-Git-Url: https://disinclined.org/git/?a=blobdiff_plain;ds=sidebyside;f=index.php;h=a0cae2f41b7d763b1bdc38a8b9d6aa9dfc08915a;hb=7486ea5bf3d89cd7662a51bb05c16f5f6d96105c;hp=88f82d2410f52e0f59fdfbe72e9142e53265b75d;hpb=bb1eebf30f1917d091f84a9bd43b97a5e3fcf574;p=dylansserver.git
diff --git a/index.php b/index.php
index 88f82d2..a0cae2f 100644
--- a/index.php
+++ b/index.php
@@ -163,7 +163,7 @@ class index extends cms {
";
- $sql = "SELECT text FROM projects";
+ $sql = "SELECT text FROM projects ORDER BY rank";
$result = $this->db->query($sql);
while ($entry = $result->fetch_object()) {
echo $entry->text;
@@ -201,7 +208,7 @@ OTHER_PROJECTS;
my projects:
HEREDOC;
- $sql = "SELECT title FROM projects";
+ $sql = "SELECT title FROM projects ORDER BY rank";
$result = $this->db->query($sql);
while ($entry = $result->fetch_object()) {
echo "
$entry->title";
@@ -435,8 +442,8 @@ class note extends cms {
// and a default author needs to be set
// for no-javascript users.
$stmt->bind_param('sss',
- htmlspecialchars($_POST['name']),
- htmlspecialchars($_POST['text']),
+ $_POST['name'],
+ $_POST['text'],
$this->id);
$stmt->execute();
}
@@ -491,7 +498,7 @@ END_OF_NAVIGATION;
$date_posted = $entry['date_posted'];
$author = $entry['author'];
$text = htmlspecialchars($entry['text']);
- $head = "
$author
";
+ $head = "
" . htmlspecialchars($author) . "
";
echo <<