Thanks. --- Pete <cgrp@xxxxxxxxxxxx> wrote: > In message <fgj5kv+n32c@xxxxxxxxxxx>, Sudhakar > <finals27@xxxxxxxxx> > writes > >my question is when i create the table can i create > the last column in > >a way that would add all the numeric values of the > remaining field > >names. This would avoid me to run an sql query from > a php file to view > >this information. > > You mean, add a column that automatically adds the > other fields > together? The answer to that is no. > > Also, it goes against the principle of good database > design, where the > data should be stored once, and once only. You > would be storing the > data once in the individual fields, and again in the > total field. > > >Ex: Create table tablename(aboutus int(11), > contactus int(11), > >totalvisits int(11)); > > This is not the best layout, because if you add any > new pages, you would > have to change the table layout. > > Better is > Create table tablename(pagename char(20), visitcount > int(11)); > and use the SUM command to get the total visits. > > -- > Pete Clark > > Sunny Andalucia > http://hotcosta.com/Andalucia.Spain > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
