CREATE TABLE IF NOT EXISTS `t_polls` (
  `polls_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `topic_id` int(10) unsigned NOT NULL,
  `users_id` int(10) unsigned NOT NULL,
  `polls_title` varchar(255) NOT NULL,
  PRIMARY KEY (`polls_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

CREATE TABLE IF NOT EXISTS `r_polls_isfrom_question` (
  `question_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `polls_id` int(10) unsigned NOT NULL,
  `question_content` varchar(250) NOT NULL,
  `nbvote` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`question_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

		$polls_title=$_POST['polls_title'];
		$polls_question=$_POST['polls_question'];	
		$topic_id=$_POST['topic_id'];
		
		$polls=$cnx->prepare('INSERT INTO t_polls
		(polls_title, topic_id)
		VALUES(:polls_title, :topic_id)');
		$polls->bindValue(':polls_title', $polls_title, PDO::PARAM_STR);
		$polls->bindValue(':topic_id', $topic_id, PDO::PARAM_INT);
		$polls->execute();	
		$polls_question = $_POST['polls_question'];
		$order=$cnx->prepare('SELECT
		 question_order
		FROM r_polls_isfrom_question	
		ORDER BY question_id DESC
		LIMIT 0 , 1');
		$order->execute();		
		if ($order->rowCount()!=0){
			$data=$order->fetch();{
				$question_order = $data['question_order']+1;
			}
		}
		else{
			$question_order = 1;
		}
		print_r($polls_question);
		foreach($polls_question as $content){
			$polls=$cnx->prepare('INSERT INTO r_polls_isfrom_question
			(question_id, polls_id, question_content)
			VALUES(:polls_id, :question_order, :question_content)');
			$polls->bindValue(':polls_id', $polls_id, PDO::PARAM_INT);
			$polls->bindValue(':question_order', $question_order, PDO::PARAM_INT);
			$polls->bindValue(':question_content', $content, PDO::PARAM_STR);
			$polls->execute();
		}	
		$polls->CloseCursor(); 
		echo'<p><span class="reussi">Le sondage a bien &eacute;t&eacute; ajout&eacute; !</span></p>';

create table users (
	idUser int unsigned not null auto_increment primary key,
	nom		varchar(25) not null
)engine=innodb;
create table sondages (
	idSondage 	int unsigned not null auto_increment primary key,
	idUser		int unsigned not null,
	titreSondage varchar(50) not null,
	description	varchar(250) not null,
	constraint fk_user foreign key(idUser) references users(idUser)
) engine=innodb;

create table reopnseSondage(
	idQuestion	int unsigned not null auto_increment primary key,
	idSondage	int unsigned not null,
	question	varchar(250)	not null,
	nbvote		int not null	default 0,
	constraint fk_sondage foreign key (idSondage) references sondages(idSondage)
)engine=innodb;