coding help.

[Cherpi]

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 :)

[Apolva]

What's the address of the forum?

[Irrorate]

1) What forum software is it?

Most forum software vendors have this function built in.

[Cherpi]

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

[Trigs]

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

[Cherpi]

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.

[Trigs]

Then how did you code that forum?

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



$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?

[Cherpi]

Then how did you code that forum?

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



$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]

[Trigs]

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

[Irrorate]

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