Re: sql query problem

Alok Thakur <alokthakur1987(at)gmail(dot)com> wrote:

> Dear,
>
> I am trying to provide you as much details as possible.
>
> answer` (
> `id` int(10) NOT NULL AUTO_INCREMENT,
> `question_id` int(10) NOT NULL,
> `user_id` int(10) NOT NULL,
> `answer` int(10) NOT NULL, ->
> `status` tinyint(1) NOT NULL, --> Status will be 0 or 1 means wrong
> or right answer
> `date` datetime NOT NULL,
> PRIMARY KEY (`quiz_result_id`)
> )
>
> user` (
> `user_id` int(11) NOT NULL AUTO_INCREMENT,
> `user` varchar(255) NOT NULL,
> `username` varchar(255) NOT NULL,
> `user_email` varchar(255) NOT NULL,
> `user_gender` varchar(255) NOT NULL,
> `refrence` varchar(255) NOT NULL,
> `join_date` varchar(255) NOT NULL,
> `status` tinyint(1) NOT NULL,
> `banned` tinyint(1) NOT NULL,
> PRIMARY KEY (`user_id`)
> )

That's MySQL (i guess), please join a mysql-list.

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°