PHP Form Will Not Update InnoDB

Problems with the Windows version of XAMPP, questions, comments, and anything related.

PHP Form Will Not Update InnoDB

Postby mikeses » 29. November 2013 18:39

xampp-win32-1.8.3-1-VC11
Windows 8.0 64 bit
Ports I have to use: 8080 & 4443
Running as Administrator, no password
Hello All,
I am using XAMPP for a PHP class and we have example forms and PHP to familiarize ourselves with MYSQL. the form allows entry of animals, the PHP enters the data into the tables. The PHP returns "Added Animals"; however, when the table is searched the animal is not found. My teacher states that "XAMPP is a temporary, portable "mock-server" and is apparently only good for development and demonstration purposes, but PHP and MySQL work better from a real live server when a site is published"

Is this true? The entry just goes through the motions and does not modify the table even though no error was returned? Here is the form; the PHP follows after it; after the PHP are the files to insert to make the DB which must be inserted in the order that they appear. I couldn't figure out the way to attach files, so a notepad document will need to be created from them :

CREATE TABLE SALES & CREATE TABLE SALEANIMALS is missing, too many char

Code: Select all
<html>
 <body>
  <form action="ex2.php" method="post">
   <p>Name: <input type="text" name="name"></p>
   <p>Species: <input type="text" name="species"></p>
   <p>Breed: <input type="text" name="breed"></p>
   <p>Date of Birth: <input type="text" name="dob"></p>
   <p>Gender:
    <select name="gender">
     <option value="Male">Male</option>
     <option value="Female">Female</option>
    </select>
   </p>
   <p>Color: <input type="text" name="color"></p>
   <p>List Price: <input type="text" name="listprice"></p>
   <p><input type="submit" value="Get Data"></p>
  </form>
 </body>
</html>


Code: Select all
<html>
 <body>
  <h1 align="center">Data Entry</h1>
  <?php
   $con = mysql_connect("localhost","root","") or die("Failed to connect to database");
   mysql_select_db("196samples", $con);
   $name = $_POST["name"];
   $species = $_POST["species"];
   $breed = $_POST["breed"];
   $dob = $_POST["dob"];
   $gender = $_POST["gender"];
   $color = $_POST["color"];
   $listprice = $_POST["listprice"];
   $sql_command = "INSERT INTO ANIMALS(NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES " .
    "('" . $name . "','" . $species . "','" . $breed . "','" . $dob . "','" . $gender . "','" . $color . "'," . $listprice . ");";
   echo "<p>$sql_command was executed</p>";
   mysql_query($sql_command);
   echo "<p>Animal added</p>";
   mysql_close($con);
  ?>
 </body>
</html>


[*]
CREATE TABLE ANIMALS
(ANIMALID INTEGER AUTO_INCREMENT,
NAME VARCHAR(40),
SPECIES VARCHAR(40),
BREED VARCHAR(40),
DOB VARCHAR(20),
GENDER VARCHAR(10),
COLOR VARCHAR(40),
LISTPRICE DECIMAL(6,2),
CONSTRAINT pk1 PRIMARY KEY (ANIMALID));

CREATE TABLE CUSTOMERS
(CUSTOMERID INTEGER AUTO_INCREMENT,
PHONE VARCHAR(40),
FIRSTNAME VARCHAR(40),
LASTNAME VARCHAR(40),
ADDRESS VARCHAR(40),
ZIPCODE VARCHAR(5),
CONSTRAINT pk2 PRIMARY KEY (CUSTOMERID));

CREATE TABLE SALES
(SALEID INTEGER AUTO_INCREMENT,
SALEDATE VARCHAR(20),
CUSTOMERID INTEGER,
CONSTRAINT pk3 PRIMARY KEY (SALEID),
CONSTRAINT fk1 FOREIGN KEY (CUSTOMERID) REFERENCES CUSTOMERS(CUSTOMERID));

CREATE TABLE SALEANIMALS
(SALEID INTEGER,
ANIMALID INTEGER,
SALEPRICE DECIMAL(6,2),
CONSTRAINT pk4 PRIMARY KEY (SALEID, ANIMALID),
CONSTRAINT fk3 FOREIGN KEY (ANIMALID) REFERENCES ANIMALS(ANIMALID));
[*]

