RE: SQL Error Help ! 05-09-2013, 11:49 PM
#8
(05-09-2013, 11:44 PM)Ronnie Wrote:(05-09-2013, 11:33 PM)Geo Wrote:(05-09-2013, 11:31 PM)Ronnie Wrote: So add quotes around the numbers and remove the quotes not needed for fe and what you said?
Ill try this later when my web host is back up, thanks!
The first option of filling the note should work, but yeah that's what I mean.
What do you mean by filling the note?
Im new to SQL
The note field is empty in the second set of values (second set of brackets) ... it is set as '' whereas in others it includes data such as 'Nely' or whatever. Here is what it should be, I changed the missing note to USERNAME for example purposes.
Code:
INSERT INTO `fe` (`ID`, `userID`, `type`, `ip`, `note`)
VALUES (1,12,'e','110.175.100.136','Auspride018'),(2,13,'e','94.197.11.24','USERNAME'),(3,8,'f'​,'50.138.30.101','Nely'),(4,8,'f','50.55.247.24','Brittany'),(5,8,'f','98.94.78.​64','channa'),(6,8,'f','108.210.196.40','Hector'),(7,8,'f','70.100.180.240','Kim​mie'),(8,8,'f','50.33.227.18','Karissa'),(9,8,'f','108.214.117.105','Lilla');You see?
![[+]](https://sinister.ly/images/modern/collapse_collapsed.png)