buddys.php

<?php

function is_buddys(){
    $user_id = (int)$_SESSION['user_id'];
    $sql = mysql_query("SELECT * FROM `buddys` WHERE `user_one` OR `user_two` = '$user_id'");
}

function get_buddy_feeds(){
    $user_id = (int)$_SESSION['user_id'];
    GLOBAL $user_data;

    $sql = mysql_query("SELECT * FROM `users` WHERE `user_id` = '$user_id'");
    $sql = mysql_query("SELECT DISTINCT * FROM feeds f, buddys b WHERE (b.user_one = '$user_id' AND b.user_two != '$user_id') OR (b.user_two = '$user_id' AND b.user_one != '$user_id')");

    while ($row = mysql_fetch_assoc($sql)){
                $id = $row['id'];
                $user_id = $row['user_id'];
                $username = $row['username'];
                $body = $row['body'];
                $date = date("g:i a F j, Y ", strtotime($row['date']));
                $dellink = "| <a href=\"http://localhost/vibeate/wigets/deletepost.php?id=" . $id . "\" style='color: grey;text-decoration:none;'>Delete</a>";
                ?>
                <h2><a href="users/<?php echo $username; ?>"><?php echo $username; ?></a></h2>
                <p><?php echo $body; ?></p><br />
                Posted at <?php echo $date; ?> <?php if ($user_id == $user_data['user_id'] || is_admin($user_data['user_id']) === true){
                    echo $dellink;
                }
                ?>
                <br /><hr width="500px">
                <?php
            }

            if (empty($id) === true){
                echo '<h2>Oops!</h2><h3>Seems like there\'s nothing to show. Try adding some buddies!</h3>';
            }
            echo mysql_error();
}
?>