function findHashtag($str) { return dbArray("SELECT * FROM litter_posts\n\t\tINNER JOIN litter_users\n\t\tON litter_posts.user_id = litter_users.user_id\n\t\tWHERE post LIKE '%{$str}%'\n\t\tORDER BY litter_posts.time_stamp DESC"); }
function getFollowingPosts() { $id = $_SESSION['user_id']; $result = dbOneArray("SELECT following FROM litter_following\n\t\t\t\t\tWHERE user_id = '{$id}'"); if ($result) { $following = implode(',', $result); return dbArray("SELECT * FROM litter_posts\n\t\t\tINNER JOIN litter_users\n\t\t\tON litter_posts.user_id = litter_users.user_id\n\t\t\tWHERE litter_posts.user_id IN ({$following})\n\t\t\tORDER BY litter_posts.time_stamp DESC"); } }
function getAllUsers() { return dbArray("SELECT * FROM litter_users\n\t\t\t\tORDER BY active DESC"); }
function getAllNews() { return dbArray("SELECT * FROM news\n\t\tORDER BY news_date DESC"); }