mysql_select_db(): supplied argument is not a valid MySQL-Link resource on line 51

Question

hmkk 0 Newbie Poster

15 Years Ago

hello, i am new to php and i am problem whie installing classifieds

my database is hitech_classifieds and username is hitech_admin

Please tell me how should i write that info in the following code so the errror doesn;t come

<?php
$haserrors=FALSE;
function print_sql_error(){
    global $haserrors;
    $haserrors=TRUE;
    print('<font color="#FF0000">' . mysql_error() . "</font><br>");
}

?><html>
<head>
<title>Install 68Classifieds</title>
<STYLE type="text/css">
<!--
p {  font: 10pt Verdana, Arial, Helvetica, sans-serif}
TD {  font: 10pt Verdana, Arial, Helvetica, sans-serif}
BODY {  font: 10pt Verdana, Arial, Helvetica, sans-serif}
-->
</STYLE>
</head>
<body>
<?php ('/Connections/classifieds.php'); ?>
<table width="780" border="0" align="center" cellpadding="1" cellspacing="0" bgcolor="#000000" class="main" summary="maintable">
<tr>
    <td>
<table width="780" border="0" cellspacing="3" cellpadding="0" bgcolor="#FFFFFF">
<tr><td><img src="images/logo.gif"></td></tr>
        <tr> 
          <td valign="top">
<?php
mysql_select_db($sumdueu_urworld, $sumdueu_admin);
if(@$_POST["posted"]=="1"){
    mysql_query("DROP TABLE IF EXISTS activityLog,admin,affiliates,cartproducts,categories,countries,image_settings,payment,prodimages,products,products_categories,reviews,settings,states,users") or print_sql_error();

        $sSQL = "CREATE TABLE admin (
          id int(11) NOT NULL auto_increment,
          title varchar(255) default NULL,
          keywords varchar(255) default NULL,
          description text,
          url varchar(255) default NULL,
          email varchar(255) default NULL,
          notify char(1) default NULL,
          maximage int(11) default '4',
          username varchar(255) default NULL,
          password varchar(255) default NULL,
          version varchar(255) default 'v1.1',
          mainTemplate varchar(255) NOT NULL default 'templates/default',
          mainLanguage varchar(255) NOT NULL default 'language/english.php',
          mainSearch char(1) NOT NULL default '5',
          mainIndexCols char(1) NOT NULL default '2',
          mainCatCols char(1) NOT NULL default '3',
          mainSubCols char(1) NOT NULL default '2',
          mainProductSort varchar(255) NOT NULL default 'id',
          mainProductSortOption varchar(255) NOT NULL default 'DESC',
          mainRateMember char(1) NOT NULL default 'Y',
          mainExternalURL char(1) NOT NULL default 'Y',
          mainTakeOffline char(1) NOT NULL default 'N',
          mainTakeOfflineReason text NOT NULL,
          PRIMARY KEY  (id)
        ) TYPE=MyISAM;";
        mysql_query($sSQL) or print_sql_error();

            $sSQL = "INSERT INTO admin VALUES (1, '68 Classifieds', 'keywords, go, here', 'Your site description', 'http://www.68classifieds.com', 'info@68classifieds.com', 'Y', 4, 'admin', 'mypass', '68Classifieds Professional V2.0.3', 'template/default', 'language/english.php', '15', '2', '3', '2', 'id', 'DESC', 'Y', 'Y', 'N', 'Reason why your site is offline');";
            mysql_query($sSQL) or print_sql_error();

    // reviews //
        $sSQL = "CREATE TABLE `reviews` (
                        `revID` VARCHAR( 11 ) NOT NULL ,
                        `revDate` DATE NOT NULL ,
                        `revPerson` VARCHAR( 30 ) NOT NULL ,
                        `revReview` LONGTEXT NOT NULL ,
                        `revScore` INT( 11 ) NOT NULL,
                        `revEmail`VARCHAR( 255 ) NOT NULL
                        );";
        mysql_query($sSQL) or print_sql_error();

        //activity log//
        $sSQL = "CREATE TABLE `activityLog` (
                      `id` int(11) NOT NULL auto_increment,
                      `user` varchar(255) NOT NULL default '',
                      `action` text NOT NULL,
                      `ip_address` varchar(55) NOT NULL default '',
                      `log_date` date NOT NULL default '0000-00-00',
                      PRIMARY KEY  (`id`)
                    );";
        mysql_query($sSQL) or print_sql_error();

        //affiliates//
        $sSQL = "CREATE TABLE `affiliates` (
          `id` int(11) NOT NULL auto_increment,
          `firstname` varchar(100) default NULL,
          `lastname` varchar(255) default NULL,
          `address` varchar(255) default NULL,
          `city` varchar(75) default NULL,
          `state` varchar(75) default NULL,
          `zip` varchar(50) default NULL,
          `country` varchar(50) default NULL,
          `email` varchar(125) default NULL,
          `phone` varchar(50) default NULL,
          `newsletter` char(1) default 'N',
          `username` varchar(255) default NULL,
          `password` varchar(255) default NULL,
          `level` int(5) default '1',
          PRIMARY KEY  (`id`),
          UNIQUE KEY `ordID` (`id`),
          KEY `ordID_2` (`id`)
        ) TYPE=MyISAM AUTO_INCREMENT=1 ;";
    mysql_query($sSQL) or print_sql_error();

    $sSQL = "CREATE TABLE `cartproducts` (
      `id` int(11) NOT NULL auto_increment,
      `title` varchar(255) NOT NULL default '',
      `description` text NOT NULL,
      `price` varchar(15) NOT NULL default '',
      `listprice` varchar(15) default NULL,
      `featured` char(1) default 'N',
      `images` char(1) default 'N',
      `numimages` int(10) default '0',
      `expiration` varchar(255) default NULL,
      PRIMARY KEY  (`id`))";
