I got this error on a calendar script I got off line can anyone help me fix this any help would be very appreciated.
PHIL
Fatal error: Call to undefined function: mysql_create_db() in /home/httpd/vhosts/ugofit.
com/httpdo
cs/fitness
/admin/mak
edb.php on line 11
Heres the script and this is line 11
if (mysql_create_db("$DBName"
)) {
print ("Database created successfully...<br>");
FULL SCRIPT BELOW
__________________________
_____
<?php
$DBhost = "localhost"; // your mysql server...
$DBuser = "ugofit"; // your mysql login
$DBpass = "fitness"; // your mysqlpassword
$DBName = "impcalendar"; // the name of the database used
$link = mysql_pconnect("$DBhost", "$DBuser", "$DBpass")
or exit("Could not connect");
if (mysql_create_db("$DBName"
)) {
print ("Database created successfully...<br>");
} else {
printf ("Error creating database: %s\n", mysql_error ());
}
mysql_select_db("$DBName")
or die("Doh!");
$query = "CREATE TABLE `IMP_calendar` (`ID` BIGINT (20) DEFAULT '0' NOT NULL AUTO_INCREMENT, PRIMARY KEY(`ID`)) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_calendar` ADD `DAY` SMALLINT UNSIGNED ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_calendar` ADD `MONTH` SMALLINT UNSIGNED ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_calendar` ADD `YEAR` SMALLINT UNSIGNED ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_calendar` ADD `TITLE` VARCHAR(50) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_calendar` ADD `TSTAMP` CHAR(10) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_calendar` ADD `ASTAMP` CHAR(10) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_calendar` ADD `DETAILS` TEXT ";
$Doit = mysql_query($query);
$query = "CREATE TABLE `IMP_vars` (`ID` BIGINT (20) DEFAULT '0' NOT NULL AUTO_INCREMENT, PRIMARY KEY(`ID`)) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_vars` ADD `BG_COLOR` CHAR(6) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_vars` ADD `TEXT_COLOR` CHAR(6) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_vars` ADD `DAY_COLOR` CHAR(6) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_vars` ADD `DAYNUM_COLOR` CHAR(6) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_vars` ADD `TODAY_COLOR` CHAR(6) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_vars` ADD `WEEKEND_COLOR` VARCHAR(6) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_vars` ADD `LINK_COLOR` CHAR(6) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_vars` ADD `HOVER_LINK_COLOR` CHAR(6) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_vars` ADD `TITLE_AREA_COLOR` CHAR(6) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_vars` ADD `TITLE_COLOR` CHAR(6) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_vars` ADD `WEEKDAY_COLOR` CHAR(6) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_vars` ADD `BORDER_COLOR` CHAR(6) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_vars` ADD `NIL_DAY_COLOR` CHAR(6) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_vars` ADD `CAL_WIDTH` VARCHAR(6) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_vars` ADD `POP_HEIGHT` VARCHAR(6) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_vars` ADD `POP_WIDTH` VARCHAR(6) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_vars` ADD `CODESTRIPPING` TINYINT(2) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_vars` ADD `EVENTPOP` TINYINT(2) ";
$Doit = mysql_query($query);
$query = "ALTER TABLE `IMP_vars` ADD `SHOWBY` TINYINT(2) ";
$Doit = mysql_query($query);
print "Tables created...<br>";
$update = " INSERT INTO IMP_vars
(DAYNUM_COLOR, EVENTPOP, SHOWBY, CODESTRIPPING, TODAY_COLOR, CAL_WIDTH, POP_WIDTH, POP_HEIGHT, BG_COLOR, BORDER_COLOR, TEXT_COLOR, NIL_DAY_COLOR, LINK_COLOR, HOVER_LINK_COLOR, TITLE_COLOR, TITLE_AREA_COLOR, DAY_COLOR, WEEKEND_COLOR, WEEKDAY_COLOR)
VALUES
('666666', '0', '0', '0', 'ffffcc', '500', '400', '400', 'eeeeee', 'ffffff', '666666', 'f9f9f9', '8c93e4', '4c5394', 'ffffff', 'dce2ea', '4d74a9', 'cccccc', 'dce2ea')";
$doint = mysql_query($update);
print "
Default values populated...<br>DONE.<p>
<a href=../calendar.php>Calen
dar</a><br
>
<a href=../minical.php>Calend
ar</a><br>
<a href=adminmenu.php>Admin Page</a>
";
?>