jtsymbo

Just a newbie here. I want to use a form to insert multiple records into a table. I have an book club where a person would rank a book (3 to 1) next to a particular book read for a particular month. 3 being the most favorite book read that month and 1 being least favorite. Below is the table the records would be inserted into. Key Month Reader Rank Book 1 January Jim 3 Bible 2 January Jim 2 Koran 3 January Jim 1 Torah How can I have a form where the reader sees only (and fills in) the rank and book text fields, and the Key, Month, and Reader fields are filled in behind the scenes with the default info when the form is submitted (Hidden Fields?). Thanks for any help!!

Now using the above revised table design, I would like to use a form so an individual user could insert new records into the table like this: Auto Key Rank Bob 1 3 B 2 2 D 3 1 A If possible I would like the descending numbers of the ranking to be auto generated, so that the user just fills in the name of the books (D,B,A). But I'm confused about the php programing to get values into the table, because the structure of the form is different than the structure of the table. Thanks for any help!!

Thanks Fenway! But you don't think there are too many repeating rows in the revised table?

Bear with me I'm new at this. I'm having some trouble designing a table that ranks books read by a book club each month. Each reader would rank the assigned books (normally 3) in descending order, 3 being the best.The following output is the result I'm looking for. Rank Jim Bob 3 A B 2 C D 1 B A This is the table design I came up with. I seems to be efficient: key Name Rank 3 Rank 2 Rank 1 1 Bob B D A 2 Jim A C B The above table will work for most months when we will be reading 3 books. But how about a month when we will only be reading 2 books, we would only be ranking only 2 books. With the above table design, there would be a null in the rank 3 row for that month. I would prefer not to have nulls. I thought about it and redesigned the table (below) to be more flexible so that we could read any number of books on any given month but it is not nearly as efficient, i.e. to much redundancy for each column. It takes 6 rows to convey the same amount of information as the above table of 2 rows. Is this a problem, and if so, what should I do? Please help. Thanks!! Key Name Rank Book 1 Bob 3 B 2 Jim 3 A 3 Bob 2 D 4 Jim 2 C 5 Bob 1 A 6 Jim 1 B

Barand, you are the man! Boy, am I glad I found this site. You don't know how long this has stumped me. I'm a newbie, so I'll have to study your code to understand how it works . Thanks again!!

Bear with me, I'm new at this. I have a query that I want to display in a table format on a web page. I call up the following recordset. Name, Color and Rank are the fields. The results of the query are: name color rank jim orange 1 jim blue 2 jim red 3 bob brown 1 bob green 2 bob purple 3 sue gray 1 sue black 2 sue white 3 I want to reconfigure the above results to display in a table format as follows: rank jim bob sue 1 orange brown gray 2 blue green black 3 red purple white Jim, Bob, Sue and rank now become the table headings and the colors associated with those people are in rows ordered by rank. I'm not sure how to approach it. Another forum recommended converting the query into an array, but after much head banging and research I'm not sure how to do it. Thanks for any help!