 |
 |
 |
tableborder = 0;
$mytree->tcellspacing = 2;
$mytree->tcellpadding = 2;
$mytree->divdisplay = "none";
echo "| ";
$mytree->createTreeFromDB($result);
echo " | ";
}
?>
|
|
 |
|
= $regday";
$result = mysql_query($query0);
$row=mysql_fetch_row($result);
$page=$row[0];
}
else if($class&&$p_num){ //Ʈ ڽ
$query0 ="SELECT count(p_num) FROM product WHERE class1 LIKE '%$class%' AND p_num >= $p_num";
$result = mysql_query($query0);
$row=mysql_fetch_row($result);
//$page=$row[0];
}
else if(!$class){$class=" ";}
// üԽù .
if(!eregi("[^[:space:]]+",$key)) {
$query = "SELECT count(p_num) FROM product WHERE class1 LIKE '%$class%'";
}
else{
$encoded_key = urlencode($key);
$query = "SELECT count(p_num) FROM product WHERE $keyfield LIKE '%$key%'";
}
$result = mysql_query($query);
if (!$result) {
error("QUERY_ERROR");
exit;
}
$total_record = mysql_result($result,0,0);
if(strlen($page)==0) {
$page = 1;
$pre = 0;
$next =2;
}
else{
$pre=$page-1;
$next=$page+1;
}
//modified the function of the query so that it does not query the whole table
//affected objects: page querystring value - instead of the page number it now reflects the name of the product
// query now filters based on the product name selected
if(!eregi("[^[:space:]]+",$key)) {
//$query = "SELECT p_num,p_name,filename,p_com1,p_spec, p_feature,p_function, p_system, p_view, p_regday, class1,filename1,filename2,filename3 FROM product WHERE class1 LIKE '%$class%' ORDER BY p_num DESC";
$query = "SELECT p_num, p_name, filename, p_com1, p_spec, p_feature, p_function, p_system, p_view, p_regday, class1, filename1, filename2, filename3 FROM product WHERE class1 LIKE '%$class%' AND p_name = '$page' ORDER BY p_num DESC";
}
//echo $query;
$result= mysql_query($query);
if (mysql_num_rows($result)){
// ٰԽù ퟏ(Խù Ϸù )
// $i=$page-1;
$i=0;
$my_num = mysql_result($result,$i,0);
$my_name = mysql_result($result,$i,1);
$my_filename = mysql_result($result,$i,2);
$my_com1 = mysql_result($result,$i,3);
$my_spec = mysql_result($result,$i,4);
$my_feature = mysql_result($result,$i,5);
$my_function = mysql_result($result,$i,6);
$my_system = mysql_result($result,$i,7);
$my_view = mysql_result($result,$i,8);
$my_regday = mysql_result($result,$i,9);
$my_class1 = mysql_result($result,$i,10);
$my_filename1 = mysql_result($result,$i,11);
$my_filename2 = mysql_result($result,$i,12);
$my_filename3 = mysql_result($result,$i,13);
$my_name = stripslashes($my_name);
$my_com1 = stripslashes($my_com1);
$my_spec = stripslashes($my_spec);
$my_feature = stripslashes($my_feature);
$my_function = stripslashes($my_function);
$my_system = stripslashes($my_system);
$my_com1 = nl2br($my_com1);
$my_spec = nl2br($my_spec);
$my_feature = nl2br($my_feature);
$my_function = nl2br($my_function);
$my_system = nl2br($my_system);
$my_regdate = date("Y-m-d",$my_regday);
if($my_filename=="") {$my_filename="sample.gif";}
?>
|
|
|
|
 |
|
$my_com1 |
";
}
if(strlen($my_feature)==0) {echo "";}
else{
echo "
 |
$my_feature |
";
}
if(strlen($my_function)==0) {echo "";}
else{
echo "
 |
$my_function |
";
}
if(strlen($my_spec)==0) {echo "";}
else{
echo "
 |
$my_spec |
";
}
if(strlen($my_system)==0) {echo "";}
else{
echo "
 |
$my_system |
";
if ( ($my_filename1 != "") || ($my_filename2 != "") || ($my_filename3 != "") ) {
echo "
| |
| ";
}
echo " ";
}
?>
|
|
