Re: AUTONUMBER

[Alin Brin]

I think i fixed this error but i am getting these following warning errors:


Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in ./dbUtil_class.php on line 85

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in ./dbUtil_class.php on line 99


on this query:

CREATE TABLE Candidates (
candidateID MEDIUMINT ZEROFILL NOT NULL AUTO_INCREMENT,
electionID INT(10) NOT NULL,
name VARCHAR(32) NOT NULL,
PRIMARY KEY(candidateID),
FOREIGN KEY(electionID) REFERENCES Election(electionID)
);