yes, i agree and i thank you - the database was built with other needs in mind, then this came up. i'm really wanting to ensure that i don't run into problems later. what you just showed me taught me what i need to know, though.
if i may ask your advice, before i go too far with this, i'll likely want to optimize this whole procedure. may i show you the structure and ask your advice on how i might make room for multiple mp3/video entries per ARTIST?
Code: Select all
CREATE TABLE `stars` (
`customerid` bigint(32) NOT NULL auto_increment,
`clicks` varchar(255) NOT NULL default '',
`picId` varchar(255) NOT NULL default '',
`url` varchar(255) NOT NULL default '',
`firstname` varchar(40) default NULL,
`lastname` varchar(50) default NULL,
`password` varchar(20) default NULL,
`aka` varchar(255) NOT NULL default '',
`title` text NOT NULL,
`genre` varchar(50) NOT NULL default '',
`album` varchar(50) NOT NULL default '',
`email` varchar(255) default NULL,
`website` varchar(255) default NULL,
`city` varchar(50) default NULL,
`state` varchar(50) default NULL,
`talent` varchar(255) default NULL,
`biography` text,
`av` text NOT NULL,
`approved` varchar(11) NOT NULL default '0',
PRIMARY KEY (`customerid`)
) TYPE=MyISAM PACK_KEYS=1 AUTO_INCREMENT=417 ;
the only thing dynamically occurring is that "clicks" is incrementing a click count for each Pic that's displayed in a grid and the script calls for the pics to be rendered ORDER by clicks. individual tables for EACH Pic (Artist) are created to hold a click IP for a given amount of time to prevent hammering clicks (there's value for Pic placement on the grid) - other than that the DB only holds data.
so if each ARTIST only has ONE Pic but several MP3s, would you mind offering a suggestion as to how i might do something for the mp3s? you're right i can see how the array of titles in one field can be a mess. this aftermarket deisgn just came up.
the individual tables won't help - too many queries?
i really appreciate it, anyone,
glenn nall
feyd | Come on now.. I showed you the tags to use for SQL queries..[/color]