Hello, I need your...
Moderator: General Moderators
-
gaogier
- Forum Contributor
- Posts: 391
- Joined: Wed Mar 02, 2005 1:02 pm
- Location: Portsmouth, UK
- Contact:
Hello, I need your...
Hello, I need your advice on something.
What would be the best way, to make somesomething that is mostly complete, I would say about 70% so we dont really want to change too much.
Here is the problem
say, you have, 150 fields added in a mysql database and they all need to be marked off as complete (its something for a game), all ID'ed and say, 140th field requires 10 fields to be marked off as complete, inorder for it to be complete.
How would the best way for this to be done?
What would be the best way, to make somesomething that is mostly complete, I would say about 70% so we dont really want to change too much.
Here is the problem
say, you have, 150 fields added in a mysql database and they all need to be marked off as complete (its something for a game), all ID'ed and say, 140th field requires 10 fields to be marked off as complete, inorder for it to be complete.
How would the best way for this to be done?
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
If I knew what "marked off as complete" meant, it'd be helpful[url=http://forums.devnetwork.net/viewtopic.php?t=30037]Forum Rules[/url] Section 1.1 wrote:2. Use descriptive subjects when you start a new thread. Vague titles such as "Help!", "Why?" are misleading and keep you from receiving an answer to your question.
-
d3ad1ysp0rk
- Forum Donator
- Posts: 1661
- Joined: Mon Oct 20, 2003 8:31 pm
- Location: Maine, USA
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
Post your table strucutre(s). Do you seriously have 150 fields in a table?
I think I know what you're asking and you you should be able to create table with users/questions then simply check for the existence of a row which matches the user id to the question ID.
I think I know what you're asking and you you should be able to create table with users/questions then simply check for the existence of a row which matches the user id to the question ID.
Code: Select all
create table user_question_tracker (
id int not null auto_increment primary key,
question_id int,
user_id int,
foreign key(question_id) references question(id),
foreign key(user_id) references user(id)
)- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Descriptive subjects
You were asked on Tuesday to
It is now Thursday and the title is still 'Hello, I need you...'. Any chance that you could maybe change the title to something that would make people want to help you?[url=http://forums.devnetwork.net/viewtopic.php?t=30037]Forum Rules[/url] Section 1.1 wrote:2. Use descriptive subjects when you start a new thread. Vague titles such as "Help!", "Why?" are misleading and keep you from receiving an answer to your question.
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Maybe look at exactly what you are asking, the make the thread title reflect that. But Hello, I need your ... is painfully difficult to assess from a list of topic titles.gaogier wrote:what should i change it to?
its not me whos making it, so i am not 100% sure on whats the problem is, its somone who i know is making it.