free"; } else { $free = "free"; } ?>
query($sql)) { exit(dbErrorSend("", $sql, basename(__FILE__), __FILE__, __LINE__, $dbx->error, $dbx->errno )); } $row = $db_result->fetch_assoc(); if ($row['total'] <= 0) { print "
No Projects Found
"; exit; } $show_amount = round($row['total'] * ($show_percent/100)); if ($show_amount < 1) { print "
No projects Available
"; exit; } print "
Projects/Business Opportunities
"; print "
Click here to reload this page and view more samples of available projects and business opportunities in 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. $num = $show_amount; $sql = "SELECT * FROM allp 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 )); } 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($sql)) { exit(dbErrorSend("Attempt to get member info failed.", $sql, basename(__FILE__), __FILE__, __LINE__, $dbx->error, $dbx->errno )); } $row2 = $db_result2->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 "
[ Unavailable ]
"; } if ($status == 3) { //if (($level == 'B') or ($level == 'E')) { print "
[ Contact ]
"; //} else { // print "[ Contact ] $v"; //} } print ""; if ($v != NULL) { print "
$v
"; } if ($name_2 != NULL || $email_2 != NULL) { print "
$name_2 $email_2
"; } print "
$projectdescription

"; print "
"; } ?>