RE: Best table structure

re in the table. -JF > -Original Message- > From: Tom Chubb [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 30, 2004 5:27 AM > To: [EMAIL PROTECTED] > Subject: Best table structure > > Please can someone let me know their opinion on the following. > I am new to

Re: Best table structure

o.uk>cc: Fax to: 06/30/2004 08:26 Subject: Best table structure

R: Best table structure

> Would I be better keeping this format and inserting multiple rows on each > submit, or to have one row for all 81 variables ($name, 20 x > Position, 20 x > Artists, 20 x Titles, 20 x Labels.) > I know that the latter will be easier to query. Are you sure? Why? > Also, without maintenance, the

Re: Best table structure

Hello Tom, Wednesday, June 30, 2004, 1:26:52 PM, you wrote: TC> My question is this: TC> Would I be better keeping this format and inserting multiple rows on each TC> submit, or to have one row for all 81 variables ($name, 20 x Position, 20 x TC> Artists, 20 x Titles, 20 x Labels.) TC> I know tha

Best table structure

Please can someone let me know their opinion on the following. I am new to MySQL and can't seem to find the right info anywhere. I have written some code for submitting a top 20 music chart online. I use the following to insert into mysql: INSERT INTO chart (name, chartpos, artist, title, label)

Re: Seeking advice on best table structure

* Rajesh Kumar > Roger Baklund unknowingly asked us: > > >>What would be a good way to deal with the following... No, I did not. Scott Haneda asked the question. I replied. :) And I recommended considering the SET column. > But for a couple of reasons, SET is not recommend. > > 1. It introduces f

Re: Seeking advice on best table structure

Roger Baklund unknowingly asked us: What would be a good way to deal with the following... I have a form that has 5 checkboxes on it, lets say the checkboxes are for categories, and more than one can be selected. For example: please tell is what brochure you want [] car [] boat [] truck [] SUV []

Re: Seeking advice on best table structure

* Scott Haneda > What would be a good way to deal with the following... > > I have a form that has 5 checkboxes on it, lets say the > checkboxes are for categories, and more than one can be > selected. > > For example: > please tell is what brochure you want > [] car > [] boat > [] truck > [] SUV >

Re: Seeking advice on best table structure

At 03:30 PM 8/20/2003 -0700, Scott Haneda wrote: What would be a good way to deal with the following... I have a form that has 5 checkboxes on it, lets say the checkboxes are for categories, and more than one can be selected. For example: please tell is what brochure you want [] car [] boat [] tru

Seeking advice on best table structure

What would be a good way to deal with the following... I have a form that has 5 checkboxes on it, lets say the checkboxes are for categories, and more than one can be selected. For example: please tell is what brochure you want [] car [] boat [] truck [] SUV [] beetle I have been asked to provid