Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #9525

Re: values not changing

Show all headers | View raw

On 5/21/2013 8:40 PM, richard wrote:
> On Tue, 21 May 2013 22:23:08 +0000 (UTC), Doug Miller wrote:
>
>> richard <noreply@example.com> wrote in news:14jsq8i4oxkxn.r427ym6k6zgn$.dlg@
>> 40tude.net:
>>
>>> www.mroldies.net
>>>
>>> I am attempting to change the play list given the year selected.
>>> However, regardless of which year is chosen, the code selects only the
>>> originally loaded playlist.
>> [...]
>>> $result = mysql_query("SELECT atitle,artist,avid FROM A$year WHERE id =
>>> $number");
>>
>> You have a separate table for each year!? Why?
>
> To me, it's easier keeping track of the data.
> Sure I could easily do it all in one table, adding in yet another column
> for the year.

Or why not have a 'single' column of Year and then just change the value 
of the year for each year record/item

With a separate table per year, among other issues, what if you 
want/need to add an extra data column to the table, you now have to do 
it for each year table to ensure they are all consistent.

It just seems that you are going to have a maintenance & update 
nightmare ahead of you.

>
> When I finish entering ALL of the data I need, there will be around 7,000
> records to deal with.

Another good idea to not separate your tables

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

values not changing richard <noreply@example.com> - 2013-05-21 14:17 -0400
  Re: values not changing Christoph Becker <cmbecker69@gmx.de> - 2013-05-21 20:45 +0200
  Re: values not changing Denis McMahon <denismfmcmahon@gmail.com> - 2013-05-21 21:17 +0000
    Re: values not changing Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2013-05-22 00:22 +0200
    Re: values not changing Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2013-05-22 00:30 +0200
      Re: values not changing Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2013-05-22 00:32 +0200
  Re: values not changing Doug Miller <doug_at_milmac_dot_com@example.com> - 2013-05-21 22:23 +0000
    Re: values not changing "Peter H. Coffin" <hellsop@ninehells.com> - 2013-05-21 21:46 -0500
    Re: values not changing richard <noreply@example.com> - 2013-05-21 23:40 -0400
      Re: values not changing Doug Miller <doug_at_milmac_dot_com@example.com> - 2013-05-22 10:34 +0000
      Re: values not changing Scott Johnson <noonehome@chalupasworld.com> - 2013-05-22 05:41 -0700
  Re: values not changing David Robley <me@home.invalid> - 2013-05-22 10:02 +0930

csiph-web