Category = "users_rock"; return $this->database= $this->Category; //return $this->database= "indie_dev"; //database } function database_user() { return $this->dbuser ="indie_dev"; //user } function database_password() { return $this->dbpassword="i98uy98nuj098ujo9"; //password } function database_server() { return $this->db_server = "localhost"; //host } function database_connection() { return $this->db = mysql_connect($this->database_server(),$this->database_user(),$this->database_password()); } function country_list() { return $country_array = array('AF'=>'Afghanistan', 'AL'=>'Albania', 'DZ'=>'Algeria', 'AS'=>'American Samoa', 'AD'=>'Andorra', 'AO'=>'Angola', 'AI'=>'Anguilla', 'AQ'=>'Antarctica', 'AG'=>'Antigua and Barbuda', 'AR'=>'Argentina', 'AM'=>'Armenia', 'AW'=>'Aruba', 'AU'=>'Australia', 'AT'=>'Austria', 'AZ'=>'Azerbaidjan', 'BS'=>'Bahamas', 'BH'=>'Bahrain', 'BD'=>'Bangladesh', 'BB'=>'Barbados', 'BY'=>'Belarus', 'BE'=>'Belgium', 'BZ'=>'Belize', 'BJ'=>'Benin', 'BM'=>'Bermuda', 'BT'=>'Bhutan', 'BO'=>'Bolivia', 'BA'=>'Bosnia-Herzegovina', 'BW'=>'Botswana', 'BV'=>'Bouvet Island', 'BR'=>'Brazil', 'BN'=>'Brunei Darussalam', 'BG'=>'Bulgaria', 'BF'=>'Burkina Faso', 'BI'=>'Burundi', 'KH'=>'Cambodia', 'CM'=>'Cameroon', 'CA'=>'Canada', 'CV'=>'Cape Verde', 'KY'=>'Cayman Islands', 'CF'=>'Central African Republic', 'TD'=>'Chad', 'CL'=>'Chile', 'CN'=>'China', 'CX'=>'Christmas Island', 'CC'=>'Cocos - Keeling Islands', 'CO'=>'Colombia', 'KM'=>'Comoros', 'CG'=>'Congo', 'CK'=>'Cook Islands', 'CR'=>'Costa Rica', 'HR'=>'Croatia', 'CU'=>'Cuba', 'CY'=>'Cyprus', 'CZ'=>'Czech Republic', 'DK'=>'Denmark', 'DJ'=>'Djibouti', 'DM'=>'Dominica', 'DO'=>'Dominican Republic', 'TP'=>'East Timor', 'EC'=>'Ecuador', 'EG'=>'Egypt', 'SV'=>'El Salvador', 'GQ'=>'Equatorial Guinea', 'ER'=>'Eritrea', 'EE'=>'Estonia', 'ET'=>'Ethiopia', 'FK'=>'Falkland Islands', 'FO'=>'Faroe Islands', 'FJ'=>'Fiji', 'FI'=>'Finland', 'CS'=>'Former Czechoslovakia', 'SU'=>'Former USSR', 'FR'=>'France', 'GF'=>'French Guyana', 'TF'=>'French Southern Territories', 'GA'=>'Gabon', 'GM'=>'Gambia', 'GE'=>'Georgia', 'DE'=>'Germany', 'GH'=>'Ghana', 'GI'=>'Gibraltar', 'GB'=>'Great Britain', 'GR'=>'Greece', 'GL'=>'Greenland', 'GD'=>'Grenada', 'GP'=>'Guadeloupe - French', 'GU'=>'Guam - USA', 'GT'=>'Guatemala', 'GN'=>'Guinea', 'GW'=>'Guinea Bissau', 'GY'=>'Guyana', 'HT'=>'Haiti', 'HM'=>'Heard and McDonald Islands', 'HN'=>'Honduras', 'HK'=>'Hong Kong', 'HU'=>'Hungary', 'IS'=>'Iceland', 'IN'=>'India', 'ID'=>'Indonesia', 'IR'=>'Iran', 'IQ'=>'Iraq', 'IE'=>'Ireland', 'IL'=>'Israel', 'IT'=>'Italy', 'CI'=>'Ivory Coast', 'JM'=>'Jamaica', 'JP'=>'Japan', 'JO'=>'Jordan', 'KZ'=>'Kazakhstan', 'KE'=>'Kenya', 'KI'=>'Kiribati', 'KW'=>'Kuwait', 'KG'=>'Kyrgyzstan', 'LA'=>'Laos', 'LV'=>'Latvia', 'LB'=>'Lebanon', 'LS'=>'Lesotho', 'LR'=>'Liberia', 'LY'=>'Libya', 'LI'=>'Liechtenstein', 'LT'=>'Lithuania', 'LU'=>'Luxembourg', 'MO'=>'Macau', 'MK'=>'Macedonia', 'MG'=>'Madagascar', 'MW'=>'Malawi', 'MY'=>'Malaysia', 'MV'=>'Maldives', 'ML'=>'Mali', 'MT'=>'Malta', 'MH'=>'Marshall Islands', 'MQ'=>'Martinique', 'MR'=>'Mauritania', 'MU'=>'Mauritius', 'YT'=>'Mayotte', 'MX'=>'Mexico', 'FM'=>'Micronesia', 'MD'=>'Moldavia', 'MC'=>'Monaco', 'MN'=>'Mongolia', 'MS'=>'Montserrat', 'MA'=>'Morocco', 'MZ'=>'Mozambique', 'MM'=>'Myanmar', 'NA'=>'Namibia', 'NR'=>'Nauru', 'NP'=>'Nepal', 'NL'=>'Netherlands', 'AN'=>'Netherlands Antilles', 'NT'=>'Neutral Zone', 'NC'=>'New Caledonia', 'NZ'=>'New Zealand', 'NI'=>'Nicaragua', 'NE'=>'Niger', 'NG'=>'Nigeria', 'NU'=>'Niue', 'NF'=>'Norfolk Island', 'KP'=>'North Korea', 'MP'=>'Northern Mariana Islands', 'NO'=>'Norway', 'OM'=>'Oman', 'PK'=>'Pakistan', 'PW'=>'Palau', 'PA'=>'Panama', 'PG'=>'PapuaewGuinea', 'PY'=>'Paraguay', 'PE'=>'Peru', 'PH'=>'Philippines', 'PN'=>'Pitcairn Island', 'PL'=>'Poland', 'PF'=>'Polynesia', 'PT'=>'Portugal', 'PR'=>'Puerto Rico', 'QA'=>'Qatar', 'RE'=>'Reunion - French', 'RO'=>'Romania', 'RU'=>'Russian Federation', 'RW'=>'Rwanda', 'GS'=>'S. Georgia & S. Sandwich Isls.', 'SH'=>'Saint Helena', 'KN'=>'Saint Kitts & Nevis Anguilla', 'LC'=>'Saint Lucia', 'PM'=>'Saint Pierre and Miquelon', 'ST'=>'Saint Tome and Principe', 'VC'=>'Saint Vincent & Grenadines', 'WS'=>'Samoa', 'SM'=>'San Marino', 'SA'=>'Saudi Arabia', 'SN'=>'Senegal', 'SC'=>'Seychelles', 'SL'=>'Sierra Leone', 'SG'=>'Singapore', 'SK'=>'Slovak Republic', 'SI'=>'Slovenia', 'SB'=>'Solomon Islands', 'SO'=>'Somalia', 'ZA'=>'South Africa', 'KR'=>'South Korea', 'ES'=>'Spain', 'LK'=>'Sri Lanka', 'SD'=>'Sudan', 'SR'=>'Suriname', 'SJ'=>'Svalbard and Jan Mayen Islands', 'SZ'=>'Swaziland', 'SE'=>'Sweden', 'CH'=>'Switzerland', 'SY'=>'Syria', 'TJ'=>'Tadjikistan', 'TW'=>'Taiwan', 'TZ'=>'Tanzania', 'TH'=>'Thailand', 'TG'=>'Togo', 'TK'=>'Tokelau', 'TO'=>'Tonga', 'TT'=>'Trinidad and Tobago', 'TN'=>'Tunisia', 'TR'=>'Turkey', 'TM'=>'Turkmenistan', 'TC'=>'Turks and Caicos Islands', 'TV'=>'Tuvalu', 'UG'=>'Uganda', 'UA'=>'Ukraine', 'AE'=>'United Arab Emirates', 'UK'=>'United Kingdom', 'US'=>'United States', 'UY'=>'Uruguay', 'UZ'=>'Uzbekistan', 'VU'=>'Vanuatu', 'VA'=>'Vatican City State', 'VE'=>'Venezuela', 'VN'=>'Vietnam', 'VI'=>'Virgin Islands - USA', 'WF'=>'Wallis and Futuna Islands', 'EH'=>'Western Sahara', 'YE'=>'Yemen', 'YU'=>'Yugoslavia', 'ZR'=>'Zaire', 'ZM'=>'Zambia', 'ZW'=>'Zimbabwe'); } function state_list() { return $state_array = array('AL'=>'Alabama', 'AK'=>'Alaska', 'AZ'=>'Arizona', 'AR'=>'Arkansas' , 'AR'=>'Arkansas' , 'CA'=>'California', 'CO'=>'Colorado', 'CT'=>'Connecticut', 'DE'=>'Delaware', 'DC'=>'District Of Columbia', 'FL'=>'Florida' , 'GA'=>'Georgia' , 'HI'=>'Hawaii' , 'ID'=>'Idaho', 'IL'=>'Illinois' , 'IN'=>'Indiana', 'IA'=>'Iowa' , 'KS'=>'Kansas' , 'KY'=>'Kentucky' , 'LA'=>'Louisiana' , 'ME'=>'Maine' , 'MD'=>'Maryland' , 'MA'=>'Massachusetts' , 'MI'=>'Michigan' , 'MN'=>'Minnesota' , 'MS'=>'Mississippi' , 'MO'=>'Missouri' , 'MT'=>'Montana' , 'NE'=>'Nebraska' , 'NV'=>'Nevada' , 'NH'=>'New Hampshire' , 'NJ'=>'New Jersey' , 'NM'=>'New Mexico' , 'NY'=>'New York' , 'NC'=>'North Carolina' , 'ND'=>'North Dakota' , 'OH'=>'Ohio' , 'OK'=>'Oklahoma' , 'OR'=>'Oregon' , 'PA'=>'Pennsylvania' , 'RI'=>'Rhode Island' , 'SC'=>'South Carolina' , 'SD'=>'South Dakota' , 'TN'=>'Tennessee' , 'TX'=>'Texas' , 'UT'=>'Utah' , 'VT'=>'Vermont' , 'VA'=>'Virginia' , 'WA'=>'Washington' , 'WV'=>'West Virginia' , 'WI'=>'Wisconsin' , 'WY'=>'Wyoming'); } function industry_category_list() { return $industry_category_array = array('Major_Labels'=>'Major Labels', 'Independent_labels'=>'Independent labels', 'Major_label_Distribution'=>'Major label Distribution', 'Independent_label_Distribution'=>'Independent label Distribution', 'Publishing'=>'Publishing', 'Performing_rights'=>'Performing rights', 'Copyright_clearance'=>'Copyright clearance', 'Artist_management'=>'Artist management', 'Business_management'=>'Business management', 'Artist_Agencies'=>'Artist Agencies', 'Concert_Promotion'=>'Concert Promotion', 'Tour_Management'=>'Tour Management', 'Music_attorneys'=>'Music attorneys', 'Media'=>'Media', 'Publicity'=>'Publicity', 'Record_promotions'=>'Record promotions', 'Video_promotion'=>'Video promotion', 'Associations_and_organizations'=>'Associations and organizations', 'Video_programming'=>'Video programming', 'Music_marketing'=>'Music marketing', 'Independent_engineers'=>'Independent engineers', 'Independent_producers'=>'Independent producers', 'Engineers'=>'Engineers', 'Producer_Management'=>'Producer Management', 'Recording_Studios'=>'Recording Studios', 'Audio_Post_Production'=>'Audio Post Production', 'Video_Post_Production'=>'Video Post Production', 'Film_Post_Production'=>'Film Post Production', 'Remote_Recording_Services'=>'Remote Recording Services', 'Mastering'=>'Mastering', 'Audio_Education'=>'Audio Education', 'Music_Education'=>'Music Education', 'Studio_Suppliers'=>'Studio Suppliers', 'Acoustic_Designers'=>'Acoustic Designers', 'Pro_Audio_Manufactures'=>'Pro Audio Manufactures', 'Equipment_Manufactures'=>'Equipment Manufactures', 'Instrument_Manufactures'=>'Instrument Manufactures', 'Pro_Audio_Equipment'=>'Pro Audio Equipment', 'Pro_Audio_Equipment_Rentals'=>'Pro Audio Equipment Rentals', 'Instrument_sales'=>'Instrument sales', 'Instrument_rentals'=>'Instrument rentals', 'Equipment_Installation'=>'Equipment Installation', 'Equipment_Maintenance'=>'Equipment Maintenance', 'Equipment_Repair'=>'Equipment Repair', 'Equipment_Transport'=>'Equipment Transport', 'Equipment_Storage'=>'Equipment Storage', 'Sound_Design'=>'Sound Design', 'Lighting'=>'Lighting', 'Rehearsal_Studios'=>'Rehearsal Studios', 'Venues'=>'Venues', 'Trade_Events'=>'Trade Events', 'Conferences'=>'Conferences', 'Hotels'=>'Hotels', 'Airlines'=>'Airlines', 'Air_Charters'=>'Air Charters', 'Limousines'=>'Limousines', 'Car_Rentals'=>'Car Rentals', 'Messenger_Services'=>'Messenger Services', 'Insurance_Companies'=>'Insurance Companies', 'Freight_Shipping'=>'Freight / Shipping', 'Security_Services'=>'Security Services', 'CD_Manufacturing'=>'CD Manufacturing', 'DVD_Manufacturing'=>'DVD Manufacturing', 'Tape_Duplication'=>'Tape Duplication', 'Recording_Media_Suppliers'=>'Recording Media Suppliers', 'Printers_and_Packaging'=>'Printers and Packaging', 'Publishers_Print'=>'Publishers Print', 'Publishers_Audio'=>'Publishers Audio', 'Merchandising'=>'Merchandising', 'Designers'=>'Designers', 'Photographers'=>'Photographers', 'Royalty_Free_Music'=>'Royalty Free Music', 'Sound_EFX_Libraries'=>'Sound EFX Libraries', 'Music_Video_Production'=>'Music Video Production', 'Multimedia_Production'=>'Multimedia Production', 'Internet_Marketing'=>'Internet Marketing', 'Promotional_Services'=>'Promotional Services', 'Public_Relations'=>'Public Relations', 'Music_Information Resources'=>'Music Information Resources', 'Music_Web_Sites'=>'Music Web Sites', 'Radio_Stations'=>'Radio Stations', 'Online_Radi_Stations'=>'Online Radio Stations'); } //function genre_list() // { // return $genre_array = array('Alternative','Rock','Classic_Rock','Progressive_Rock','Surf_Rock','Punk','RB','Hip_Hop','Rap','Urban','Industrial','Metal','Death_Metal','Gothic','Ska','Rockabilly','Reggae','Jazz','Acid_Jazz','Lounge','Soul','Blues','Salsa','Samba','DJs','Fusion','House','Go_Go','Garage','Funk','Pop','Disco','Techno','Experimental','New_Age','Spoken_Word','Childrens_Music','Comedy_Music','Novelty_Music','Do_Wop','Romantic','Flamenco','Meringue','Country','Western','Swamp_Music','Blue_Grass','Dixieland','Folk','Gospel','Christian','Spiritual','Choral','Renaissance','Pagan','Medieval','Gregorian_Chant','Opera','Operetta','Swing','Tango','Classical','Contemporary','Theme_music','Musicals','Polka','Marching_bands','Military','Sheet_music','Soundtrack','World_music','Celtic','Gypsy','Indigenous_music','Caribbean','Calypso','Latin_Freestyle','Latin_Jazz','Latin_Pop','African_music','Middle_Eastern'); // } function genre_list() { // return $genre_array = array('Indie_Acoustic','Indie_Alternative','Indie_Hip_Hop','Indie_Metal','Indie_Pop','Indie_Other'); $genre_array = array(); mysql_select_db($this->database(),$this->database_connection()); $result = mysql_query("SELECT PARENT_GENRE_ID, GENRE, DESCRIPTION FROM ADMIN_GENRES ORDER BY GENRE ",$this->db); // $this->result = mysql_query("SELECT * FROM MEMBERS WHERE ( USERNAME LIKE \"$this->myMembers_UpperCase%\" // OR USERNAME LIKE \"$this->myMembers_LowerCase%\" ) AND SITE_LISTED = 'Y' ",$this->db); // $this->myrow = mysql_fetch_array($this->result); // $ShowmyGenre=str_replace("_"," ",$myGenre); while ($myrow = mysql_fetch_array($result,MYSQL_ASSOC)) { $genre_temp = $myrow["GENRE"]; array_push ($genre_array,$genre_temp); } // $arry_temp = ")" // $genre_array = return $arry_temp; return $genre_array; } function alphabet_list() { return $alphabet_array = array('A'=>'a', 'B'=>'b', 'C'=>'c', 'D'=>'d' , 'E'=>'e', 'F'=>'f', 'G'=>'g', 'H'=>'h', 'I'=>'i', 'J'=>'j', 'K'=>'k', 'L'=>'l', 'M'=>'m', 'N'=>'n' , 'O'=>'o' , 'P'=>'p' , 'Q'=>'q' , 'R'=>'r', 'S'=>'s' , 'T'=>'t', 'U'=>'u', 'V'=>'v' , 'W'=>'w', 'X'=>'x', 'Y'=>'y', 'Z'=>'z'); } function category($NewCategory) { $this->Category = $NewCategory; if ( ($this->Category == "bands") || ($this->Category== "clubs") || ($this->Category== "fans") || ($this->Category== "industry") || ($this->Category== "musicians") || ($this->Category== "radio") ) { mysql_select_db($this->database(),$this->database_connection()); $result = mysql_query("SELECT * FROM MEMBERS WHERE SITE_LISTED = 'Y' ",$this->db); $myTotalMembers=mysql_num_rows($result); } if ($this->Category== "bands") { // $this->Category_link = "Bands[$myTotalMembers]"; $this->Category_link = "Bands"; echo $this->Category_link; } elseif ($this->Category== "clubs") { //echo "Clubs[$myTotalMembers]"; echo "Clubs"; } elseif ($this->Category== "fans") { //echo "Fans[$myTotalMembers]"; echo "Fans"; } elseif ($this->Category== "industry") { //echo "Industry[$myTotalMembers]"; echo "Industry"; } elseif ($this->Category== "musicians") { //echo "Musicians[$myTotalMembers]"; echo "Musicians"; } elseif ($this->Category== "radio") { //echo "Radio[$myTotalMembers]"; echo "Radio"; } elseif ($this->Category== "users_rock") { // -- do nothing } else { // ? > // // // // // // // // // // // // // //
Bands
Industry
Clubs
Musicians
Fans
Radio
// < ? } } function temp_category() { return $this->temp_Category = $this->Category ; } function no_record_found() { return $this->no_record_found = "