mysql_query($sSQL) or print_sql_error();

mysql_query("INSERT INTO `cartproducts` VALUES (1, 'Free Ad', 'Free Ad with out a photo.', '0.1', NULL, 'N', 'N', 0, '1');");
mysql_query("INSERT INTO `cartproducts` VALUES (2, 'Photo Ad', 'Place a Photo Ad', '4.99', '9.99', 'N', 'Y', 2, '2');");
mysql_query("INSERT INTO `cartproducts` VALUES (3, 'Featured Photo Ad', 'Featured Photo Ad with up to 4 images.', '9.99', '19.99', 'Y', 'Y', 4, '3');");

    $sSQL = "CREATE TABLE `categories` (
  `id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) NOT NULL default '0',
  `name` varchar(25) NOT NULL default '',
  `description` varchar(255) default NULL,
  `image` varchar(255) default NULL,
  `allowads` char(2) default NULL,
  `display` char(1) NOT NULL default 'Y',
  PRIMARY KEY  (`id`),
  KEY `parent_id` (`parent_id`),
  KEY `name` (`name`)
) TYPE=MyISAM;";
      mysql_query($sSQL) or print_sql_error();
        mysql_query("INSERT INTO categories VALUES (1, 0, 'ATV', 'ATV Classifieds', NULL, NULL,'Y');");
        mysql_query("INSERT INTO categories VALUES (2, 1, 'ATV Parts & Acc', 'ATV Parts & Acc', '', 'Y','Y');");
        mysql_query("INSERT INTO categories VALUES (3, 1, 'Sport ATVS', 'Sport ATV\'s for sale', NULL, '1','Y');");
        mysql_query("INSERT INTO categories VALUES (8, 5, 'Sportbike Parts', 'Sportbike Parts & Acc', NULL, '1','Y');");
        mysql_query("INSERT INTO categories VALUES (5, 0, 'Sportbikes', 'Sportbikes', NULL, NULL,'Y');");

    $sSQL = "CREATE TABLE `countries` (
                  `countryID` int(11) NOT NULL default '0',
                  `countryName` varchar(100) default NULL,
                  `countryEnabled` tinyint(4) default NULL,
                  `countryCode` varchar(50) default NULL,
                  PRIMARY KEY  (`countryID`),
                  UNIQUE KEY `countryID` (`countryID`),
                  KEY `countryID_2` (`countryID`)
                ) TYPE=MyISAM;";
    mysql_query($sSQL) or print_sql_error();

mysql_query("INSERT INTO `countries` VALUES (1, 'United States of America', 1, 'US');");
mysql_query("INSERT INTO `countries` VALUES (2, 'Canada', 1, 'CA');");
mysql_query("INSERT INTO `countries` VALUES (3, 'Afghanistan', 1, 'AF');");
mysql_query("INSERT INTO `countries` VALUES (4, 'Albania', 1, 'AL');");
mysql_query("INSERT INTO `countries` VALUES (5, 'Algeria', 1, 'DZ');");
mysql_query("INSERT INTO `countries` VALUES (6, 'Andorra', 1, 'AD');");
mysql_query("INSERT INTO `countries` VALUES (7, 'Angola', 0, 'AO');");
mysql_query("INSERT INTO `countries` VALUES (8, 'Anguilla', 0, 'AI');");
mysql_query("INSERT INTO `countries` VALUES (10, 'Antigua and Barbuda', 0, 'AG');");
mysql_query("INSERT INTO `countries` VALUES (11, 'Argentina', 0, 'AR');");
mysql_query("INSERT INTO `countries` VALUES (12, 'Armenia', 0, 'AM');");
mysql_query("INSERT INTO `countries` VALUES (13, 'Aruba', 0, 'AW');");
mysql_query("INSERT INTO `countries` VALUES (14, 'Australia', 0, 'AU');");
mysql_query("INSERT INTO `countries` VALUES (15, 'Austria', 0, 'AT');");
mysql_query("INSERT INTO `countries` VALUES (16, 'Azerbaijan', 0, 'AZ');");
mysql_query("INSERT INTO `countries` VALUES (17, 'Bahamas', 1, 'BS');");
mysql_query("INSERT INTO `countries` VALUES (18, 'Bahrain', 0, 'BH');");
mysql_query("INSERT INTO `countries` VALUES (19, 'Bangladesh', 0, 'BD');");
mysql_query("INSERT INTO `countries` VALUES (20, 'Barbados', 1, 'BB');");
mysql_query("INSERT INTO `countries` VALUES (21, 'Belarus', 0, 'BY');");
mysql_query("INSERT INTO `countries` VALUES (22, 'Belgium', 1, 'BE');");
mysql_query("INSERT INTO `countries` VALUES (23, 'Belize', 0, 'BZ');");
mysql_query("INSERT INTO `countries` VALUES (24, 'Benin', 0, 'BJ');");
mysql_query("INSERT INTO `countries` VALUES (25, 'Bermuda', 1, 'BM');");
mysql_query("INSERT INTO `countries` VALUES (26, 'Bhutan', 0, 'BT');");
mysql_query("INSERT INTO `countries` VALUES (27, 'Bolivia', 0, 'BO');");
mysql_query("INSERT INTO `countries` VALUES (28, 'Bosnia-Herzegovina', 0, 'BA');");
mysql_query("INSERT INTO `countries` VALUES (29, 'Botswana', 0, 'BW');");
mysql_query("INSERT INTO `countries` VALUES (30, 'Brazil', 0, 'BR');");
mysql_query("INSERT INTO `countries` VALUES (31, 'Brunei Darussalam', 0, 'BN');");
mysql_query("INSERT INTO `countries` VALUES (32, 'Bulgaria', 0, 'BG');");
mysql_query("INSERT INTO `countries` VALUES (33, 'Burkina Faso', 0, 'BF');");
mysql_query("INSERT INTO `countries` VALUES (34, 'Burundi', 0, 'BI');");
mysql_query("INSERT INTO `countries` VALUES (35, 'Cambodia', 1, 'KH');");
mysql_query("INSERT INTO `countries` VALUES (36, 'Cameroon', 0, 'CM');");
mysql_query("INSERT INTO `countries` VALUES (37, 'Cape Verde', 1, 'CV');");
mysql_query("INSERT INTO `countries` VALUES (38, 'Cayman Islands', 1, 'KY');");
mysql_query("INSERT INTO `countries` VALUES (39, 'Central African Republic', 1, 'CF');");
mysql_query("INSERT INTO `countries` VALUES (40, 'Chad', 1, 'TD');");
mysql_query("INSERT INTO `countries` VALUES (41, 'Chile', 0, 'CL');");
mysql_query("INSERT INTO `countries` VALUES (42, 'China', 0, 'CN');");
mysql_query("INSERT INTO `countries` VALUES (43, 'Colombia', 1, 'CO');");
mysql_query("INSERT INTO `countries` VALUES (44, 'Comoros', 1, 'KM');");
mysql_query("INSERT INTO `countries` VALUES (45, 'Costa Rica', 1, 'CR');");
mysql_query("INSERT INTO `countries` VALUES (46, 'Croatia', 0, 'HR');");
mysql_query("INSERT INTO `countries` VALUES (47, 'Cuba', 1, 'CU');");
mysql_query("INSERT INTO `countries` VALUES (48, 'Cyprus', 1, 'CY');");
mysql_query("INSERT INTO `countries` VALUES (49, 'Czech Republic', 1, 'CZ');");
mysql_query("INSERT INTO `countries` VALUES (50, 'Denmark', 1, 'DK');");
mysql_query("INSERT INTO `countries` VALUES (51, 'Djibouti', 1, 'DJ');");
mysql_query("INSERT INTO `countries` VALUES (52, 'Dominica', 1, 'DM');");
mysql_query("INSERT INTO `countries` VALUES (53, 'Dominican Republic', 1, 'DO');");
mysql_query("INSERT INTO `countries` VALUES (54, 'East Timor', 0, 'TP');");
mysql_query("INSERT INTO `countries` VALUES (55, 'Ecuador', 0, 'EC');");
mysql_query("INSERT INTO `countries` VALUES (56, 'Egypt', 0, 'EG');");
mysql_query("INSERT INTO `countries` VALUES (57, 'El Salvador', 0, 'SV');");
mysql_query("INSERT INTO `countries` VALUES (58, 'Equatorial Guinea', 0, 'GQ');");
mysql_query("INSERT INTO `countries` VALUES (59, 'Estonia', 0, 'EE');");
mysql_query("INSERT INTO `countries` VALUES (60, 'Ethiopia', 0, 'ET');");
mysql_query("INSERT INTO `countries` VALUES (61, 'Falkland Islands', 0, 'FK');");
mysql_query("INSERT INTO `countries` VALUES (62, 'Faroe Islands', 0, 'FO');");
mysql_query("INSERT INTO `countries` VALUES (63, 'Fiji', 0, 'FJ');");
mysql_query("INSERT INTO `countries` VALUES (64, 'Finland', 0, 'FI');");
mysql_query("INSERT INTO `countries` VALUES (65, 'France', 1, 'FR');");
mysql_query("INSERT INTO `countries` VALUES (66, 'French Guiana', 0, 'GF');");
mysql_query("INSERT INTO `countries` VALUES (67, 'French Polynesia', 0, 'PF');");
mysql_query("INSERT INTO `countries` VALUES (68, 'Gabon', 0, 'GA');");
mysql_query("INSERT INTO `countries` VALUES (69, 'Gambia', 0, 'GM');");
mysql_query("INSERT INTO `countries` VALUES (70, 'Georgia, Republic of', 0, 'GE');");
mysql_query("INSERT INTO `countries` VALUES (71, 'Germany', 1, 'DE');");
mysql_query("INSERT INTO `countries` VALUES (72, 'Ghana', 0, 'GH');");
mysql_query("INSERT INTO `countries` VALUES (73, 'Gibraltar', 0, 'GI');");
mysql_query("INSERT INTO `countries` VALUES (74, 'Greece', 1, 'GR');");
mysql_query("INSERT INTO `countries` VALUES (75, 'Greenland', 1, 'GL');");
mysql_query("INSERT INTO `countries` VALUES (76, 'Grenada', 0, 'GD');");
mysql_query("INSERT INTO `countries` VALUES (77, 'Guadeloupe', 0, 'GP');");
mysql_query("INSERT INTO `countries` VALUES (78, 'Guam', 1, 'GU');");
mysql_query("INSERT INTO `countries` VALUES (79, 'Guatemala', 0, 'GT');");
mysql_query("INSERT INTO `countries` VALUES (80, 'Guinea', 0, 'GN');");
mysql_query("INSERT INTO `countries` VALUES (81, 'Guinea-Bissau', 0, 'GW');");
mysql_query("INSERT INTO `countries` VALUES (82, 'Guyana', 0, 'GY');");
mysql_query("INSERT INTO `countries` VALUES (83, 'Haiti', 1, 'HT');");
mysql_query("INSERT INTO `countries` VALUES (84, 'Honduras', 1, 'HN');");
mysql_query("INSERT INTO `countries` VALUES (85, 'Hong Kong', 1, 'HK');");
mysql_query("INSERT INTO `countries` VALUES (86, 'Hungary', 1, 'HU');");
mysql_query("INSERT INTO `countries` VALUES (87, 'Iceland', 1, 'IS');");
mysql_query("INSERT INTO `countries` VALUES (88, 'India', 1, 'IN');");
mysql_query("INSERT INTO `countries` VALUES (89, 'Indonesia', 1, 'ID');");
mysql_query("INSERT INTO `countries` VALUES (90, 'Iraq', 0, 'IQ');");
mysql_query("INSERT INTO `countries` VALUES (91, 'Ireland', 1, 'IE');");
mysql_query("INSERT INTO `countries` VALUES (92, 'Israel', 1, 'IL');");
mysql_query("INSERT INTO `countries` VALUES (93, 'Italy', 1, 'IT');");
mysql_query("INSERT INTO `countries` VALUES (94, 'Jamaica', 1, 'JM');");
mysql_query("INSERT INTO `countries` VALUES (95, 'Japan', 1, 'JP');");
mysql_query("INSERT INTO `countries` VALUES (96, 'Jordan', 1, 'JO');");
mysql_query("INSERT INTO `countries` VALUES (97, 'Kazakhstan', 0, 'KZ');");
mysql_query("INSERT INTO `countries` VALUES (98, 'Kenya', 0, 'KE');");
mysql_query("INSERT INTO `countries` VALUES (99, 'Kiribati', 0, 'KI');");
mysql_query("INSERT INTO `countries` VALUES (100, 'North Korea', 0, 'KP');");
mysql_query("INSERT INTO `countries` VALUES (101, 'South Korea', 0, 'KR');");
mysql_query("INSERT INTO `countries` VALUES (102, 'Kuwait', 0, 'KW');");
mysql_query("INSERT INTO `countries` VALUES (103, 'Latvia', 0, 'LV');");
mysql_query("INSERT INTO `countries` VALUES (104, 'Lebanon', 0, 'LB');");
mysql_query("INSERT INTO `countries` VALUES (105, 'Lesotho', 0, 'LS');");
mysql_query("INSERT INTO `countries` VALUES (106, 'Liberia', 0, 'LR');");
mysql_query("INSERT INTO `countries` VALUES (107, 'England', 1, 'EN');");
mysql_query("INSERT INTO `countries` VALUES (108, 'Liechtenstein', 0, 'LI');");
mysql_query("INSERT INTO `countries` VALUES (109, 'Lithuania', 0, 'LT');");
mysql_query("INSERT INTO `countries` VALUES (110, 'Luxembourg', 0, 'LU');");
mysql_query("INSERT INTO `countries` VALUES (111, 'Macao', 0, 'MO');");
mysql_query("INSERT INTO `countries` VALUES (112, 'Macedonia, Republic of', 0, 'MK');");
mysql_query("INSERT INTO `countries` VALUES (113, 'Madagascar', 0, 'MG');");
mysql_query("INSERT INTO `countries` VALUES (114, 'Malawi', 0, 'MW');");
mysql_query("INSERT INTO `countries` VALUES (115, 'Malaysia', 0, 'MY');");
mysql_query("INSERT INTO `countries` VALUES (116, 'Maldives', 0, 'MV');");
mysql_query("INSERT INTO `countries` VALUES (117, 'Mali', 0, 'ML');");
mysql_query("INSERT INTO `countries` VALUES (118, 'Malta', 0, 'MT');");
mysql_query("INSERT INTO `countries` VALUES (119, 'Martinique', 0, 'MQ');");
mysql_query("INSERT INTO `countries` VALUES (120, 'Mauritania', 0, 'MR');");
mysql_query("INSERT INTO `countries` VALUES (121, 'Mauritius', 0, 'MU');");
mysql_query("INSERT INTO `countries` VALUES (122, 'Mexico', 1, 'MX');");
mysql_query("INSERT INTO `countries` VALUES (123, 'Moldova', 0, 'MD');");
mysql_query("INSERT INTO `countries` VALUES (124, 'Monaco', 0, 'MC');");
mysql_query("INSERT INTO `countries` VALUES (125, 'Mongolia', 0, 'MN');");
mysql_query("INSERT INTO `countries` VALUES (126, 'Montserrat', 0, 'MS');");
mysql_query("INSERT INTO `countries` VALUES (127, 'Morocco', 0, 'MA');");
mysql_query("INSERT INTO `countries` VALUES (128, 'Mozambique', 0, 'MZ');");
mysql_query("INSERT INTO `countries` VALUES (129, 'Myanmar', 0, 'MM');");
mysql_query("INSERT INTO `countries` VALUES (130, 'Namibia', 0, 'NA');");
mysql_query("INSERT INTO `countries` VALUES (131, 'Nauru', 0, 'NR');");
mysql_query("INSERT INTO `countries` VALUES (132, 'Nepal', 0, 'NP');");
mysql_query("INSERT INTO `countries` VALUES (133, 'Netherlands', 1, 'NL');");
mysql_query("INSERT INTO `countries` VALUES (134, 'Netherlands Antilles', 0, 'AN');");
mysql_query("INSERT INTO `countries` VALUES (135, 'New Caledonia', 0, 'NC');");
mysql_query("INSERT INTO `countries` VALUES (136, 'New Zealand', 1, 'NZ');");
mysql_query("INSERT INTO `countries` VALUES (137, 'Nicaragua', 0, 'NI');");
mysql_query("INSERT INTO `countries` VALUES (138, 'Niger', 0, 'NE');");
mysql_query("INSERT INTO `countries` VALUES (139, 'Nigeria', 1, 'NG');");
mysql_query("INSERT INTO `countries` VALUES (140, 'Niue', 0, 'NU');");
mysql_query("INSERT INTO `countries` VALUES (141, 'Norfolk Island', 0, 'NF');");
mysql_query("INSERT INTO `countries` VALUES (142, 'Northern Ireland', 0, 'NB');");
mysql_query("INSERT INTO `countries` VALUES (143, 'Norway', 0, 'NO');");
mysql_query("INSERT INTO `countries` VALUES (144, 'Oman', 0, 'OM');");
mysql_query("INSERT INTO `countries` VALUES (145, 'Pakistan', 0, 'PK');");
mysql_query("INSERT INTO `countries` VALUES (146, 'Panama', 0, 'PA');");
mysql_query("INSERT INTO `countries` VALUES (147, 'Papua New Guinea', 0, 'PG');");
mysql_query("INSERT INTO `countries` VALUES (148, 'Paraguay', 0, 'PY');");
mysql_query("INSERT INTO `countries` VALUES (149, 'Peru', 0, 'PE');");
mysql_query("INSERT INTO `countries` VALUES (150, 'Philippines', 0, 'PH');");
mysql_query("INSERT INTO `countries` VALUES (151, 'Pitcairn Island', 0, 'PN');");
mysql_query("INSERT INTO `countries` VALUES (152, 'Poland', 0, 'PL');");
mysql_query("INSERT INTO `countries` VALUES (153, 'Portugal', 0, 'PT');");
mysql_query("INSERT INTO `countries` VALUES (154, 'Qatar', 0, 'QA');");
mysql_query("INSERT INTO `countries` VALUES (155, 'Reunion', 0, 'RE');");
mysql_query("INSERT INTO `countries` VALUES (156, 'Romania', 0, 'RO');");
mysql_query("INSERT INTO `countries` VALUES (157, 'Russia', 0, 'RU');");
mysql_query("INSERT INTO `countries` VALUES (158, 'Rwanda', 0, 'RW');");
mysql_query("INSERT INTO `countries` VALUES (159, 'Saint Kitts', 0, 'KN');");
mysql_query("INSERT INTO `countries` VALUES (160, 'Saint Lucia', 0, 'LC');");
mysql_query("INSERT INTO `countries` VALUES (161, 'Saint Vincent and the Grenadines', 0, 'VC');");
mysql_query("INSERT INTO `countries` VALUES (162, 'Western Samoa', 0, 'WS');");
mysql_query("INSERT INTO `countries` VALUES (163, 'San Marino', 0, 'SM');");
mysql_query("INSERT INTO `countries` VALUES (164, 'Sao Tome and Principe', 0, 'ST');");
mysql_query("INSERT INTO `countries` VALUES (165, 'Saudi Arabia', 0, 'SA');");
mysql_query("INSERT INTO `countries` VALUES (166, 'Senegal', 0, 'SN');");
mysql_query("INSERT INTO `countries` VALUES (167, 'Seychelles', 0, 'SC');");
mysql_query("INSERT INTO `countries` VALUES (168, 'Sierra Leone', 0, 'SL');");
mysql_query("INSERT INTO `countries` VALUES (169, 'Singapore', 0, 'SG');");
mysql_query("INSERT INTO `countries` VALUES (170, 'Slovak Republic', 0, 'SK');");
mysql_query("INSERT INTO `countries` VALUES (171, 'Slovenia', 0, 'SI');");
mysql_query("INSERT INTO `countries` VALUES (172, 'Solomon Islands', 0, 'SB');");
mysql_query("INSERT INTO `countries` VALUES (173, 'Somalia', 0, 'SO');");
mysql_query("INSERT INTO `countries` VALUES (174, 'South Africa', 0, 'ZA');");
mysql_query("INSERT INTO `countries` VALUES (175, 'Spain', 0, 'ES');");
mysql_query("INSERT INTO `countries` VALUES (176, 'Sri Lanka', 0, 'LK');");
mysql_query("INSERT INTO `countries` VALUES (177, 'Saint Helena', 0, 'SH');");
mysql_query("INSERT INTO `countries` VALUES (178, 'Saint Pierre and Miquelon', 0, 'PM');");
mysql_query("INSERT INTO `countries` VALUES (179, 'Sudan', 0, 'SD');");
mysql_query("INSERT INTO `countries` VALUES (180, 'Suriname', 0, 'SR');");
mysql_query("INSERT INTO `countries` VALUES (181, 'Swaziland', 0, 'SZ');");
mysql_query("INSERT INTO `countries` VALUES (182, 'Sweden', 0, 'SE');");
mysql_query("INSERT INTO `countries` VALUES (183, 'Switzerland', 0, 'CH');");
mysql_query("INSERT INTO `countries` VALUES (184, 'Syrian Arab Republic', 0, 'SY');");
mysql_query("INSERT INTO `countries` VALUES (185, 'Taiwan', 0, 'TW');");
mysql_query("INSERT INTO `countries` VALUES (186, 'Tajikistan', 0, 'TJ');");
mysql_query("INSERT INTO `countries` VALUES (187, 'Tanzania', 0, 'TZ');");
mysql_query("INSERT INTO `countries` VALUES (188, 'Thailand', 0, 'TH');");
mysql_query("INSERT INTO `countries` VALUES (189, 'Togo', 0, 'TG');");
mysql_query("INSERT INTO `countries` VALUES (190, 'Tokelau', 0, 'TK');");
mysql_query("INSERT INTO `countries` VALUES (191, 'Tonga', 0, 'TO');");
mysql_query("INSERT INTO `countries` VALUES (192, 'Trinidad and Tobago', 0, 'TT');");
mysql_query("INSERT INTO `countries` VALUES (193, 'Tunisia', 0, 'TN');");
mysql_query("INSERT INTO `countries` VALUES (194, 'Turkey', 1, 'TR');");
mysql_query("INSERT INTO `countries` VALUES (195, 'Turkmenistan', 0, 'TM');");
mysql_query("INSERT INTO `countries` VALUES (196, 'Turks and Caicos Islands', 0, 'TC');");
mysql_query("INSERT INTO `countries` VALUES (197, 'Tuvalu', 0, 'TV');");
mysql_query("INSERT INTO `countries` VALUES (198, 'Uganda', 0, 'UG');");
mysql_query("INSERT INTO `countries` VALUES (199, 'Ukraine', 0, 'UA');");
mysql_query("INSERT INTO `countries` VALUES (200, 'United Arab Emirates', 1, 'AE');");
mysql_query("INSERT INTO `countries` VALUES (201, 'Great Britain and Northern Ireland', 1, 'GB');");
mysql_query("INSERT INTO `countries` VALUES (202, 'Uruguay', 0, 'UY');");
mysql_query("INSERT INTO `countries` VALUES (203, 'Uzbekistan', 0, 'UZ');");
mysql_query("INSERT INTO `countries` VALUES (204, 'Vanuatu', 0, 'VU');");
mysql_query("INSERT INTO `countries` VALUES (205, 'Vatican City', 0, 'VA');");
mysql_query("INSERT INTO `countries` VALUES (206, 'Venezuela', 1, 'VE');");
mysql_query("INSERT INTO `countries` VALUES (207, 'Vietnam', 1, 'VN');");
mysql_query("INSERT INTO `countries` VALUES (208, 'British Virgin Islands', 0, 'VG');");
mysql_query("INSERT INTO `countries` VALUES (209, 'Wallis and Futuna Islands', 0, 'WF');");
mysql_query("INSERT INTO `countries` VALUES (210, 'Yemen', 0, 'YE');");
mysql_query("INSERT INTO `countries` VALUES (211, 'Zambia', 0, 'ZM');");
mysql_query("INSERT INTO `countries` VALUES (212, 'Zimbabwe', 1, 'ZW');");
mysql_query("INSERT INTO `countries` VALUES (213, 'Iran', 0, 'IR');");
mysql_query("INSERT INTO `countries` VALUES (214, 'Channel Islands', 1, 'GB');");


            $sSQL="CREATE TABLE `image_settings` (
            `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
            `component` VARCHAR( 20 ) ,
            `extensions` VARCHAR( 255 ) ,
            `maxWidth` VARCHAR( 50 ) ,
            `maxHeight` VARCHAR( 50 ) ,
            `quality` VARCHAR( 50 ) ,
            `maxWidthThumb` VARCHAR( 50 ) ,
            `maxHeightThumb` VARCHAR( 50 ) ,
            `qualityThumb` VARCHAR( 50 )
            );";
            mysql_query($sSQL) or print_sql_error();
            mysql_query("INSERT INTO `image_settings` ( `id` , `component` , `extensions` , `maxWidth` , `maxHeight` , `quality` , `maxWidthThumb` , `maxHeightThumb` , `qualityThumb` ) VALUES ('1', 'GD', 'GIF,JPG,JPEG,BMP,PNG', '400', NULL , '80', '100', NULL , '70');");

        $sSQL = "CREATE TABLE `payment` (
          `id` int(11) NOT NULL auto_increment,
          `name` varchar(55) NOT NULL default '',
          `showas` varchar(55) default NULL,
          `active` char(1) default NULL,
          `demo` char(1) default NULL,
          `extra` varchar(255) default NULL,
          `extra2` varchar(255) default NULL,
          PRIMARY KEY  (`id`));";
         mysql_query($sSQL) or print_sql_error();

