[Shelly]

im new at this, just helping someone out, and this is the first product that i had any issues with. when i tried to upgrade your code i keep getting a table already created error:

Database error in vBulletin 3.5.4:

Invalid SQL:

CREATE TABLE adopt (
adoptableid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(20) NOT NULL,
img1url VARCHAR(255) NOT NULL,
img2url VARCHAR(255) NOT NULL,
img3url VARCHAR(255) NOT NULL,
img4url VARCHAR(255) NOT NULL,
img5url VARCHAR(255) NOT NULL,
generaldesc TEXT,
desc1 TEXT,
desc2 TEXT,
desc3 TEXT,
desc4 TEXT,
desc5 TEXT,
minposts MEDIUMINT UNSIGNED DEFAULT 0,
stage2posts SMALLINT UNSIGNED,
stage3posts SMALLINT UNSIGNED,
stage4posts SMALLINT UNSIGNED,
stage5posts SMALLINT UNSIGNED,
creatorid INT UNSIGNED NOT NULL,
ownerid INT UNSIGNED NOT NULL DEFAULT 0,
currentstage TINYINT UNSIGNED NOT NULL DEFAULT 1,
startposts INT UNSIGNED,
gender ENUM('Male','Female')
);

MySQL Error : Table 'adopt' already exists
Error Number : 1050
Date : Saturday, June 3rd 2006 @ 06:35:56 PM

i had alow overwrite set to yes

any ideas?