[ milan_sr @ 14.12.2010. 20:27 ] @
Zdravo

Imam jedan problem, koristim meni preku kod hocu dinamicki da go prikazujem pogled strane u zavisnost od to koje ID e izbereno, no svako razlicno ID da mi nosi razlican pogled te strane. Sto trebam napraviti za da mogu da gi povikujem te razlicite pogledi na isto mestu?

Id-to go dobijem prema ove fukncije:

//meni (subjects)

function get_all_subject(){
global $connection;
$subject_query = "SELECT * ";
$subject_query .= "FROM subject ";
$subject_query .= "ORDER BY position ASC";
$subject_result = mysql_query($subject_query, $connection);
confirm_query($subject_result);
return $subject_result;
}

//pages

function get_all_pages($subject_id){
global $connection;
$page_query = "SELECT *";
$page_query .= "FROM pages ";
$page_query .= "WHERE subject_id = {$subject_id} LIMIT 6";
//$page_query .= "ORDER BY id DESC"; . " "
$page_result = mysql_query($page_query, $connection);
confirm_query($page_result);
return $page_result;
}

//meni ID

function get_subject_by_id($subject_id){
global $connection;
$query = "SELECT * ";
$query .= "FROM subject ";
$query .= "WHERE id =" . $subject_id . " ";
$query .= "LIMIT 1";
$result_set = mysql_query($query, $connection);
confirm_query($result_set);
// REMEMBER:
// if no rows are returned, fetch_array will return FALSE
if($category = mysql_fetch_array($result_set)){
return $category;
}
else {
return NULL;
}
}

//page ID

function get_pages_by_id($subject_id){
global $connection;
$query = "SELECT * ";
$query .= "FROM pages ";
$query .= "WHERE id =" . $subject_id . " ";
$query .= "LIMIT 1";
$result_set = mysql_query($query, $connection);
confirm_query($result_set);
// REMEMBER:
// if no rows are returned, fetch_array will return FALSE
if($page = mysql_fetch_array($result_set)){
return $page;
}
else {
return NULL;
}

}

-----------------------------------------------------------
trenutno, mjesto gde povikujem Pages je ovo ali ovaj pogled mi e za sve (pr. Home, Videos, Contact US), a ja hocu da prikazujem so razlican HTML

if(isset($_GET['subject'])){
$sel_subject = get_subject_by_id($_GET['subject']);
$sel_page = NULL;
}

else if(isset($_GET['page'])){
$sel_subject = NULL;
$sel_page = get_pages_by_id($_GET['page']);
}

else {
$sel_subject = NULL;
$sel_page = NULL;
}

-------------------------------------------
if(!is_null($sel_subject)) // subject select
{

$pages_result = get_all_pages($sel_subject["id"]);

while($page = mysql_fetch_array($pages_result)){

echo "<div class=\"news\">";
echo "<img src=\"images/news_images/small/{$page[4]}\">";
echo "<a href=\"index.php?page=" . urlencode($page["id"]) . "\"><h2>{$page[2]}</h2></a>";
echo "<p>{$page[3]}</p>";
echo "</div>";
}

}

recite ako treba dodatno objasnenje

hvala