mysql_query("INSERT INTO `payment` VALUES (1, 'Paypal', 'Paypal', 'Y', 'Y', 'test@68classifieds.com', NULL);");
mysql_query("INSERT INTO `payment` VALUES (2, '2Checkout', 'Credit Card', 'Y', 'Y', '98966', NULL);");
mysql_query("INSERT INTO `payment` VALUES (3, 'Paymate', 'Credit Card', 'N', 'N', NULL, NULL);");
mysql_query("INSERT INTO `payment` VALUES (4, 'Authorize.net SIM', 'Credit Card', 'N', 'N', NULL, NULL);");
mysql_query("INSERT INTO `payment` VALUES (5, 'Linkpoint Basic', 'Credit Card', 'N', 'N', 'storename', NULL);");

    /* Product Images */
    $sSQL = "CREATE TABLE `prodimages` (
          `id` int(11) NOT NULL auto_increment,
          `pid` int(11) NOT NULL default '0',
          `title` varchar(255) default NULL,
          `image` varchar(255) NOT NULL default '',
          `rank` int(11) NOT NULL default '5',
          PRIMARY KEY  (`id`));";
    mysql_query($sSQL) or print_sql_error();

    /* Products */
    $sSQL = "CREATE TABLE `products` (
      `id` int(11) NOT NULL auto_increment,
      `owner` int(11) default NULL,
      `title` varchar(75) default NULL,
      `section` int(11) default NULL,
      `description` text,
      `featured` char(1) default 'N',
      `price` double default NULL,
      `display` char(1) default 'N',
      `hitcount` int(10) default '0',
      `dateadded` date NOT NULL default '0000-00-00',
      `expiration` date NOT NULL default '0000-00-00',
      `prodID` int(11) default NULL,
      `authNumber` varchar(50) default NULL,
      `url` varchar(255) default NULL,
      PRIMARY KEY  (`id`)
    )";  
    mysql_query($sSQL) or print_sql_error();
