Login Register


SQL Error Help ! filter_list
Author
Message
RE: SQL Error Help ! #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?

Reply





Messages In This Thread
SQL Error Help ! - by Ronnie - 05-09-2013, 09:24 PM



Users browsing this thread: 1 Guest(s)