here's where your error is:
$post = mysql_query("SELECT * FROM post WHERE post.userid='90' ORDER BY dateline ASC LIMIT 1");
compared to what i wrote...
$post = $DB_site->query_first("SELECT * FROM post WHERE postuserid='$user[userid]' ORDER BY dateline ASC LIMIT 1");
note the "query_first"... you'll need to use an additional mysql_fetch_array there to fetch the first (and only) row. after that it'll probably work.
|