mysql_query("INSERT INTO `products` VALUES (31, 1, 'RM-Z250', 13, 'Want to dominate your motocross circuit? Then check out the all-new four-stroke motocross bike from Suzuki at Suzuki Kawasaki of Gastonia. <br /><br />Get a great deal on the 2004 Suzuki RM-Z250. Fast. Light. And outrageously powerful. The new RM-Z250 combines the technology of the GSX-R 4-stroke road racing heritage and Suzuki\\\'s championship-winning motocross program to create Suzuki\\\'s first 4-stroke, race-ready motocross bike. <br /><br />Want to beat the competition off the line? In the corners? On the straightaways? No problem, this bike\\\'s got plenty of power so you can carve out a permanent place on the podium. So, pick up the new Suzuki RM-Z250 today, before your competition does. <br /><br />Suzuki Kawasaki of Gastonia, for those who want to win big!<br />', 'N', '5499', 'N', 0, '2004-02-16', '2004-04-16', 2, 'Test', '');");
mysql_query("INSERT INTO `products` VALUES (32, 1, 'Paypal test', 11, 'Cobra Exhaust', 'N', '3499', 'Y', 0, '2004-02-16', '2004-03-16', 1, 'Test', '');");
mysql_query("INSERT INTO `products` VALUES (33, 1, 'Paypal test', 11, 'Cobra Exhaust', 'N', '3499', 'N', 0, '2004-02-16', '2004-03-16', 1, 'Test', '');");

    $sSQL = "CREATE TABLE `products_categories` (
      `product_id` int(11) NOT NULL default '0',
      `category_id` int(11) NOT NULL default '0',
      PRIMARY KEY  (`product_id`,`category_id`)
    );";
    mysql_query($sSQL) or print_sql_error();

    /* States */
    $sSQL = "CREATE TABLE `states` (
                  `id` int(11) NOT NULL auto_increment,
                  `name` char(40) NOT NULL default '',
                  `abbrev` char(2) NOT NULL default '',
                  PRIMARY KEY  (`id`));";
    mysql_query($sSQL) or print_sql_error();

