Mysql and cgi help please :-).

They have: 12 posts

Joined: Aug 2000

Ok since a lot of alabanza hosts hangout here ill ask for help here . I've been trying all day long to get allmanage working on my site. The MYSQL version but cant lol. as anyone attempted to install this before on an alabanza server?. I have copyed and pasted the mysql section of the script and really dunno how todo this i set it up fine on a tera-byte server but for the life of me cannot do it on alabanza. Once again sorry if this is off the topic. .

##############################
#
# Full path to mysqladmin (if not set in the path.)
# N.B. if you get an error saying "...Cant call method prepare
# without a package object or reference...." it is because
# the script cant find the "MYSQLADMIN" command.
# on NT it the C:\mysql\bin\...path.
#

$mysqladmin = 'mysqladmin';

#############################
#
# This should be left to read mysql, as These commands
# probably wont wotk with any DB other than MySQL...
#

$driver = "mysql";

#############################
#
# The name of the database that will be (or already is) created
# to hold all the table information. N.B. This database CAN exist
# already. If it does exist, the tables will be created INSIDE this
# database. If your database is located on another server,
# enter the database in the following format:
# $database = ":";
# i.e. $database = "allmanage:mysql2.someserver.com.au";

$database = "allmanage";

#############################
#
# The name of the table for the main data structure. DONT
# change this...it is referenced throughout the other scripts.
#

$main_data_table = "main_data";

#############################
#
# Same as above, but to hold the admin data
#

$admin_main_data_table = "admin_main_data";

#############################
#
# Ditto for the two above, except for default messages.
#

$messages_table = "messages";

#############################
#
# The username / password you use to connect to the database.
# If you dont usually use use a value, that is from the command prompt,
# you simply type: mysql ... or you have never used mysql before, leave
# the values as they are. three examples:
#
# username/password are mike/21trt6554w
# my $username="mike";
# my $password="21trt6554w";
#
# username/(NO PASSWORD) are root/(NONE)
# my $username="";
# my $password="";
#
# (NO USERNAME)/(NO PASSOWRD) - typically for a local machine...
# my $username="";
# my $password="";
#

$database_username = "";
$database_password = "";

my($sth,$dbh,@row);

#############################
#############################
#
# Now, heres where the fun starts!!!
#
# DONT WORRY ABOUT CHANGING ANYTHING
# BELOW HERE UNLESS YOU KNOW WHAT YOU
# ARE DOING.................
#
#############################