Database Question and Answers Connect

Pavle

Well-known member
Joined
Oct 4, 2016
Messages
47
Programming Experience
1-3
[FONT=&quot]Here is table with all columns: Here is table with all columns: http://imageshack.com/a/img923/6084/XNsNPv.png[/FONT]
[FONT=&quot]I created one table like this:[/FONT]
[FONT=&quot]CREATE TABLE Pitanja
(
ID int NOT NULL IDENTITY (1,1) PRIMARY KEY,
Pitanje nvarchar(1000) NOT NULL,
Odgovor int NOT NULL,
OpcijaA nvarchar(1000) NOT NULL,
OpcijaB nvarchar(1000) NOT NULL,
OpcijaC nvarchar(1000) NOT NULL,
OpcijaD nvarchar(1000) NOT NULL
);[/FONT]

[FONT=&quot]This is one part of table Pitanja[/FONT]
[FONT=&quot]INSERT INTO Pitanja(Pitanje,Odgovor,OpcijaA,OpcijaB,OpcijaC,OpcijaD) VALUES('Blizu kog grada se nalaze Sremski Karlovci',3,'Rume','Sremske Mitrovice','Novog Sada','?ida');[/FONT]
[FONT=&quot]Answers column contains number of correct choice,not word of correct choice.How to check answer when user select one of four choices from four buttons?[/FONT]
 
Back
Top Bottom