No record found
"; } function dir_link() { return $this->Category_link; echo $this->Category_link; } function Sort_By() { ?> Category == "industry"){ echo ""; } else { echo ""; } echo ""; echo ""; echo "
Category\">Category
Category\">Genre
Category\">Members
Category\">State
Category\">Country
"; } function home() { echo "

Home
"; } function genre() { $i= 0; ?> genre_list() as $myGenre) { mysql_select_db($this->database(),$this->database_connection()); $result = mysql_query("SELECT * FROM MEMBERS WHERE GENRES=\"$myGenre\" AND SITE_LISTED = 'Y' ",$this->db); $mynumbers=mysql_num_rows($result); $ShowmyGenre=str_replace("_"," ",$myGenre); $Table_String1 = ""; $Table_String2 = ""; $remainder = $i % 2; if($remainder == 0 ) { echo $Table_String1 = ""; $Table_String2 = ""; } $i= $i + 1 ; $number_of_genres = $number_of_genres - 1; ?> "; } if($remainder == 0 && $number_of_genres == 0) { echo $Table_String2 = ""; } } ?>
Category&Genres=$myGenre\" class=\"linkStyleGenre\">$ShowmyGenre [$mynumbers]"; ?>
genre_list() as $myGenre) { mysql_select_db($this->database(),$this->database_connection()); $result = mysql_query("SELECT * FROM MEMBERS WHERE GENRES=\"$myGenre\" AND SITE_LISTED = 'Y' ",$this->db); $mynumbers=mysql_num_rows($result); $ShowmyGenre=str_replace("_"," ",$myGenre); if ($i == 27 || $i == 54){ echo ""; } echo "Category&Genres=$myGenre\" class=\"linkStyleGenre\">$ShowmyGenre [$mynumbers]
" ; $i++; } echo "
"; } function industry_category() { $i = 0; ?>
industry_category_list() as $industry_category => $industry_category_lebel) { mysql_select_db($this->database(),$this->database_connection()); $result = mysql_query("SELECT * FROM MEMBERS WHERE CATEGORY=\"$industry_category\" AND SITE_LISTED = 'Y' ",$this->db); $mynumbers=mysql_num_rows($result); if ($i == 41){ echo ""; } echo "Category&Industry_Category=$industry_category\">$industry_category_lebel[$mynumbers]
"; $i++; } echo "
"; } function alphabet() { ?> alphabet_list() as $upper_case => $lower_case) { mysql_select_db($this->database(),$this->database_connection()); $result = mysql_query("SELECT * FROM MEMBERS WHERE ( USERNAME LIKE \"$upper_case%\" OR USERNAME LIKE \"$lower_case%\" ) AND SITE_LISTED = 'Y'",$this->db); //$mynumbers=mysql_num_rows($result); //if($upper_case == 'N'){ // echo "
"; //} $hyphen_string = "-"; if($upper_case == "Z"){ $hyphen_string = ""; } echo "Category&Upper=$upper_case&Lower=$lower_case\">$upper_case$hyphen_string"; } } function alphabet_temp() { ?> alphabet_list() as $upper_case => $lower_case) { mysql_select_db($this->database(),$this->database_connection()); $result = mysql_query("SELECT * FROM MEMBERS WHERE ( USERNAME LIKE \"$upper_case%\" OR USERNAME LIKE \"$lower_case%\" ) AND SITE_LISTED = 'Y'",$this->db); $mynumbers=mysql_num_rows($result); //if($upper_case == 'N'){ // echo "
"; //} echo "Category&Upper=$upper_case&Lower=$lower_case\">$upper_case-"; } echo ""; } function state() { $i = 0; ?>
state_list() as $state_code => $state) { mysql_select_db($this->database(),$this->database_connection()); $result = mysql_query("SELECT * FROM MEMBERS WHERE STATE=\"$state_code\" AND SITE_LISTED = 'Y' ",$this->db); $mynumbers=mysql_num_rows($result); if ($i == 26){ echo ""; } echo "Category&State=$state_code\" class=\"linkStyleState_Country\">$state [$mynumbers]
"; $i++; } echo "
"; } function country() { $i = 0; ?>
country_list() as $country_code => $country) { mysql_select_db($this->database(),$this->database_connection()); $result = mysql_query("SELECT * FROM MEMBERS WHERE COUNTRY=\"$country_code\" AND SITE_LISTED = 'Y' ",$this->db); $mynumbers=mysql_num_rows($result); if ($i == 60 || $i == 120 || $i == 180){ echo ""; } $i++; echo "Category&Country=$country_code\" class=\"linkStyleState_Country\">$country [$mynumbers]
"; } echo "
"; } function show_by_genre($myGenre,$myStart_Row,$myNumbers_of_Rows,$myPage_Number){ // $this->back = "
Category\">Back

"; //$Start_Row = 30.556556; //$Start_Row = floor($Start_Row); //echo $Start_Row; //$Numbers_of_Rows = 10; $this->Start_Row = $myStart_Row; $this->Numbers_of_Rows = $myNumbers_of_Rows; $this->Page_Number = $myPage_Number; $this->Genre = $myGenre; mysql_select_db($this->database(),$this->database_connection()); $this->result = mysql_query("SELECT * FROM MEMBERS WHERE GENRES =\"$this->Genre\" AND SITE_LISTED = 'Y' ",$this->db); $this->mynumbers=mysql_num_rows($this->result); $this->result = mysql_query("SELECT * FROM MEMBERS WHERE GENRES =\"$this->Genre\" AND SITE_LISTED = 'Y' LIMIT $this->Start_Row,$this->Numbers_of_Rows ",$this->db); $this->myrow = mysql_fetch_array($this->result); $mynumbers=mysql_num_rows($this->result); if($this->myrow ==""){ //echo $this->no_record_found(); return $this->no_record_found(); } } function show_by_industry_category($myIndustry_Category,$myStart_Row,$myNumbers_of_Rows,$myPage_Number){ //$this->back = "
Category\">Back

"; $this->Start_Row = $myStart_Row; $this->Numbers_of_Rows = $myNumbers_of_Rows; $this->Page_Number = $myPage_Number; $this->Industry_Category = $myIndustry_Category; mysql_select_db($this->database(),$this->database_connection()); $this->result = mysql_query("SELECT * FROM MEMBERS WHERE CATEGORY =\"$this->Industry_Category\" AND SITE_LISTED = 'Y' ",$this->db); $this->mynumbers=mysql_num_rows($this->result); $this->result = mysql_query("SELECT * FROM MEMBERS WHERE CATEGORY =\"$this->Industry_Category\" AND SITE_LISTED = 'Y' LIMIT $this->Start_Row,$this->Numbers_of_Rows ",$this->db); $this->myrow = mysql_fetch_array($this->result); $mynumbers=mysql_num_rows($this->result); if($this->myrow==""){ return $this->no_record_found(); } } function show_by_state($myState,$myStart_Row,$myNumbers_of_Rows,$myPage_Number){ //$this->back = "
Category\">Back

"; $this->Start_Row = $myStart_Row; $this->Numbers_of_Rows = $myNumbers_of_Rows; $this->Page_Number = $myPage_Number; $this->State = $myState; mysql_select_db($this->database(),$this->database_connection()); $this->result = mysql_query("SELECT * FROM MEMBERS WHERE STATE =\"$this->State\" AND SITE_LISTED = 'Y' ",$this->db); $this->mynumbers=mysql_num_rows($this->result); $this->result = mysql_query("SELECT * FROM MEMBERS WHERE STATE =\"$this->State\" AND SITE_LISTED = 'Y' LIMIT $this->Start_Row,$this->Numbers_of_Rows ",$this->db); $this->myrow = mysql_fetch_array($this->result); $this->myrow = mysql_fetch_array($this->result); $mynumbers=mysql_num_rows($this->result); if($this->myrow==""){ return $this->no_record_found(); } } function show_by_country($myCountry,$myStart_Row,$myNumbers_of_Rows,$myPage_Number){ // $this->back = "
Category\">Back

"; $this->Start_Row = $myStart_Row; $this->Numbers_of_Rows = $myNumbers_of_Rows; $this->Page_Number = $myPage_Number; $this->Country = $myCountry; mysql_select_db($this->database(),$this->database_connection()); $this->result = mysql_query("SELECT * FROM MEMBERS WHERE COUNTRY =\"$this->Country\" AND SITE_LISTED = 'Y' ",$this->db); $this->mynumbers=mysql_num_rows($this->result); $this->result = mysql_query("SELECT * FROM MEMBERS WHERE COUNTRY =\"$this->Country\" AND SITE_LISTED = 'Y' LIMIT $this->Start_Row,$this->Numbers_of_Rows ",$this->db); $this->myrow = mysql_fetch_array($this->result); $mynumbers=mysql_num_rows($this->result); if($this->myrow==""){ return $this->no_record_found(); } } function search($mySearch,$myStart_Row,$myNumbers_of_Rows,$myPage_Number){ // $this->back = "
Category\">Back

"; $this->Start_Row = $myStart_Row; $this->Numbers_of_Rows = $myNumbers_of_Rows; $this->Page_Number = $myPage_Number; $this->Search = $mySearch; mysql_select_db($this->database(),$this->database_connection()); $this->result = mysql_query("SELECT * FROM MEMBERS WHERE COMPANYNAME Like \"$this->Search%\" AND SITE_LISTED = 'Y' ",$this->db); $this->mynumbers=mysql_num_rows($this->result); $this->result = mysql_query("SELECT * FROM MEMBERS WHERE COMPANYNAME Like \"$this->Search%\" AND SITE_LISTED = 'Y' LIMIT $this->Start_Row,$this->Numbers_of_Rows ",$this->db); $this->myrow = mysql_fetch_array($this->result); $mynumbers=mysql_num_rows($this->result); if($this->myrow==""){ return $this->no_record_found(); } } function show_by_members($myMembers_UpperCase,$myMembers_LowerCase){ // $this->back = "
Category\">Back

"; $this->myMembers_UpperCase = $myMembers_UpperCase; $this->myMembers_LowerCase = $myMembers_LowerCase; mysql_select_db($this->database(),$this->database_connection()); $this->result = mysql_query("SELECT * FROM MEMBERS WHERE ( USERNAME LIKE \"$this->myMembers_UpperCase%\" OR USERNAME LIKE \"$this->myMembers_LowerCase%\" ) AND SITE_LISTED = 'Y' ",$this->db); $this->myrow = mysql_fetch_array($this->result); $mynumbers=mysql_num_rows($this->result); if($this->myrow==""){ return $this->no_record_found(); } } function show_links() { //echo $this->mynumbers % 10; //echo "
"; $temp_float_number_of_pages = $this->mynumbers/10; $number_of_pages = floor($temp_float_number_of_pages); //echo "
"; If ($temp_float_number_of_pages > $number_of_pages){ $number_of_pages = $number_of_pages + 1; } else { $number_of_pages = $number_of_pages + 0; } if($this->no_record_found == ""){ //$users_page_increment = ($number_of_pages - 1 ) * 10; $users = 1; //$users = $users + $users_page_increment; ?>
myrow = mysql_fetch_array($this->result)) { $users++; ?>
myrow["DOMAIN"]; if($this->myrow["DOMAIN"] =="musicgroups.com"){ $link.="/members/"; } else { $link.="/"; } $link.=$this->myrow["USERNAME"]; $link.="/"; if ($this->myrow <> ""){ echo " myrow["DOMAIN"]; if($this->myrow["DOMAIN"] =='musicgroups.com'){ echo "/members/"; } else { echo "/"; } echo $this->myrow["USERNAME"]; echo "/\" class=\"linkStyleNamelisting\" target=\"_blank\"> "; echo $this->myrow["COMPANYNAME"]; echo "
"; ?>
myrow["DESCRIPTION"]; $String_Description = substr($String_Description, 0, 170); $String_Description .= " ..."; echo $String_Description; ?>
myrow["DOMAIN"]; if($this->myrow["DOMAIN"] =="musicgroups.com"){ $link.="/members/"; } else { $link.="/"; } $link.=$this->myrow["USERNAME"]; $link.="/"; echo "myrow["DOMAIN"]; if($this->myrow["DOMAIN"] =='musicgroups.com'){ echo "/members/"; } else { echo "/"; } echo $this->myrow["USERNAME"]; echo "/\" class=\"linkStyleNamelisting\" target=\"_blank\">"; echo $this->myrow["COMPANYNAME"]; echo "
"; ?>
myrow["DESCRIPTION"]; $String_Description = substr($String_Description, 0, 170); $String_Description .= " ..."; echo $String_Description; ?>
Page: "; for ($i=0;$i<$number_of_pages;$i++){ $row_start = $i*10; $page = $i +1; If($this->Genre){ if ($page == $this->Page_Number){ echo "".$page.""; } else { echo " Category&Genres=$this->Genre&Row_Start=$row_start&Numbers_Of_Row=10&Page_Number=$page\">$page "; } } If($this->Industry_Category) { if ($page == $this->Page_Number){ echo "".$page.""; } else { echo " Category&Industry_Category=$this->Industry_Category&Row_Start=$row_start&Numbers_Of_Row=10&Page_Number=$page\">$page "; } } If($this->State) { if ($page == $this->Page_Number){ echo "".$page.""; } else { echo " Category&State=$this->State&Row_Start=$row_start&Numbers_Of_Row=10&Page_Number=$page\">$page "; } } If($this->Country){ if ($page == $this->Page_Number){ echo "".$page.""; } else { echo " Category&Country=$this->Country&Row_Start=$row_start&Numbers_Of_Row=10&Page_Number=$page\">$page "; } } If($this->Search){ if ($page == $this->Page_Number){ echo "".$page.""; } else { echo " Category&Search_Bands=$this->Search&Row_Start=$row_start&Numbers_Of_Row=10&Page_Number=$page\">$page "; } } } echo "
"; */ } else { echo $this->no_record_found; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; echo "
"; } } function show_number_of_pages () { //echo $this->mynumbers % 10; //echo "
"; $temp_float_number_of_pages = $this->mynumbers/10; $number_of_pages = floor($temp_float_number_of_pages); //echo "
"; If ($temp_float_number_of_pages > $number_of_pages){ $number_of_pages = $number_of_pages + 1; } else { $number_of_pages = $number_of_pages + 0; } echo " Page: "; for ($i=0;$i<$number_of_pages;$i++){ $row_start = $i*10; $page = $i +1; If($this->Genre){ if ($page == $this->Page_Number){ echo "".$page.""; } else { echo "
Category&Genres=$this->Genre&Row_Start=$row_start&Numbers_Of_Row=10&Page_Number=$page\">$page "; } } If($this->Industry_Category) { if ($page == $this->Page_Number){ echo "".$page.""; } else { echo "Category&Industry_Category=$this->Industry_Category&Row_Start=$row_start&Numbers_Of_Row=10&Page_Number=$page\">$page "; } } If($this->State) { if ($page == $this->Page_Number){ echo "".$page.""; } else { echo "Category&State=$this->State&Row_Start=$row_start&Numbers_Of_Row=10&Page_Number=$page\">$page "; } } If($this->Country){ if ($page == $this->Page_Number){ echo "".$page.""; } else { echo "Category&Country=$this->Country&Row_Start=$row_start&Numbers_Of_Row=10&Page_Number=$page\">$page "; } } } echo "
"; } function directory_head() { ?> INDIE MUSIC CORNER DIRECTORY - Find New music from around the world!
Featured Artists
Current News
Signup - Login
New member:
User Name :
Password :

