Code: Select all
<?
include("kb_includes.php");
$title = "Test";
head($title,$title);
chec36_db_connect() or die("Cannot connect");
$query = "SELECT DISTINCT kb_record.question, kb_record.resolution, kb_record.kb_record_id, kb_record.recordno, complete_record.kb_record_id
FROM kb_record, complete_record
WHERE kb_record.kb_record_id = complete_record.kb_record_id
AND kb_record.comp_manual='T'";
//search for manual records with a specific date
if(IsSet($man_date))
$query .= " AND kb_record.dateadd_manual='$man_date'";
//group by and order by
$query .= " ORDER BY kb_record.recordno";
$result = mysql_query($query);
echo mysql_num_rows($result);
?>Code: Select all
<?
include("kb_includes.php");
$title = "Test";
head($title,$title);
chec36_db_connect() or die("Cannot connect");
$query = "SELECT DISTINCT kb_record.question, kb_record.resolution, kb_record.kb_record_id, kb_record.recordno, complete_record.kb_record_id
FROM kb_record, complete_record
WHERE kb_record.kb_record_id = complete_record.kb_record_id
AND kb_record.comp_manual='T'";
//search for a specific application, if applicable
if($app_id <> 'all_apps')
$query .= " AND complete_record.app_id='$app_id'";
//search for a specific category, if applicable
if($cat_id <> 'all_cats')
$query .= " AND complete_record.cat_id='$cat_id'";
//search for manual records with a specific date
if(IsSet($man_date))
$query .= " AND kb_record.dateadd_manual='$man_date'";
//group by and order by
$query .= " ORDER BY kb_record.recordno";
$result = mysql_query($query);
echo mysql_num_rows($result);
?>