mysql_query("INSERT INTO `states` VALUES (1, 'Alaska', 'AK');");
mysql_query("INSERT INTO `states` VALUES (2, 'Alabama', 'AL');");
mysql_query("INSERT INTO `states` VALUES (3, 'American Samoa', 'AS');");
mysql_query("INSERT INTO `states` VALUES (4, 'Arizona', 'AZ');");
mysql_query("INSERT INTO `states` VALUES (5, 'Arkansas', 'AR');");
mysql_query("INSERT INTO `states` VALUES (6, 'California', 'CA');");
mysql_query("INSERT INTO `states` VALUES (7, 'Colorado', 'CO');");
mysql_query("INSERT INTO `states` VALUES (8, 'Connecticut', 'CT');");
mysql_query("INSERT INTO `states` VALUES (9, 'Delaware', 'DE');");
mysql_query("INSERT INTO `states` VALUES (10, 'District of Columbia', 'DC');");
mysql_query("INSERT INTO `states` VALUES (11, 'Federated States of Micronesia', 'FM');");
mysql_query("INSERT INTO `states` VALUES (12, 'Florida', 'FL');");
mysql_query("INSERT INTO `states` VALUES (13, 'Georgia', 'GA');");
mysql_query("INSERT INTO `states` VALUES (14, 'Guam', 'GU');");
mysql_query("INSERT INTO `states` VALUES (15, 'Hawaii', 'HI');");
mysql_query("INSERT INTO `states` VALUES (16, 'Idaho', 'ID');");
mysql_query("INSERT INTO `states` VALUES (17, 'Illinois', 'IL');");
mysql_query("INSERT INTO `states` VALUES (18, 'Indiana', 'IN');");
mysql_query("INSERT INTO `states` VALUES (19, 'Iowa', 'IA');");
mysql_query("INSERT INTO `states` VALUES (20, 'Kansas', 'KS');");
mysql_query("INSERT INTO `states` VALUES (21, 'Kentucky', 'KY');");
mysql_query("INSERT INTO `states` VALUES (22, 'Louisiana', 'LA');");
mysql_query("INSERT INTO `states` VALUES (23, 'Maine', 'ME');");
mysql_query("INSERT INTO `states` VALUES (24, 'Marshall Islands', 'MH');");
mysql_query("INSERT INTO `states` VALUES (25, 'Maryland', 'MD');");
mysql_query("INSERT INTO `states` VALUES (26, 'Massachusetts', 'MA');");
mysql_query("INSERT INTO `states` VALUES (27, 'Michigan', 'MI');");
mysql_query("INSERT INTO `states` VALUES (28, 'Minnesota', 'MN');");
mysql_query("INSERT INTO `states` VALUES (29, 'Mississippi', 'MS');");
mysql_query("INSERT INTO `states` VALUES (30, 'Missouri', 'MO');");
mysql_query("INSERT INTO `states` VALUES (31, 'Montana', 'MT');");
mysql_query("INSERT INTO `states` VALUES (32, 'Nebraska', 'NE');");
mysql_query("INSERT INTO `states` VALUES (33, 'Nevada', 'NV');");
mysql_query("INSERT INTO `states` VALUES (34, 'New Hampshire', 'NH');");
mysql_query("INSERT INTO `states` VALUES (35, 'New Jersey', 'NJ');");
mysql_query("INSERT INTO `states` VALUES (36, 'New Mexico', 'NM');");
mysql_query("INSERT INTO `states` VALUES (37, 'New York', 'NY');");
mysql_query("INSERT INTO `states` VALUES (38, 'North Carolina', 'NC');");
mysql_query("INSERT INTO `states` VALUES (39, 'North Dakota', 'ND');");
mysql_query("INSERT INTO `states` VALUES (40, 'Northern Mariana Islands', 'MP');");
mysql_query("INSERT INTO `states` VALUES (41, 'Ohio', 'OH');");
mysql_query("INSERT INTO `states` VALUES (42, 'Oklahoma', 'OK');");
mysql_query("INSERT INTO `states` VALUES (43, 'Oregon', 'OR');");
mysql_query("INSERT INTO `states` VALUES (44, 'Palau', 'PW');");
mysql_query("INSERT INTO `states` VALUES (45, 'Pennsylvania', 'PA');");
mysql_query("INSERT INTO `states` VALUES (46, 'Puerto Rico', 'PR');");
mysql_query("INSERT INTO `states` VALUES (47, 'Rhode Island', 'RI');");
mysql_query("INSERT INTO `states` VALUES (48, 'South Carolina', 'SC');");
mysql_query("INSERT INTO `states` VALUES (49, 'South Dakota', 'SD');");
mysql_query("INSERT INTO `states` VALUES (50, 'Tennessee', 'TN');");
mysql_query("INSERT INTO `states` VALUES (51, 'Texas', 'TX');");
mysql_query("INSERT INTO `states` VALUES (52, 'Utah', 'UT');");
mysql_query("INSERT INTO `states` VALUES (53, 'Vermont', 'VT');");
mysql_query("INSERT INTO `states` VALUES (54, 'Virgin Islands', 'VI');");
mysql_query("INSERT INTO `states` VALUES (55, 'Virginia', 'VA');");
mysql_query("INSERT INTO `states` VALUES (56, 'Washington', 'WA');");
mysql_query("INSERT INTO `states` VALUES (57, 'West Virginia', 'WV');");
mysql_query("INSERT INTO `states` VALUES (58, 'Wisconsin', 'WI');");
mysql_query("INSERT INTO `states` VALUES (59, 'Wyoming', 'WY');");
mysql_query("INSERT INTO `states` VALUES (60, 'Armed Forces Africa', 'AE');");
mysql_query("INSERT INTO `states` VALUES (61, 'Armed Forces Americas (except Canada)', 'AA');");
mysql_query("INSERT INTO `states` VALUES (62, 'Armed Forces Canada', 'AE');");
mysql_query("INSERT INTO `states` VALUES (63, 'Armed Forces Europe', 'AE');");
mysql_query("INSERT INTO `states` VALUES (64, 'Armed Forces Middle East', 'AE');");
mysql_query("INSERT INTO `states` VALUES (65, 'Armed Forces Pacific', 'AP');");

