CodingForums.com - View Single Post - INSERT Rows where userid=(SELECT id FROM userinfo)

Vernk · 09-24-2012, 04:20 PM

Hello I'm trying to do something like this

Code:

INSERT INTO VotingSite (VotingSiteType, active) VALUES ('10', 0) WHERE userid=(SELECT ID FROM userinfo)

Doesn't work any ideas?

It's suppose to add a row with the userid

09-24-2012, 04:20 PM	PM User \| #1
Vernk Regular Coder Join Date: Oct 2011 Posts: 113 Thanks: 9 Thanked 1 Time in 1 Post	INSERT Rows where userid=(SELECT id FROM userinfo) Hello I'm trying to do something like this Code: INSERT INTO VotingSite (VotingSiteType, active) VALUES ('10', 0) WHERE userid=(SELECT ID FROM userinfo) Doesn't work any ideas? It's suppose to add a row with the userid