just quickly: why don't you just install phpBB (takes <5mins), see what their DB-schema is and take some inspiration from that for your own board?
Just an idea to save you from re-inventing the wheel.
Those Pesky Sessions
Moderator: General Moderators
-
smithjasonuk
- Forum Newbie
- Posts: 13
- Joined: Tue Mar 23, 2004 6:57 am
- Location: Glasgow, Scotland
Have you ever heard of Radix?
Quickly, it is a piece of hardware and software that locks the hard drive, so that anything, and I mean anything including boot sector viruses new software, hardware, etc, will be wiped every time it reboots. We have just installed these on our computers. And i have a head technician that is quite put off with the idea of having anything put on his computers until, he has debugged our new images and made sure everything is running smoothly.
This is why I haven’t installed it, yes I agree, download it and put it on, but for what point!
I’m not near my home or college computer for another 24 hours, so until then as i said before I know I could just download it, but in the off chance I was asking if anyone had the solution there and then.
Quickly, it is a piece of hardware and software that locks the hard drive, so that anything, and I mean anything including boot sector viruses new software, hardware, etc, will be wiped every time it reboots. We have just installed these on our computers. And i have a head technician that is quite put off with the idea of having anything put on his computers until, he has debugged our new images and made sure everything is running smoothly.
This is why I haven’t installed it, yes I agree, download it and put it on, but for what point!
I’m not near my home or college computer for another 24 hours, so until then as i said before I know I could just download it, but in the off chance I was asking if anyone had the solution there and then.
A posts list query just needs a topic id.smithjasonuk wrote:Looking into it how would the posts table work
i thought it would look something like this
post_id (unique post id)
Topic_id (links to the topic table)
Forum_id (links to the forum table)
User_id (Linked to the user table)
subject
message
ect.
how can you reply to this post if the post_id is unique or how does the forum sort it self so that it knows where to send the posts to the correect topic ?
much app for an answer
-
smithjasonuk
- Forum Newbie
- Posts: 13
- Joined: Tue Mar 23, 2004 6:57 am
- Location: Glasgow, Scotland
More SQL
What then is the MySQL statement for insereting a new topic_id in the topics table and then puting this ID into the posts table
i.e.
Topic table example
*******************************
topic_id - PK auto inc
topic_subject
etc
*******************************
Post table example
*******************************
post_id - PK auto inc
topic_id - int
post_message
ect
*******************************
i.e.
Topic table example
*******************************
topic_id - PK auto inc
topic_subject
etc
*******************************
Post table example
*******************************
post_id - PK auto inc
topic_id - int
post_message
ect
*******************************
-
smithjasonuk
- Forum Newbie
- Posts: 13
- Joined: Tue Mar 23, 2004 6:57 am
- Location: Glasgow, Scotland
Pass the topic ID in the link (if you look at the reply button on this forum you can see a t=1971 - the topic ID).
In the form, create a hidden field for topic id.
When you insert a new post row, that would be available in the script as $_POST['t'] (with "post" form action).
GET vars -> hidden form fields -> POST vars.
In the form, create a hidden field for topic id.
When you insert a new post row, that would be available in the script as $_POST['t'] (with "post" form action).
GET vars -> hidden form fields -> POST vars.