coding help.

I have a forum which i found on a site, it's PHP obv and I need some help

I need a code that will show "Latest thread" "date of latest thread" "How many posts are in a certain forum" and "How many threads in a certain forum"

If you can help PM me or reply :)

What's the address of the forum?

1) What forum software is it?

Most forum software vendors have this function built in.

Quote:

---

Originally Posted by Irrorate

1) What forum software is it?

Most forum software vendors have this function built in.

---

It's own software...

http://habbobigbrother.net/forum/main_forum.php

Latest thread: SELECT * FROM topics ORDER BY date_posted DESC
Date of latest: use above query then $array['date_posted']
# of posts & threads: http://php.net/manual/en/function.mysql-num-rows.php

Quote:

---

Originally Posted by Fazon

Latest thread: SELECT * FROM topics ORDER BY date_posted DESC
Date of latest: use above query then $array['date_posted']
# of posts & threads: http://php.net/manual/en/function.mysql-num-rows.php

---

Sorry but I have no idea what I'm supposed to do with that, would it be possible if you put it together and show me what to do with it. I'm not amazing with PHP as you can see.

Then how did you code that forum?

You'll need to change topics and date_posted to the actual names.

PHP Code:

---

$query = mysql_query("SELECT * FROM topics ORDER BY date_posted DESC LIMIT 1"); 


---

I don't really get what you want to do with this latest topic thing so I can't give you the whole code. Do you want a list on a separate page or something?

Quote:

---

Originally Posted by Fazon

Then how did you code that forum?

You'll need to change topics and date_posted to the actual names.

PHP Code:

---

$query = mysql_query("SELECT * FROM topics ORDER BY date_posted DESC LIMIT 1"); 


---

I don't really get what you want to do with this latest topic thing so I can't give you the whole code. Do you want a list on a separate page or something?

---

[icon] [forum name] [total threads] [total posts] [date last post was posted]

PM me the files and I'll do it when I have the time.

If you've downloaded custom forum software and have no clue about HTML, CSS, PHP & SQL then you need to learn them.