<?php
$sql = "SELECT * FROM submission_tbl WHERE user_id = '$_SESSION[id]' AND status <> 'achieve' AND id='$_SESSION[last_insert_id]'"; 
		$result = mysqli_query($conn, $sql) or die(mysqli_error($conn));
		
								$info = mysqli_fetch_array($result);
									
											$submission_id=$info['id'];
											$date_time=$info['date_time'];
											$jounal_section=$info['jounal_section'];	
											$comments_for_the_editor=$info['comments_for_the_editor'];
											$submission_file=$info['submission_file'];	
											
											$title=$info['title'];	
											$abstract=$info['abstract'];							
											$keywords_text =$info['keywords_text'];
											$language_text =$info['language_text'];
											$agencies =$info['agencies'];
											$references_text =$info['references_text'];
											$status =$info['status'];
											$suggested_reviewers =$info['suggested_reviewers'];
											
											$abstract_html = str_replace("\n", '<br />', $abstract);
											$references_html = str_replace("\n", '<br />', $references_text);
											$suggested_reviewers_html = str_replace("\n", '<br />', $suggested_reviewers);
											
											//-------------------------------------
											//$_SESSION[id]											
											//$user_id=$info['user_id'];
											
											$sql2 = "SELECT * FROM register_tb WHERE id = '$_SESSION[id]'"; 
											$result2 = mysqli_query($conn, $sql2) or die(mysqli_error($conn));					
											$info2 = mysqli_fetch_array($result2);	
												$user_title = $info2['title'];
												$user_first_name = $info2['first_name'];
												$user_middle_name = $info2['middle_name'];
												$user_last_name = $info2['last_name'];
												
												$user_fullname = "$user_title $user_first_name $user_middle_name $user_last_name";
												$user_email = $info2['email'];
											
																				
												
?>