Re: mysql_insert_id(); returnig 0 Record is added and the field is auto_increment?!!

[theodor michailow]

-- Table `mydb`.`clients`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`clients` (
`idclients` INT NOT NULL AUTO_INCREMENT ,
`firstname` VARCHAR(45) NULL ,
`lastname` VARCHAR(45) NULL ,
`service_idservice` INT NOT NULL ,
PRIMARY KEY (`idclients`) ,
INDEX `fk_clients_service1_idx` (`service_idservice` ASC) ,
CONSTRAINT `fk_clients_service1`
FOREIGN KEY (`service_idservice` )
REFERENCES `mydb`.`service` (`idservice` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;

hire is the creation of the table