quote:

---

Originally posted by Shaggy

In default.asp, have a look at lines 788 to 805 to see how the information is pulled from the database and then at lines 1022 & 1023 to see how it's written. Post back if you need any further assistance.

---

quote:

---

Originally posted by Shaggy

Do you already have a connection established to the database containing your MEMBERS table? If so, all you need is the following code (use the line in red if using MySQL, otherwise use the line in green; delete whichever line you're not using):

set rs=my_Conn.execute("SELECT MEMBER_ID,M_NAME FROM FORUM_MEMBERS WHERE M_STATUS=1 ORDER BY MEMBER_ID DESC LIMIT 0,1")
set rs=my_Conn.execute("SELECT TOP 1 MEMBER_ID,M_NAME FROM FORUM_MEMBERS WHERE M_STATUS=1 ORDER BY MEMBER_ID DESC")
if not rs.eof then response.write "Please welcome our newest member, <a href=""forum/pop_profile.asp?mode=display&id="&rs("MEMBER_ID")&""">"&rs("M_NAME")&"</a>"
rs.close
set rs=nothing

You may also need to change some of the items highlighted in bold to suit your setup.

I'm in Dublin, by the way.

---

quote:

---

Originally posted by Shaggy

Ah, OK, I had been working on the assumption that your 'blog and forum were part of the same "application", if you're using a 3rd party 'blogging tool, such as Blogger, this isn't going to be possible, unfortunately, unless the 'blog is being published to the same server as your forums. It may be possible, though, to do it with an RSS feed but I'm not familiar with them at all.

All that probably ain't too clear, 'cause I'm watching the clock tick down here to a 3 day bender but I can quickly clear it up if you provide me with a link to your 'blog and your forum.

---

quote:

---

Originally posted by Shaggy

Ah, definitely possible, so. But, as your 'blog is written in PHP and I don't "speak" it, that's as much help as I can provide. Gonna move this to the community forums where hopefully someone with the necessary PHP skills can "translate" what I posted above for you.

---