"; //} } print ""; if ($v != NULL) { print "
$v
"; } if ($name_2 != NULL || $email_2 != NULL) { print "
★ $name_2 $email_2
"; } print "
$projectdescription

"; print ""; } print ""; ?>
query($sql)) { exit(dbErrorSend("", $sql, basename(__FILE__), __FILE__, __LINE__, $dbx->error, $dbx->errno )); } print "
Projects/Business Opportunities
"; print "
Click HERE to reload this page and view more samples of available
projects and business opportunities within the eAllianceMaker network.

Click the [Contact] link in the opportunity to view and evaluate its details.
Only registered members can access the contact information.
Registration is quick, easy, and FREE.
"; // Display project records. if ($_SESSION['loggedin'] == TRUE) { $num = 20; } else { $num = 10; } $sql = "SELECT * FROM $table WHERE status=2 or status=3 ORDER BY RAND() LIMIT $num"; if ( ! $db_result = $dbx->query($sql)) { exit(dbErrorSend("", $sql, basename(__FILE__), __FILE__, __LINE__, $dbx->error, $dbx->errno )); } $num_of_rows = $db_result->num_rows; if ($num_of_rows <= 0) { print "


No projects found.
"; exit;} while($row = $db_result->fetch_assoc()) { $id = $row['id']; $refid = $row['refid']; $datecreated = $row['datecreated']; $category = $row['category']; $status = $row['status']; $position = $row['position']; $country = $row['country']; $price = $row['price']; $projectdescription = $row['projectdescription']; $positiontext = ($position == 'S') ? 'Seeking' : 'Offering'; $name_2 = NULL; $email_2 = NULL; if ($membershipid == $refid) { // Project was added by someone in viewer's alliance. // Get name and email of network alliance member. $table2 = 'allc'; $sql2 = "SELECT name, email FROM $table2 WHERE membershipid = $refid LIMIT 1"; if ( ! $db_result2 = $dbx->query($sql2)) { exit(dbErrorSend("", $sql2, basename(__FILE__), __FILE__, __LINE__, $dbx->error, $dbx->errno )); } $row2 = $db_result->fetch_assoc(); $name_2 = $row2['name']; $email_2 = $row2['email']; } print "
"; if ($membershipid > 0) { $v = checkViewed($id, $membershipid, $dbx); } else { $v = NULL; } print "
$category ($positiontext)
$country
"; if ($status == 2) { print ""; } if ($status == 3) { //if (($level == 'B') or ($level == 'E')) { print ""; //} else { // print "
[ Contact ] $v