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]

Reply via email to