Hi All
I need some one to comment on the program below
With the code below I am trying to design a table that allows a simple message board
server to:
1) Save a message,
2) delete a message,
3) update a message
The password + username must be saved in the same table entry, and compare it when
receiving an update or delete.
-------------------------------------------------------------------------------------------------------------------
#!/usr/local/bin/perl
use DBI;
my $dbname = 'Bruce';
my $dbhostname = 'localhost';
my $user = 'root';
my $password = '' ;
CREATE TABLE employee_Info (
primary_key INT AUTO_INCREMENT NOT NULL,
name CHAR(20),
surname CHAR(20),
employee_no CHAR(10),
shoe_colour CHAR (10),
PRIMARY KEY (primary_key)
);
my $db = dbi->connect ("dbi:mysql:dbname ; host = $dbhostname;$user;$passwd");
$db->do ("SAVE INTO Employee_Info (primarykey, name, surname, shoecolour, employee_no)
value(1,'Ambraal','Bruce','White', '9536826')");
$db-> do(" SAVE INTO Employee_Info (primarykey, name, shoecolour, employee _no)
value(2, 'September', 'John', 'Pink','9536456')");
$db->do("DELETE FROM Employee_Info (
$db->do("UPDATE FROM Employee_Info (
$db->disconnect();
;
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]