$type = $_REQUEST['type'];
$keyword = $_REQUEST['key'];
$id = $_REQUEST['id'];
if (strlen($type) == 0)
$type = "project";
// create list of clients
include("include/functions.php");
$link = ConnectDB();
if ($type == "project") {
$project_id = $id;
$query = "SELECT name, image, web_url, show_url, praise, project_id FROM project WHERE ";
if (strlen($keyword) > 0)
$query .= sprintf("keyword='%s'", $keyword);
else
$query .= "project_id=" . $project_id;
$result = mysql_query($query)
or die("Invalid query: " . mysql_error());
// display project short description
if ($row = mysql_fetch_object($result)) {
$name = $row->name;
$image = $row->image;
if ($row->show_url) {
$web_url = web_link($row->web_url);
$url_text = sprintf("", $web_url);
}
else
$url_text = "";
$praise = $row->praise;
$id = $row->project_id;
}
}
else if ($type == "partner") {
$partner_id = $id;
$query = "SELECT company, image, web_url, praise, partner_id FROM partner WHERE ";
if (strlen($keyword) > 0)
$query .= sprintf("keyword='%s'", $keyword);
else
$query .= "project_id=" . $project_id;
$result = mysql_query($query)
or die("Invalid query: " . mysql_error());
// display project short description
if ($row = mysql_fetch_object($result)) {
$name = $row->company;
$image = $row->image;
$web_url = web_link($row->web_url);
$url_text = sprintf("", $web_url);
$praise = $row->praise;
$id = $row->partner_id;
}
}
?>
|
||||||||||||||