/* User Tabel */
$sSQL = "CREATE TABLE users (
  id int(11) NOT NULL auto_increment,
  custip varchar(100) default NULL,
  firstname varchar(100) default NULL,
  lastname varchar(255) default NULL,
  address varchar(255) default NULL,
  city varchar(75) default NULL,
  state varchar(75) default NULL,
  zip varchar(50) default NULL,
  country varchar(50) default NULL,
  email varchar(125) default NULL,
  phone varchar(50) default NULL,
  affiliate varchar(50) default NULL,
  newsletter char(1) default 'N',
  username varchar(255) default NULL,
  password varchar(255) default NULL,
  level int(5) default '1',
  joindate date default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY ordID (id),
  KEY ordID_2 (id)
) TYPE=MyISAM;";
    mysql_query($sSQL) or print_sql_error();

if($haserrors)
    print('<font color="#FF0000"><b>Completed, but with errors !</b></font><br>');
else
    print('<b>Everything installed succesfully !</b><br><font color="#FF0000">Please delete this file or your database can get overwritten!</font><br>');
    }

    else{
?>
<form action="install.php" method="POST">
<input type="hidden" name="posted" value="1">
<table width="100%" align="center">
<tr><td align="center" width="100%">
<p>&nbsp;</p>
<p>Please click below to start your installation.</p>
<p>&nbsp;</p>
<p>After performing the install, please delete this file from your web!</p>
<p>&nbsp;</p>
<input type="submit" value="Install">
<p>&nbsp;</p>
<p>&nbsp;</p>
</td></tr>
</table>
</form>
<?php
}
?>
</td>
          </tr>
    </table></td>
  </tr>
