Web Troubleshooter
Posted: Mon Jan 28, 2008 3:01 pm
Hi all,
Ok this is sort of hard to explain so bare with me. Im trying to develop a website troubleshooter similar to the ms next next solution kind of thing.
i have a mysql db with a table structured as follows
ID, Question, Ans1, Ans2, Ans3, Link1, Link2, Link3, IsSolution
1 , HowOld,0-10,11-100,101-1000,2,3,4,0
2,.....
the link fields contain an ID for the next question... i.e. if they selected Ans2 then Link2 would be used to display the next question!
Ok, so now i've explained what im doing (i hope) here is the problem....
Im trying to write an add function. This is purely to stop people messing with the db and have some validation happen before it gets updated.
I can seem to create a way of checking that each question that has an answer has a reply.. each question can have no more that five replys... but there can be infinit amount of questions.
I hope this makes sense and someone can help.
Thanks in advance,
Rob.
Ok this is sort of hard to explain so bare with me. Im trying to develop a website troubleshooter similar to the ms next next solution kind of thing.
i have a mysql db with a table structured as follows
ID, Question, Ans1, Ans2, Ans3, Link1, Link2, Link3, IsSolution
1 , HowOld,0-10,11-100,101-1000,2,3,4,0
2,.....
the link fields contain an ID for the next question... i.e. if they selected Ans2 then Link2 would be used to display the next question!
Ok, so now i've explained what im doing (i hope) here is the problem....
Im trying to write an add function. This is purely to stop people messing with the db and have some validation happen before it gets updated.
I can seem to create a way of checking that each question that has an answer has a reply.. each question can have no more that five replys... but there can be infinit amount of questions.
I hope this makes sense and someone can help.
Thanks in advance,
Rob.