Unable to connect to the " . "database server at this time.

" ); exit(); } // Select the qna database if (! @mysql_select_db("growedge_article") ) { echo( "

Unable to access " . "database at this time.

" ); exit(); } if (isset($magazine)) { $howlong = strlen($magazine); if ($howlong=="4") { $volnumber=substr($magazine, 0, 2); $issnumber=substr($magazine, -2); } else { $volnumber=substr($magazine, 0, 1); $issnumber=substr($magazine, -2); $leadzero="yes"; } $din=substr($magazine, -1); // Request the issue data $findissueinfo = mysql_query( "SELECT * FROM issue_names WHERE ISSUE_ID='$magazine'"); if (!$findissueinfo) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } $fii = mysql_fetch_array($findissueinfo); $issuename = $fii["ISSUE_NAME"]; $issuestatus = $fii["OUTOFPRINT"]; ?> The Growing Edge Store - Back Issue - <?php print($issuename); ?>

Back to the back issues list

Volume "); echo ereg_replace ("^0", "", $volnumber); print(", Number "); print($din); print(", "); print($issuename); print("

"); print(""); print("
"); print("
="1203") { print(".jpg\">"); } else { print(".gif\">"); } if ($issuestatus=="yes") { print("

Sorry, this issue is out of print

"); } else { if ($magazine==$currissu) { print("

"); print("Subscribe today!

"); } else { print("

"); ?>

Unable to connect to the " . "database server at this time.

" ); exit(); } // Select the stores database if (! @mysql_select_db("growedge_stores") ) { echo( "

Unable to locate the stores " . "database at this time.

" ); exit(); } $mag = sprintf("%04d",$magazine); $lookups = mysql_query( "SELECT * FROM items WHERE TYPE='back' AND DESCRIPTION='$mag'"); if (!$lookups) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } while ($newdata = mysql_fetch_array($lookups)) { print ""; $biprice = $newdata["PRICE"]; } print "

"; print "

$"; print $biprice; print "

"; print "
"; } } print("
"); // Connect to the database server $dbcnx = @mysql_connect("db12.pair.com", "growedge_5_r", "HvNMLsRT"); if (!$dbcnx) { echo( "

Unable to connect to the " . "database server at this time.

" ); exit(); } // Select the qna database if (! @mysql_select_db("growedge_article") ) { echo( "

Unable to access " . "database at this time.

" ); exit(); } // Get all articles for issue from the main lookup $findarts = mysql_query( "SELECT * FROM main_lookup WHERE VOLUME='$volnumber' AND ISSUE='$issnumber' Order by ARTICLE_ID ASC"); if (!$findarts) { echo("

Error performing query: " . mysql_error() . "

"); exit(); } while ($fa = mysql_fetch_array($findarts)) { $volid = $fa["VOLUME"]; $issid = $fa["ISSUE"]; $artid = $fa["ARTICLE_ID"]; $title = $fa["TITLE"]; $author = $fa["AUTHOR"]; $pagenumber = substr($artid, -2); print("

\""); if ($magazine == $currissu) { print(""); } else { print(""); } print($title); print(",\" by "); print($author); //print(", Vol. "); //print($volid); //print(", No. "); //print($issid); //print(", "); //print($issuename); //print(", Page "); //print($pagenumber); print("

"); } } else { print("

"); print("Sorry, there was no issue by that name."); print("

"); print("

"); print(""); print("Go back and select an issue."); } include($_SERVER['DOCUMENT_ROOT']."/footer.txt"); ?>

"; ?>
"; ?>
"; print "
"; include($_SERVER['DOCUMENT_ROOT']."/store/sidebar.inc"); print " 
 
 
 
"; virtual("/cgi-bin/ads.pl"); ?>