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 #181575 is a reply to message #181571]

Wed, 22 May 2013 10:34

Doug Miller
Messages: 171
Registered: August 2011

Karma:

Senior Member

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

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

???

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.

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: Thu Nov 28 05:33:04 GMT 2024

Total time taken to generate the page: 0.04352 seconds