X-Git-Url: https://disinclined.org/git/?a=blobdiff_plain;ds=sidebyside;f=index.php;h=bf2249bfd14920d5550c47184bd62ba7bcd57499;hb=60e2ac52bbf649d4b04f91bc731672a94c4373a8;hp=88f82d2410f52e0f59fdfbe72e9142e53265b75d;hpb=bb1eebf30f1917d091f84a9bd43b97a5e3fcf574;p=dylansserver.git
diff --git a/index.php b/index.php
index 88f82d2..bf2249b 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 <<