Forums
This topic is locked
I have a real problem!
Posted 04 Sep 2001 16:37:43
1
has voted
04 Sep 2001 16:37:43 Magnus Magnus posted:
how do i do this???Lets say i have 1oo posts in a db, with name addres and so on. But how do i do so the post number 57 can see from post 57 down to 0? Or 89 can see down to 0....
Replies
Replied 04 Sep 2001 18:42:08
04 Sep 2001 18:42:08 Joel Martinez replied:
Hmm, I can't say that I really understand what you're trying to do, but from what you posted, I think I can try to help,
if it's not there, add an autonumber column to the table... then query it with a SQL statement something like this:<pre id=code><font face=courier size=2 id=code>SELECT * FROm posts WHERE autoID <= 57</font id=code></pre id=code>That should give you the effect you described.
if this is not what you're trying to accomplish, post again with a bit more detail <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
Joel Martinez [ ]
----------
set rs = conn.execute("SELECT answer FROM brain WHERE question = "& forumPost &"
'2nd place is just 1st Loser
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/
if it's not there, add an autonumber column to the table... then query it with a SQL statement something like this:<pre id=code><font face=courier size=2 id=code>SELECT * FROm posts WHERE autoID <= 57</font id=code></pre id=code>That should give you the effect you described.
if this is not what you're trying to accomplish, post again with a bit more detail <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
Joel Martinez [ ]
----------
set rs = conn.execute("SELECT answer FROM brain WHERE question = "& forumPost &"
'2nd place is just 1st Loser
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/
Replied 04 Sep 2001 19:41:45
04 Sep 2001 19:41:45 Magnus Magnus replied:
hmmm ok i try once agai, but i am not so good att english.
Well i have a db with lets say 20 posts with name id and so on. Then one of this 20 takes in one post. But this post will be "under" below? the man how take it in. like a tree, hope you understand.... So everyone will take in post how will be "under" below, and when the man loggs on he can see only tthe posts unde him...
hmmm i dont no if that will be right, but i hope you understand...<img src=../images/dwzone/forum/icon_smile.gif border=0 align=middle>
Well i have a db with lets say 20 posts with name id and so on. Then one of this 20 takes in one post. But this post will be "under" below? the man how take it in. like a tree, hope you understand.... So everyone will take in post how will be "under" below, and when the man loggs on he can see only tthe posts unde him...
hmmm i dont no if that will be right, but i hope you understand...<img src=../images/dwzone/forum/icon_smile.gif border=0 align=middle>