Top300 Download Papers

| RePEc |

\n" ; echo "

Please enter a set of paper numbers (1-300): -

\n" ; echo "

Sort by Download frequency \n" ; echo " Author

\n" ; echo "

\n" ; echo "

\n" ; echo " \n" ; echo "



*This website is maintained by Nai Yu Liu, LIS651, Palmer School, LIU*
" ; } //check numeric paper no elseif(! is_numeric($start_p_no)) { echo "Sorry! Please enter a set of paper numbers! \n" ; echo '
| ', Home, ' |
'; echo "
" ; } //check numeric paper no elseif (! is_numeric($end_p_no)){ echo "Sorry! Please enter a set of paper numbers! \n" ; echo '
| ', Home, ' |
'; echo "
" ; } //check number coverage elseif ($start_p_no <= 0 or $end_p_no >=301 or $start_p_no > $end_p_no){ echo "Sorry! A wrong set of paper numbers, please try again! \n" ; echo '
| ', Home, ' |
'; echo "
" ; } //do query //check sort value download elseif ($sort == 'download') { $link=mysql_connect('localhost:6033', 'liu', 'mmilkmilk'); mysql_select_db('liu'); $query_sort_d="SELECT * FROM economics WHERE economics.order >=$start_p_no AND economics.order <=$end_p_no " ; // print "submittiing: $query
"; $result_d=mysql_query($query_sort_d); //check query error $error=mysql_error(); if($error) { print "mySQL error: $error
\n" ; } //print paper no and sort method echo 'Paper no.' .$start_p_no. '-' .$end_p_no. ' ; Sort by Download frequency' ; echo '
| ', Home, ' |
'; echo "
" ; //print result sort by download frequency echo " \n" ; echo " \n" ; while ($row_d=mysql_fetch_array($result_d)){ echo " \n" ; } echo "
\n" ; echo 'No.' ; echo " \n" ; echo 'Download#' ; echo " \n" ; echo 'Bibliographic description' ; echo "
\n" ; echo $row_d['order'] ; echo " \n" ; echo $row_d['down'] ; echo " \n" ; echo $row_d['author'] ; echo '. (' .$row_d['year']. ')' ; echo '. ' .$row_d['article_title'] ; echo '. ' .$row_d['journal_title'] ; echo ', ' .$row_d['vol'] ; echo '(' .$row_d['issue']. ')' ; echo ', ' .$row_d['p_start'] ; echo '-' .$row_d['p_end']. '.' ; echo "
\n" ; //print top link if ($total_records >=15){ echo "
| Top |
" ; } } //check sort value author else { //print result sort by author $link=mysql_connect('localhost:6033', 'liu', 'mmilkmilk'); mysql_select_db('liu'); $query_sort_a="SELECT * FROM economics WHERE economics.order >=$start_p_no AND economics.order <=$end_p_no ORDER BY author" ; //print "submittiing: $query
"; $result_a=mysql_query($query_sort_a); //print paper no. and sort method echo 'Paper no.' .$start_p_no. '-' .$end_p_no. ' ; Sort by Author' ; echo '
| ', Home, ' |
'; echo "
" ; // print result sort by author; echo "" ; echo "" ; while ($row_a=mysql_fetch_array($result_a)){ echo "" ; } echo "
" ; echo 'No.' ; echo "" ; echo 'Download#' ; echo "" ; echo 'Bibliographic description' ; echo "
" ; echo $row_a['order'] ; echo "" ; echo $row_a['down'] ; echo "" ; echo $row_a['author'] ; echo '. (' .$row_a['year']. ')' ; echo '. ' .$row_a['article_title'] ; echo '. ' .$row_a['journal_title'] ; echo ', ' .$row_a['vol'] ; echo '(' .$row_a['issue']. ')' ; echo ', ' .$row_a['p_start'] ; echo '-' .$row_a['p_end']. '.' ; echo "
" ; //print top link if ($total_records >=15){ echo "
| Top |
" ; } } ?>

Valid XHTML 1.0!