FUDforum: comp.lang.php » values not changing

Home » Imported messages » comp.lang.php » values not changing

Show: Today's Messages :: Polls :: Message Navigator

Re: values not changing [message #181577 is a reply to message #181571]

Wed, 22 May 2013 12:41

Scott Johnson
Messages: 196
Registered: January 2012

Karma:

Senior Member

On 5/21/2013 8:40 PM, richard wrote:
> On Tue, 21 May 2013 22:23:08 +0000 (UTC), Doug Miller wrote:
>
>> richard <noreply(at)example(dot)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

Report message to a moderator

[Message index]

		values not changing By: richard on Tue, 21 May 2013 18:17
		Re: values not changing By: Christoph Becker on Tue, 21 May 2013 18:45
		Re: values not changing By: Denis McMahon on Tue, 21 May 2013 21:17
		Re: values not changing By: Thomas 'PointedEars' on Tue, 21 May 2013 22:22
		Re: values not changing By: Thomas 'PointedEars' on Tue, 21 May 2013 22:30
		Re: values not changing By: Thomas 'PointedEars' on Tue, 21 May 2013 22:32
		Re: values not changing By: Doug Miller on Tue, 21 May 2013 22:23
		Re: values not changing By: Peter H. Coffin on Wed, 22 May 2013 02:46
		Re: values not changing By: richard on Wed, 22 May 2013 03:40
		Re: values not changing By: Doug Miller on Wed, 22 May 2013 10:34
		Re: values not changing By: Scott Johnson on Wed, 22 May 2013 12:41
		Re: values not changing By: David Robley on Wed, 22 May 2013 00:32

Previous Topic:	insert PDF table in database
Next Topic:	Got it working finally

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 18 21:46:36 GMT 2025

Total time taken to generate the page: 0.03264 seconds