[*]
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (2,'','Fish','Angel','5/5/2004','Male','Black',12.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (4,'Simon','Dog','Vizsla','3/2/2004','Male','Red Brown',174.06);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (5,'','Fish','Shark','1/1/2004','Female','Gray',22.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (6,'Rosie','Cat','Oriental Shorthair','8/2/2004','Female','Gray',193.31);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (7,'Eugene','Cat','Bombay','1/25/2004','Male','Black',279.54);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (8,'Miranda','Dog','Norfolk Terrier','5/4/2004','Female','Red',203.75);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (9,'','Fish','Guppy','3/10/2004','Male','Gold',2.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (10,'Sherri','Dog','Siberian Huskie','9/13/2004','Female','Black/White',166.79);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (11,'Susan','Dog','Dalmation','1/22/2004','Female','Spotted',164.96);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (12,'Leisha','Dog','Rottweiler','6/13/2004','Female','Brown',164.06);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (13,'','Fish','Tetra','3/1/2004','Male','Red',12.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (14,'Tina','Cat','Sphynx','1/6/2004','Female','Gold',143.94);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (15,'Bonita','Dog','Cocker Spaniel','10/21/2004','Female','Gold',284.85);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (16,'Lisa','Dog','Great Pyrenees','1/5/2004','Female','Brown',274.35);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (17,'Jackie','Dog','Doberman','4/12/2004','Male','Black',165.73);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (18,'Allison','Cat','Manx','4/21/2004','Female','Black',215.92);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (19,'Gene','Dog','Wire Fox Terrier','5/11/2004','Male','White',210.65);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (20,'Buck','Cat','Bombay','4/30/2004','Male','Black',213.18);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (21,'Debbie','Bird','Cockatiel','1/14/2004','Female','Blue',177.88);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (23,'Craig','Dog','Poodle','3/17/2004','Male','White',108.32);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (24,'Carla','Cat','Maine Coon','4/11/2004','Female','Brown/Red',163.97);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (25,'Vivian','Dog','Cocker Spaniel','4/24/2004','Female','Red',128.18);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (26,'Orville','Dog','Shetland Sheepdog','7/6/2004','Male','Gray',242.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (27,'','Reptile','Gila Monster','3/11/2004','Male','Green',192.08);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (28,'','Spider','Tarantula','2/7/2004','Male','Black',45.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (29,'','Fish','Snail','6/15/2004','Male','White',15.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (30,'Golda','Dog','Bloodhound','1/6/2004','Female','Brown',187.62);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (31,'Taylor','Dog','Mastiff','2/15/2004','Male','Brown',164.70);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (32,'Cathy','Cat','Scottish Fold','6/5/2004','Female','White',138.91);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (33,'Kent','Dog','Poodle-Toy','5/30/2004','Male','Gray/Blue',122.36);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (34,'Rhonda','Dog','Maltipoos','7/16/2004','Female','Gray',199.49);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (35,'Charles','Bird','Parakeet','4/9/2004','Male','Blue/Gold',203.10);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (36,'Connie','Dog','Poodle-Toy','10/14/2004','Female','White',190.46);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (37,'Hunter','Dog','Bassett Hound','5/4/2004','Male','Brown',115.39);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (39,'Doris','Dog','Rottweiler','3/27/2004','Female','Red',211.28);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (40,'Hunter','Dog','Weimaraner','4/2/2004','Male','Brown',214.82);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (41,'Claudia','Dog','Boston Terrier','1/5/2004','Female','Black',179.92);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (42,'Lloyd','Dog','Bassett Hound','5/19/2004','Male','Brown/Black',193.63);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (43,'Chelsea','Reptile','Python','2/10/2004','Female','Black/Gold',237.90);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (44,'Melanie','Dog','Mastiff','6/18/2004','Female','Black',141.17);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (45,'Bernard','Cat','American Shorthair','8/8/2004','Male','Gray',182.77);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (46,'Lou Ann','Dog','Chinese Shar Pei','1/8/2004','Female','Gold',254.85);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (47,'Brian','Dog','Cock A Poo','3/3/2004','Male','Black',206.07);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (48,'Anthony','Cat','Japanese Bobtail','6/16/2004','Male','White',226.54);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (49,'Martha','Cat','Korat','3/16/2004','Female','Gray/Blue',218.95);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (50,'Arnold','Dog','Pomeranian','5/18/2004','Male','Gray/Blue',267.05);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (51,'Kelly','Dog','Golden Retriever','1/16/2004','Male','Gold',246.05);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (52,'Buck','Dog','St Bernard','1/1/2004','Male','Brown/White',231.44);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (53,'','Fish','Starfish','6/23/2004','Female','Blue',52.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (54,'Sandy','Bird','Parrot','1/23/2004','Female','Blue/Red',107.52);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (55,'Alice','Dog','Cairn Terrier','1/3/2004','Female','Gray/Blue',204.72);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (56,'Lillie','Cat','Abyssinian','4/3/2004','Female','White',227.39);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (57,'Darcy','Dog','Akita','1/2/2004','Male','White/Black',237.10);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (58,'Curtis','Bird','Parakeet','4/28/2004','Male','Gold/Red',146.87);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (59,'Gaylen','Dog','Dalmation','5/10/2004','Male','Spotted',199.52);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (60,'Everett','Dog','Australian Shepherd','5/20/2004','Male','Brown/White',325.69);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (61,'Sandy','Dog','Chinese Shar Pei','6/1/2004','Female','Brown',221.55);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (62,'Linda','Cat','Russian Blue','8/22/2004','Female','Gray/Blue',96.73);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (63,'Sandy','Cat','Persian','2/19/2004','Female','White',191.27);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (64,'','Reptile','Python','4/11/2004','Female','Black',255.25);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (65,'Bryce','Cat','Persian','6/23/2004','Male','White/Black',133.24);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (66,'Seth','Cat','Russian Blue','1/9/2004','Male','Gray/Blue',275.10);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (67,'Ara','Cat','Manx','1/29/2004','Male','White',179.05);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (68,'Hoyt','Bird','Parrot','3/28/2004','Male','Blue/Red',235.27);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (69,'Inez','Dog','Border Collie','2/24/2004','Female','Brown/White',104.88);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (70,'Chris','Dog','Akita','2/8/2004','Male','White/Black',206.57);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (71,'Cora','Dog','Keeshond','10/2/2004','Female','Brown',119.67);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (72,'','Mammal','Hamster','6/27/2004','Male','Brown/White',13.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (73,'Janet','Dog','Coon Hound','2/24/2004','Female','Brown',123.65);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (74,'Gina','Dog','Lhasa Apso','1/25/2004','Female','Brown/White',128.08);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (75,'Ella','Dog','Chinese Shar Pei','2/8/2004','Female','Brown',131.83);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (77,'Damon','Cat','Bombay','1/17/2004','Male','Black',178.16);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (78,'Hunter','Dog','Great Dane','1/2/2004','Male','Brown',215.74);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (79,'','Bird','Cockatiel','2/26/2004','Male','Brown/Blue',224.47);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (80,'Oakley','Dog','Jack Russell Terrier','8/9/2004','Female','Brown/White',84.45);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (81,'','Bird','Canary','7/29/2004','Female','Yellow',229.44);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (82,'','Mammal','Ferret','7/21/2004','Male','Brown',125.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (83,'Laura','Dog','Chihuahua','1/25/2004','Female','Brown',155.46);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (84,'Patricia','Cat','Angora','2/26/2004','Female','White',294.26);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (85,'Dwight','Dog','Dachshund','3/3/2004','Male','Brown',178.64);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (86,'','Fish','Tetra','1/2/2004','Female','Black',22.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (87,'Christine','Dog','Norfolk Terrier','8/14/2004','Female','Red',208.12);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (88,'Brandy','Dog','Cocker Spaniel','7/9/2004','Female','Brown',189.06);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (89,'Ben','Dog','German Shepherd','1/10/2004','Male','Black/White',153.94);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (90,'Chad','Dog','Great Dane','6/15/2004','Male','Black',223.97);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (91,'Russell','Dog','Pit Bull','5/23/2004','Male','Brown',171.59);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (92,'Terry','Bird','Lovebird','2/4/2004','Male','White',180.16);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (93,'Trina','Dog','Greyhound','1/5/2004','Female','Gray',143.07);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (94,'Jean','Dog','Siberian Huskie','7/1/2004','Female','White/Brown',223.38);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (95,'Ashley','Cat','Sphynx','1/25/2004','Female','White',183.48);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (96,'Stan','Cat','Sphynx','1/1/2004','Male','Black',241.67);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (97,'Ernest','Dog','Dachshund','1/21/2004','Male','Black',141.95);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (98,'Ricardo','Dog','Bulldog','2/3/2004','Male','Black',177.20);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (99,'','Mammal','Ferret','7/27/2004','Male','Black',230.89);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (100,'Bill','Cat','Scottish Fold','8/6/2004','Male','Gray',132.79);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (101,'Bessie','Dog','Australian Shepherd','1/3/2004','Female','White/Brown',216.10);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (102,'Leonard','Dog','Mastiff','9/18/2004','Male','Brown',197.31);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (103,'Lee','Cat','Siamese','7/17/2004','Male','White/Black',232.90);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (104,'Julie','Cat','Longhair','2/18/2004','Female','Yellow',180.38);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (105,'Beth','Dog','Akita','2/6/2004','Female','White/Brown',177.06);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (106,'Taylor','Cat','Oriental Shorthair','2/21/2004','Male','Yellow/Black',220.94);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (108,'Anissa','Dog','Bloodhound','4/4/2004','Female','Brown',169.13);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (109,'','Fish','Angel','4/5/2004','Female','Yellow',128.22);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (110,'Cathy','Bird','African Grey','7/5/2004','Female','Gray/Red',192.77);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (111,'Martin','Dog','Keeshond','3/8/2004','Male','Black',238.55);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (112,'Elizabeth','Cat','Persian','1/15/2004','Female','Gray',145.33);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (113,'Courtney','Dog','Boston Terrier','3/12/2004','Female','Black',142.61);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (115,'Jewell','Cat','Korat','1/15/2004','Female','Black',210.88);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (116,'','Bird','Parrot','6/1/2004','Male','Blue/Gold',133.01);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (117,'Wallace','Cat','Other','8/9/2004','Male','Brown',50.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (118,'','Fish','Guppy','5/5/2004','Female','Brown',4.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (119,'DuJuan','Reptile','Boa Constrictor','4/26/2004','Male','Brown/Gold',202.56);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (120,'Chester','Dog','Keeshond','2/25/2004','Male','Black',216.91);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (121,'Rachel','Dog','Norfolk Terrier','8/2/2004','Female','Gray',284.54);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (122,'Gayle','Cat','Bombay','2/14/2004','Female','Black',282.84);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (124,'Trina','Cat','Oriental Shorthair','5/25/2004','Female','Gray',187.70);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (125,'Harlen','Dog','Cocker Spaniel','3/17/2004','Male','Yellow',193.08);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (126,'Pierre','Cat','Maine Coon','4/11/2004','Male','Brown/Yellow',189.27);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (127,'Beth','Cat','British Blue','1/9/2004','Female','Gray/Blue',195.72);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (128,'Henry','Dog','German Shepherd','7/16/2004','Male','Black/White',155.95);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (129,'','Fish','Snail','8/2/2004','Male','Yellow',16.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (130,'Darrell','Dog','Greyhound','7/14/2004','Male','Gray',157.83);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (131,'Elvis','Dog','Mastiff','3/11/2004','Male','Black',214.39);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (132,'Dennis','Cat','Angora','7/13/2004','Male','White',157.01);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (133,'Anissa','Cat','Canadian Hairless','7/13/2004','Female','Gray',328.17);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (134,'','Reptile','Gila Monster','2/8/2004','Male','Brown',182.36);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (135,'','Mammal','Ferret','7/24/2004','Female','Brown',125.23);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (136,'','Bird','Other','8/11/2004','Male','White',206.77);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (137,'','Fish','Shark','1/24/2004','Female','Gray',238.52);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (138,'Owen','Cat','Japanese Bobtail','5/21/2004','Male','White',232.46);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (139,'Claudia','Dog','Doberman','8/2/2004','Female','Black',220.97);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (140,'Cal','Cat','Persian','7/21/2004','Male','White',134.80);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (141,'MaryJo','Dog','Pit Bull','6/22/2004','Female','Brown',234.51);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (142,'Susan','Dog','Siberian Huskie','8/3/2004','Female','White',180.93);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (143,'Leisha','Cat','Korat','5/20/2004','Female','Brown',163.07);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (144,'Dewey','Dog','Poodle-Toy','5/7/2004','Male','Black',182.60);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (145,'Ruby','Dog','Weimaraner','3/23/2004','Female','Brown',201.85);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (146,'Kevin','Cat','Siamese','3/24/2004','Male','White',93.07);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (147,'Kelly','Dog','Alaskan Malamute','3/25/2004','Male','White',272.52);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (148,'Wayne','Dog','Akita','2/9/2004','Male','White',257.89);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (149,'Elizabeth','Cat','Tonkinese','6/6/2004','Female','Yellow',138.82);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (150,'Brian','Dog','Norfolk Terrier','1/3/2004','Male','Yellow',168.80);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (151,'Lester','Bird','Parrot','4/9/2004','Male','Red',244.19);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (152,'Heather','Dog','Collie','6/3/2004','Female','Brown/Yellow',218.83);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (153,'Owen','Cat','Manx','6/28/2004','Male','Yellow',234.54);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (154,'Orville','Dog','English Bulldog','4/15/2004','Male','Yellow',197.01);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (155,'Stephen','Cat','Siamese','2/28/2004','Male','White',222.93);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (156,'Alvin','Dog','Collie','1/21/2004','Male','Yellow',280.59);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (157,'','Bird','Parrot','4/12/2004','Male','Red',237.81);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (158,'Russell','Dog','Shetland Sheepdog','3/20/2004','Male','White/Brown',167.16);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (159,'','Reptile','Python','1/13/2004','Male','Black',141.98);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (160,'Rufus','Dog','Cocker Spaniel','1/2/2004','Male','Yellow/black',176.79);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (161,'Bernard','Dog','Keeshond','5/11/2004','Male','Red',244.90);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (162,'Basil','Cat','Japanese Bobtail','5/8/2004','Male','Red',133.19);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (163,'Bruce','Dog','Jack Russell Terrier','9/20/2004','Male','Brown/White',261.02);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (164,'Ruby','Bird','Parakeet','1/19/2004','Female','Red',253.43);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (165,'Julie','Dog','Dalmation','8/28/2004','Female','Spotted',172.37);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (166,'Katy','Cat','Japanese Bobtail','3/25/2004','Female','Yellow',163.72);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (168,'Ray','Cat','Japanese Bobtail','6/4/2004','Male','Black',225.68);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (169,'Lorene','Dog','Coon Hound','9/11/2004','Female','Yellow',132.48);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (170,'Sarah','Dog','Poodle','3/15/2004','Female','White',250.81);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (171,'Glen','Dog','Chihuahua','4/18/2004','Male','Yellow',232.26);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (172,'Jackie','Dog','Boston Terrier','8/13/2004','Female','Gray',242.28);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (173,'','Mammal','Hamster','6/6/2004','Female','Yellow',22.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (174,'Lisa','Dog','Doberman','2/24/2004','Female','Brown',184.95);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (175,'Donald','Cat','Canadian Hairless','7/9/2004','Male','Brown',193.14);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (176,'DuJuan','Dog','Coon Hound','5/14/2004','Male','Brown',295.28);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (177,'Jennifer','Dog','Siberian Huskie','4/23/2004','Female','White',205.75);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (178,'Leisha','Dog','Scottish Terrier','5/26/2004','Female','Gray',164.63);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (179,'Cassy','Dog','Keeshond','1/5/2004','Female','Red',139.61);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (180,'','Fish','Angel','4/1/2004','Female','Yellow',27.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (181,'','Fish','Tetra','6/16/2004','Male','Brown/Red',23.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (182,'Duane','Dog','Rottweiler','5/28/2004','Male','Red',218.49);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (183,'','Spider','Scorpion','2/2/2004','Male','Black',127.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (184,'','Fish','Tetra','5/21/2004','Male','Black/Blue',25.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (185,'Ricardo','Dog','Airedale','6/21/2004','Male','Gray',164.14);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (186,'Francis','Dog','Chinese Shar Pei','1/29/2004','Female','Brown',240.40);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (187,'Martha','Dog','Poodle','5/15/2004','Female','White',133.65);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (188,'Angela','Dog','Chow Chow','6/26/2004','Female','Yellow',234.97);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (189,'Emma','Bird','Parrot','9/6/2004','Female','Yellow',170.08);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (190,'Wendell','Dog','Minature Pinschers','3/30/2004','Male','Red',163.60);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (191,'Cassy','Dog','Collie','2/13/2004','Female','Brown/White',233.43);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (192,'Sally','Cat','American Shorthair','6/26/2004','Female','Black',196.87);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (193,'Kevin','Cat','Sphynx','9/20/2004','Male','Yellow',240.05);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (195,'Tom','Dog','Dalmation','6/5/2004','Male','Spotted',195.52);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (196,'Buck','Dog','Doberman','6/5/2004','Male','Black',253.54);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (197,'','Spider','Tarantula','6/10/2004','Female','Black',221.85);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (198,'Curtis','Dog','Maltese','1/4/2004','Male','Black',142.67);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (199,'Herbert','Cat','Abyssinian','1/23/2004','Male','White',163.73);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (200,'Brandy','Dog','Mastiff','8/1/2004','Female','Brown',120.36);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (201,'','Mammal','Hamster','2/22/2004','Male','Brown',22.00);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (235,'joe','dog','poodle','4/14/2004','male','white',200.50345);
INSERT INTO ANIMALS(ANIMALID, NAME, SPECIES, BREED, DOB, GENDER, COLOR, LISTPRICE) VALUES (345,'John','Dog','Labrador','4/10/2004','Male','Black',350.00);
[*]

[*]
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (1,'','Walkin','Walkin','','00000');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (2,'(808) 801-9830','Brent','Cummings','9197 Hatchet Drive','96815');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (3,'(617) 843-6488','Dwight','Logan','1760 Clearview Street','02109');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (4,'(502) 007-0907','Shatika','Gilbert','4407 Green Street','40342');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (5,'(701) 384-5623','Charlotte','Anderson','4333 Highland Court','58102');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (6,'(606) 740-3304','Searoba','Hopkins','3183 Highland Court','40330');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (7,'(408) 104-9807','Anita','Robinson','8177 Horse Park Lane','95035');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (8,'(606) 688-8141','Cora','Reid','8351 Locust Street','41073');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (9,'(702) 533-3419','Elwood','Henson','4042 West Ridge Drive','89125');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (10,'(302) 701-7398','Kaye','Maynard','5095 Sugar Grove Road','19901');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (11,'(502) 444-1587','Lee','Gentry','5744 High Street','40342');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (12,'(608) 006-2256','Chris','Haley','6087 Spring Street','54601');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (13,'(304) 477-6629','Jolene','Garrison','1830 Glenview Drive','26261');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (14,'(614) 721-2870','Beth','Patterson','3688 Long Hollow Pike','43216');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (15,'(409) 116-3589','Connie','Fisher','4491 Evergreen Circle','77550');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (16,'(502) 863-3037','Rosie','Wade','7661 Trident Place','42240');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (17,'(606) 634-7076','Carly','Embry','2869 Sanders Ferry Road','40383');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (18,'(414) 331-5679','David','Lawrence','9326 Halltown Road','53916');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (19,'(505) 825-4065','Lisa','Zhang','477 Rolling Acres Drive','87501');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (20,'(207) 585-7583','Reva','Kidd','5594 Halltown Road','04401');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (21,'(615) 646-9874','Sarah','Mills','8904 Horseshoe Road','37167');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (22,'(706) 977-4337','Inga','Adkins','8831 Cardinal Lane','30720');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (23,'(606) 084-6983','Jerome','Cummings','2501 Club Circle','41101');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (24,'(615) 969-8901','Floyd','Young','969 Windsor Park Lane','37130');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (25,'(502) 863-8898','Gaylen','Wilson','1221 Johnson Drive','40229');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (26,'(606) 691-9745','Trina','Howe','2821 35th Street','40701');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (27,'(608) 825-3740','Archie','Mitchell','1326 Cedar Avenue','53590');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (28,'(408) 575-7000','Gina','Samuels','2026 Homewood Blvd.','95035');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (29,'(802) 078-4749','Kelly','Moore','6116 Clearview Street','05753');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (30,'(919) 014-7544','Rodney','Edmunds','5560 Greenfield Lane','27514');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (31,'(313) 260-7386','Nancy','Froedge','1399 Williamsburg Drive','48152');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (32,'(619) 281-2485','Searoba','Allbright','5260 College Street','92109');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (33,'(314) 510-5228','Colleen','Latham','2864 Dolhous Drive','63366');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (34,'(414) 168-2952','Cathy','Hampton','7295 Hazel Path','53203');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (35,'(406) 987-9338','Kimberly','Adams','5064 Pleasant Valley Drive','59901');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (36,'(501) 071-2650','Lloyd','Holland','9011 Bayshore Drive','72201');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (37,'(517) 039-8300','Fannie','McPherson','4184 Tick Ridge Road','48924');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (38,'(307) 477-8112','Jay','Franklin','9105 Ridge Top Road','82070');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (39,'(304) 352-8602','Dorothy','Williams','9286 Jackson Avenue','25550');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (40,'(612) 089-0074','Darrell','Oberhausen','9556 Cumberland Hills Drive','55101');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (41,'(502) 691-7565','Melinda','Craig','9217 Blue Lake Way','40218');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (42,'(615) 041-1934','Jackie','Froedge','243 West Ridge Drive','37027');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (43,'(517) 057-3491','Jasper','Killen','4869 Sequoia Lane','48924');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (44,'(412) 933-3710','Dale','Hammer','9707 Elm Hill Circle','15106');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (45,'(606) 372-0229','Shirley','Gregory','8982 Circle Drive','40356');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (46,'(201) 654-2441','Cassy','Tuck','7977 Fairways Drive','07015');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (47,'(804) 020-5842','Bernice','Carver','8170 Roberts Road','23320');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (48,'(508) 201-2483','Dwight','Parrish','9904 Plum Springs Road','01613');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (49,'(210) 851-7566','Wallace','Galloway','4358 Cherokee Road','78284');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (50,'(704) 979-1610','Lenny','Lee','9940 Girkin Road','28204');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (51,'(715) 483-7737','Clyde','Jernigan','5325 Cherry Street','54022');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (52,'(919) 289-1383','Gladys','Pendleton','1805 Sunset Place','27611');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (53,'(414) 331-5679','David','Lawrence','9326 Halltown Road','53916');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (54,'(502) 971-2715','Mark','Green','8968 Camino Circle','40291');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (55,'(606) 375-0721','Wendell','Thomas','8963 Pine Branch Trace','40330');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (56,'(507) 437-0059','Sidney','Hughes','4386 Sherwood Lane','56007');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (57,'(219) 263-2040','Phillip','Carter','20 Green Street','27514');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (58,'(703) 543-0176','Sam','McCain','445 Industrial Drive','22101');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (59,'(360) 917-7520','Cindy','Rhodes','7425 Virginia Street','98501');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (60,'(502) 029-3909','Lou Ann','Baez','2528 Hot Springs Avenue','42718');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (61,'(304) 416-1309','Marvin','McDonald','8045 Lovers Lane','25301');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (62,'(913) 496-1897','Phyllis','Tuck','2150 Volunteer Drive','66502');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (63,'(301) 485-6261','Earl','Grimes','6485 Pepper Street','21701');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (64,'(502) 135-7679','Conrad','Fowler','8114 Cherry Street','42420');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (65,'(817) 528-7955','Linda','Riggs','593 White Oak Court','76101');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (66,'(606) 683-4113','Adrian','Greer','6597 Skyline Drive','40422');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (67,'(414) 715-7191','Floyd','Kennedy','3566 Elementary Drive','54305');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (68,'(901) 312-1555','Ella','Kidd','3626 Webster Road','38101');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (69,'(919) 205-8147','Mandy','Elliott','4839 Long Hollow Pike','27514');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (70,'(313) 438-8733','Jerry','Poe','5879 Dixie Way','48233');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (71,'(702) 867-1893','Herman','Moseley','4461 Southern Drive','89114');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (72,'(360) 649-9754','Gayle','Bailey','8233 Whisper Woods Road','98201');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (73,'(603) 075-7437','Hershel','Keen','8124 Industrial Drive','03060');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (74,'(606) 241-3182','Frieda','Hinton','9015 Cherokee Road','41042');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (75,'(802) 433-5007','Sharon','Sexton','2551 Elementary Drive','05641');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (76,'(304) 062-1621','Evelyn','Montgomery','6386 Main Street','25550');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (77,'(520) 520-8733','Bart','Gillespie','3422 Breeder Road','85726');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (78,'(505) 646-2748','Elaine','Hall','1790 Cedar Avenue','88310');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (79,'(317) 995-8449','Darcy','Pitts','523 Shoreside Drive','46206');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (80,'(515) 846-5222','Juanita','Vance','8916 High Street','50010');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (81,'(606) 661-2765','Bessie','Baez','7313 Humble Avenue','41031');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (82,'(307) 448-5424','Basil','Davidson','9102 Rocky Mound Road','82071');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (83,'(414) 334-8130','Ada','Jones','4590 Tobacco Road','54956');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (84,'(617) 467-3438','David','Sims','6623 Glenview Drive','02116');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (85,'(502) 595-1052','Glen','Cartwright','448 Sanders Ferry Road','42001');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (86,'(618) 109-9250','Bert','Hooks','9801 Hatchet Drive','62269');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (87,'(606) 793-3172','Lucille','Cummings','1209 Center Point Road','40391');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (88,'(703) 611-2557','Christa','Mallory','6370 N. Main Street','22101');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (89,'(308) 873-1375','Kaye','Foster','520 Pace Street','68847');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (90,'(408) 427-2162','Connie','Nichols','4039 Greensburg Street','95035');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (91,'(502) 882-7631','Conrad','Ferguson','6300 Dorcas Drive','40207');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (92,'(608) 481-3369','Tim','Zeller','9682 Ridge Top Road','53701');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (93,'(314) 242-5743','Floyd','Dye','7730 Crosby Drive','63155');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (94,'(802) 458-4329','Dan','Kennedy','3108 Troon Court','05401');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (95,'(715) 140-4710','Clarence','Kinser','6964 Poplar Ridge Road','54701');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (96,'(913) 344-4761','Inez','Maynard','3832 College Street','66502');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (97,'(715) 623-0861','Adam','Rich','2759 Peterson Avenue','54401');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (98,'(701) 691-3002','Wilmer','Pardue','1790 N. Main Street','58102');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (99,'(717) 244-3484','Luther','Bell','5703 Cave Springs Road','17325');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (100,'(606) 326-9807','Reva','Killen','5442 Halltown Road','41056');
INSERT INTO CUSTOMERS(CUSTOMERID, PHONE, FIRSTNAME, LASTNAME, ADDRESS, ZIPCODE) VALUES (101,'(518)-666-9870','Joe','Man','654 Main Street','52635');
[*]
mikeses
 
Posts: 1
Joined: 29. November 2013 17:54
Operating System: Windows 8.0

Re: PHP Form Will Not Update InnoDB

Postby Nobbie » 29. November 2013 23:16

Your PHP Script does not have any error handling, therefore you have no idea, whether the SQL Statements are going wrong or not. You really should modify the script and evaluate the return value of mysql_query() and so on (see the documentation if you dont know how) and return an appropriate error message, if something is going wrong. There is a function mysql_error() which returns a message corresponding to the last error, if an error occurs.

If you have succeeded to extend your script to a proper error handling, you definately will find out the reason for what is going wrong.
Nobbie
 
Posts: 8775
Joined: 09. March 2008 13:04


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 44 guests