Forum Ideas

wanted420

Ok I am making a forums page and i have it where you register, login and then you can post and read the posts. I am in need of some ideas to make it where ppl can reply. I am not sure how i would do this. I am using mysql. Just any thoughts would be nice. Thankx 😃

Wanted420

planetsim

You will need to relate two tables

I usually have the setup of threads and posts.

Threads
threadid|title|userid|timesent|lastpostid

Than from there relates posts.threadid with threads.threadid

And order the posts.timesent ASC which is ascending so the proper thread starters post should be displayed.

wanted420

How do you get the timesent and have is ASC? Also how do you get the lastpostid?

Steveo31

Those are DATE and TIME functions.

http://dev.mysql.com/doc/mysql/en/DATETIME.html

wanted420

ok i think i got it but this is my problem now. When put in:

$sql = "INSERT INTO members (username, email, password, aim, msn, yahoo, major, signature) VALUES  ('$username', '$email', '$password', '$aim', '$msn', '$yahoo', '$major', '$signature')";
 $result = mysql_query($sql);
 $time = "INSERT INTO members SET timeset=NOW()"; $timeset=mysql_query($time);

i get 2 seperate entries and one is everything i entered except timeset is NULL and the 2nd entry is all NULL except timeset. How can i get it to be something like this:

$time=<some php function for a datetime type>

$sql = "INSERT INTO members (username, email, password, aim, msn, yahoo, major, signature, timeset) VALUES  ('$username', '$email', '$password', '$aim', '$msn', '$yahoo', '$major', '$signature', '$time')";

because i understand why i am getting the results i get but i am not sure how to fix it.

wanted420

Nevermind I got it 🙂

i just used:

"UPDATE members SET settime=NOW() WHERE username='$username'";