hi,
i am trying to build a message board in php with mysql as back end;
what i want to do is to query the database in a certain way that the result
is returned in the correct order for php to display the discussion thread
properly
here is my table structure:
mysql> show fields from posts
-> ;
+-------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------------+------+-----+---------+----------------+
| msgid | bigint(20) unsigned | | PRI | NULL | auto_increment |
| dateadded | timestamp(14) | YES | | NULL | |
| subject | mediumblob | | | | |
| body | longblob | YES | | NULL | |
| replytopost | bigint(20) unsigned | YES | | 0 | |
| aposition | tinyint(3) unsigned | YES | | 0 | |
| thrid | bigint(20) unsigned | | MUL | 0 | |
| usrid | bigint(20) unsigned | | MUL | 0 | |
| username | varchar(50) | | | | |
+-------------+---------------------+------+-----+---------+----------------+
9 rows in set (0.00 sec)
the query should look like : select * from posts where thrid = 'the id of
the thread' order by.....(this is the part i couldn't figure out);
the position of a single message into the tree is determined by the
following criteria:
dateadded : the date in which it was added
replytopost: the post to which it belongs, if none then 0 is assigned
aposition: the absolute position of the message (horizontal)
a combination of these columns in an order by clause should (in theory)
build the tree correctly
please advise me if i am doing something wrong here, i have tried many
combinations without success
regards;
hassan
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