Read More>

Read More>

Forget Password? Click Here

Welcome to IndieMusicCorner.com, This site was quicly rebuilt after Rock.com decided to drop the Indie bands involved. We are rebuilding this site and the bigger Musicgroups Network. To gain the revenue required we have developed this special package::

Our all new promotional EPK system (Electronic Press Kit)

This package includes:
Private band pages within our network
A locked banner ad on musicgroups.com
Distribution package
Featured placements on a number of sites
Listing in Yearning.com and Musicgroups.com Directories
Play in our radio systems and Jukebox
Managment advice from our staff
ALL INCLUSIVE PACKAGE FOR $250.00
ALL INCLUSIVE PACKAGE FOR $300.00 w/Review

TODAYS DATE :: echo date ("dS of F Y");?>
Sign-up for our E-Mail Newsletter

Archive: Fall 2005 - Winter 2006

Free music pages for
Independent bands!
Sign Up for Indie Corner
Indie Corner Login
Username
Password
Forget Password?
Need Help?
Check out this great Band
   
Chealsea Doll Going Down International Businessmen
Chelsea Doll
Buy CD:
Eliza's Playground Lyzanxia Veil of Thorns
Eliza's Playground
Buy CD:
Ominous vocals over heavy melodic guitar playing make this dark, brooding song an impressive example of what Peter Criss and Montague can accomplish when they collaborate. Co-written with the Catman. Say hello to Marti Dodson and her defiant anthem Girl Next Door that stands up for women the world over. Moving up Contemporary Hit Radio charts. Los Angeles’s premiere power trio is set to explode. Blues-based Hard Classic Rock.

 

Check out this great Artist
   
Sum Thin Ugly Field of Grey Spoilsport
Sum Thin Ugly
Buy CD:
El 84 Grizzly Online Sam Morrison Band
El84
Buy CD:
The Vue ghengus 23 Vesta

 

 

test
} function directory_foot() { ?>                

Powered by: Musicgroups.com - All Rights Reserved ©Copyright - Proimages.com - Musicgroups.com - Darrin Nupuf - 2004-05- Terms Of Use - Privacy