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

Groups > comp.lang.php > #9523

Re: values not changing

From Doug Miller <doug_at_milmac_dot_com@example.com>
Newsgroups comp.lang.php
Subject Re: values not changing
Date 2013-05-22 10:34 +0000
Organization A noiseless patient Spider
Message-ID <XnsA1C84388B901Edougmilmaccom@78.46.70.116> (permalink)
References <14jsq8i4oxkxn.r427ym6k6zgn$.dlg@40tude.net> <XnsA1C7BBA8298B3dougmilmaccom@78.46.70.116> <1hd4q922lq4b8$.puef8n3pevc9$.dlg@40tude.net>

Show all headers | View raw

richard <noreply@example.com> wrote in news:1hd4q922lq4b8$.puef8n3pevc9$.dlg@
40tude.net:

> 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.

???

How on earth is fifty separate tables "easier" than ONE table??

> Sure I could easily do it all in one table, adding in yet another column
> for the year.

Well, yes, you could -- after all, that's the way such things are normally done.
> 
> When I finish entering ALL of the data I need, there will be around 7,000
> records to deal with.

And -- ?

As databases go, seven thousand rows is tiny.

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