mysql_insert_id return 0
#5

It is AI, and key primary, that's the reason I'm asking here

Код:
CREATE TABLE IF NOT EXISTS `cocars` (
  `vID` int(12) NOT NULL AUTO_INCREMENT,
  `vModel` smallint(4) NOT NULL,
  `vType` smallint(3) NOT NULL DEFAULT '0',
  `vUsage` smallint(3) NOT NULL DEFAULT '0',
  `vUsedFor` smallint(3) NOT NULL DEFAULT '0',
  `vLocX` float NOT NULL DEFAULT '0',
  `vLocY` float NOT NULL DEFAULT '0',
  `vLocZ` float NOT NULL DEFAULT '0',
  `vAngle` float NOT NULL DEFAULT '0',
  `vColor1` smallint(3) NOT NULL DEFAULT '0',
  `vColor2` smallint(3) NOT NULL DEFAULT '0',
  `vRespawnDelay` int(12) NOT NULL DEFAULT '0',
  `vFaction` smallint(3) NOT NULL DEFAULT '0',
  `vJob` smallint(3) NOT NULL DEFAULT '0',
  `vLocked` tinyint(1) NOT NULL DEFAULT '0',
  `vInt` smallint(3) NOT NULL DEFAULT '0',
  `vViwo` smallint(3) NOT NULL DEFAULT '0',
  `vOwner` varchar(24) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'No-one',
  `vSpawned` tinyint(1) NOT NULL DEFAULT '0',
  `vehHealth` float NOT NULL DEFAULT '0',
  `vPanels` int(12) NOT NULL DEFAULT '0',
  `vDoors` int(12) NOT NULL DEFAULT '0',
  `vehLights` int(12) NOT NULL DEFAULT '0',
  `vTires` int(12) NOT NULL DEFAULT '0',
  `vLock` tinyint(1) NOT NULL DEFAULT '0',
  `vAlarm` tinyint(1) NOT NULL DEFAULT '0',
  `vImobilizator` tinyint(1) NOT NULL DEFAULT '0',
  `vFuel` smallint(3) NOT NULL DEFAULT '0',
  `vSecurity` tinyint(1) NOT NULL DEFAULT '0',
  `vTuned` tinyint(1) NOT NULL DEFAULT '0',
  `vNeon` int(5) NOT NULL DEFAULT '0',
  `vNumberPlate` int(8) NOT NULL DEFAULT '0',
  `vPaintJob` tinyint(1) NOT NULL DEFAULT '0',
  `vSpoiler` smallint(5) NOT NULL DEFAULT '0',
  `vHood` smallint(5) NOT NULL DEFAULT '0',
  `vRoof` smallint(5) NOT NULL DEFAULT '0',
  `vSkirt` smallint(5) NOT NULL DEFAULT '0',
  `vLamps` smallint(5) NOT NULL DEFAULT '0',
  `vNitro` smallint(5) NOT NULL DEFAULT '0',
  `vExhaust` smallint(5) NOT NULL DEFAULT '0',
  `vWheels` smallint(5) NOT NULL DEFAULT '0',
  `vStereo` smallint(5) NOT NULL DEFAULT '0',
  `vHydraulics` smallint(5) NOT NULL DEFAULT '0',
  `vFrontBumper` smallint(5) NOT NULL DEFAULT '0',
  `vRearBumper` smallint(5) NOT NULL DEFAULT '0',
  `vVentRight` smallint(5) NOT NULL DEFAULT '0',
  `vVentLeft` smallint(5) NOT NULL DEFAULT '0',
  `vTimesDestroy` smallint(2) NOT NULL DEFAULT '0',
  `vGPS` tinyint(1) NOT NULL DEFAULT '0',
  `vMelee` smallint(2) NOT NULL DEFAULT '0',
  `vWeap1` smallint(2) NOT NULL DEFAULT '0',
  `vWeap2` smallint(2) NOT NULL DEFAULT '0',
  `vAmmo1` smallint(5) NOT NULL DEFAULT '0',
  `vAmmo2` smallint(5) NOT NULL DEFAULT '0',
  `vDrug1` smallint(5) NOT NULL DEFAULT '0',
  `vDrug2` smallint(5) NOT NULL DEFAULT '0',
  `vDrug3` smallint(5) NOT NULL DEFAULT '0',
  `vDrug4` smallint(5) NOT NULL DEFAULT '0',
  `vDrug5` smallint(5) NOT NULL DEFAULT '0',
  `vDrugCode1` mediumint(6) NOT NULL DEFAULT '0',
  `vDrugCode2` mediumint(6) NOT NULL DEFAULT '0',
  `vDrugCode3` mediumint(6) NOT NULL DEFAULT '0',
  `vDrugCode4` mediumint(6) NOT NULL DEFAULT '0',
  `vDrugCode5` mediumint(6) NOT NULL DEFAULT '0',
  `vTokiVoki` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`vID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=34 ;
I found some strange error, as you can see in structure default AUTO_INCREMENT is 34, and when I buy car id start from 1 :/

here is vID not Primary but I changed it in pma
Reply


Messages In This Thread
mysql_insert_id return 0 - by CoaPsyFactor - 05.06.2012, 23:08
Re: mysql_insert_id return 0 - by JaTochNietDan - 06.06.2012, 08:45
Re: mysql_insert_id return 0 - by CoaPsyFactor - 06.06.2012, 08:51
Re: mysql_insert_id return 0 - by JaTochNietDan - 06.06.2012, 08:53
Re: mysql_insert_id return 0 - by CoaPsyFactor - 06.06.2012, 09:14

Forum Jump:


Users browsing this thread: 1 Guest(s)