$title"; ?>

Select Volume Title this submission*

Enter Page number (e.g 4-6)*

"; print ""; } ?>

'hide' ORDER BY id DESC"; $result7 = mysqli_query($conn, $query7) or die(mysqli_error($conn)); $info7 = mysqli_fetch_array($result7); $id_of_current_volume=$info7['id']; $volume_title=$info7['volume_title']; $query = "SELECT * FROM submission_tbl WHERE (status = 'published' OR status = 'hide') AND volume_id='$id_of_current_volume' ORDER BY id DESC"; //$query = "SELECT * FROM submission_tbl ORDER BY id DESC"; } print "

$volume_title

"; print ' '; $result = mysqli_query($conn, $query) or die(mysqli_error($conn)); //loop through the query result and print if (mysqli_num_rows($result) == 0) { print "

No article in this volume yet! (See all volume and their details)

"; } while($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']; $vol_id =$info['volume_id']; $page_number =$info['page_number']; if($title != ""){ $title_msg = "$title"; }else{ $title_msg="Untitled"; } $authors=""; $all_authors=""; $sql_done = "SELECT * FROM authors_record WHERE submission_id = '$submission_id' ORDER BY id DESC"; $result9 = mysqli_query($conn, $sql_done) or die(mysqli_error($conn)); if (mysqli_num_rows($result9) > 0) { while($info9 = mysqli_fetch_array($result9)) { $all_authors.=$info9['first_name'].", "; } $authors= rtrim($all_authors, ', '); } include("inc_volume.php"); if($status=='hide'){ $status_link="unhide"; $status_msg = "Hidden from public"; }else{ $status_link="hide"; $status_msg = "visible to public"; } /* $sql_done = "SELECT * FROM review_comment WHERE submission_id = '$submission_id' AND status=''"; $result9 = mysqli_query($conn, $sql_done) or die(mysqli_error($conn)); $unapp_review = mysqli_num_rows($result9); $sql_done = "SELECT * FROM review_comment WHERE submission_id = '$submission_id' AND status='approved'"; $result9 = mysqli_query($conn, $sql_done) or die(mysqli_error($conn)); $app_review = mysqli_num_rows($result9); if($status=='completed'){ $status= "$status"; }elseif($status=='archived'){ $status= "$status"; }elseif($status=='published'){ $status= "$status"; } */ print " "; } print "

Id	Submitted Date	Section	Authors	Title	Status	Volume	Page Num.
00$submission_id	$date_time	$jounal_section	$authors	$title_msg	$status	$volume_title	$page_number	$status_msg $status_link	Edit

"; ?>

Published Submissions

$volume_title