Posted by Jochem Maas on 10/12/05 11:37

Suresh Pandian wrote:
> hello friends,
>
> im currently working on creating musical forum.....
> i need to create tables for every song uploaded on the fly to save the comments and rates entered by the viewers.
> im unable to create tables on the fly.........

................................

if I upload 1000 songs to your server then that will ammount to a 1000 tables. and a 1000
songs is nothing.... the whole idea of creating a table for every song is wrong and will get you
into trouble (100,000 songs will crash your system), you only need one table to store
all the comments for each song - and possible one extra table to store the rates for all songs.

> can anyone know how to create tables on the fly .........plz tell me .........

all you need to do is generate an sql query with the CREATE TABLE syntax. and then run it
the same way you would run a normal query - thsi assumes that youre database actually allows
the relevant user to create tables.

> Also, can u tell me the way to how to play the song using php......
> i uploaded the songs to mysql database...
> if u know the same kind of work anywhere in the net as tutorials and help .........plza tell me the URL........

Google for 'Database design' 'Data Normalization' and stuff like that - you seem to be in need
of knowledge regarding how to create a half decent database (one that wont bite you in the ass)

>
> Thanks to all..................
>
> Suresh.P
>
>
> ---------------------------------
> Yahoo! India Matrimony: Find your partner now.

[Back to original message]