</table>
<p align="center">&copy; 2004 68 Designs, LLC - All rights reserved.</p>
</body>
</html>

mysql php web-design

Edited 11 Years Ago by mike_2000_17 because: Fixed formatting

2 Contributors
3 Replies
301 Views
7 Hours Discussion Span
Latest Post 15 Years Ago Latest Post by darkagn

darkagn 315 Veteran Poster

15 Years Ago

Hi hmkk and welcome to DaniWeb :)

mysql_select_db($sumdueu_urworld, $sumdueu_admin);

Your problem is most likely that the variable $sumdueu_admin has not been created correctly. This must be done with a call to mysql_connect() before the call to mysql_select_db() is made. This can occur in a previous script in your website, but I would say that it has not yet occurred when this line is reached.

For more information, visit the documentation at www.php.net or google mysql_connect for PHP.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

hmkk 0 Newbie Poster · Answer 1 · 2009-09-08T09:02:04+00:00

Hello, thanks for quck reply
please tell me where i have to create mysql_connect before
call to mysql_select_db()

Hi hmkk and welcome to DaniWeb :)
mysql_select_db($sumdueu_urworld, $sumdueu_admin);
Your problem is most likely that the variable $sumdueu_admin has not been created correctly. This must be done with a call to mysql_connect() before the call to mysql_select_db() is made. This can occur in a previous script in your website, but I would say that it has not yet occurred when this line is reached.
For more information, visit the documentation at www.php.net or google mysql_connect for PHP.

darkagn 315 Veteran Poster Featured Poster · Answer 2 · 2009-09-08T09:22:42+00:00

Basically you need to call mysql_connect with your connection info parameters in a line before the line I have indicated. Or it could be being called in the script /Connections/classifieds.php, in which case the line that reads

<?php ('/Connections/classifieds.php'); ?>

should read

<?php require_once('/Connections/classifieds.php'); ?>

There are other options other than require_once, but I think this is the most appropriate solution. Again, this is only if mysql_connect is called in this script, so check the code in that file.