|
$query_taxQuestion = "SELECT questionID, questionType, question FROM questions WHERE questionType ='Tax Issues'";
$taxQuestion = mysql_query($query_taxQuestion, $firm) or die(mysql_error());
$row_taxQuestion = mysql_fetch_assoc($taxQuestion);
$totalRows_taxQuestion = mysql_num_rows($taxQuestion);
$maxRows_vatQuestion = 10;
$pageNum_vatQuestion = 0;
if (isset($HTTP_GET_VARS['pageNum_vatQuestion'])) {
$pageNum_vatQuestion = $HTTP_GET_VARS['pageNum_vatQuestion'];
}
$startRow_vatQuestion = $pageNum_vatQuestion * $maxRows_vatQuestion;
$query_vatQuestion = "SELECT questionID, questionType, question FROM questions WHERE questionType ='VAT Issues'";
$query_limit_vatQuestion = sprintf("%s LIMIT %d, %d", $query_vatQuestion, $startRow_vatQuestion, $maxRows_vatQuestion);
$vatQuestion = mysql_query($query_limit_vatQuestion, $firm) or die(mysql_error());
$row_vatQuestion = mysql_fetch_assoc($vatQuestion);
if (isset($HTTP_GET_VARS['totalRows_vatQuestion'])) {
$totalRows_vatQuestion = $HTTP_GET_VARS['totalRows_vatQuestion'];
} else {
$all_vatQuestion = mysql_query($query_vatQuestion);
$totalRows_vatQuestion = mysql_num_rows($all_vatQuestion);
}
$totalPages_vatQuestion = ceil($totalRows_vatQuestion/$maxRows_vatQuestion)-1;
$maxRows_otherQuestions = 10;
$pageNum_otherQuestions = 0;
if (isset($HTTP_GET_VARS['pageNum_otherQuestions'])) {
$pageNum_otherQuestions = $HTTP_GET_VARS['pageNum_otherQuestions'];
}
$startRow_otherQuestions = $pageNum_otherQuestions * $maxRows_otherQuestions;
$query_otherQuestions = "SELECT questionID, questionType, question FROM questions WHERE questionType ='Other Issues'";
$query_limit_otherQuestions = sprintf("%s LIMIT %d, %d", $query_otherQuestions, $startRow_otherQuestions, $maxRows_otherQuestions);
$otherQuestions = mysql_query($query_limit_otherQuestions, $firm) or die(mysql_error());
$row_otherQuestions = mysql_fetch_assoc($otherQuestions);
if (isset($HTTP_GET_VARS['totalRows_otherQuestions'])) {
$totalRows_otherQuestions = $HTTP_GET_VARS['totalRows_otherQuestions'];
} else {
$all_otherQuestions = mysql_query($query_otherQuestions);
$totalRows_otherQuestions = mysql_num_rows($all_otherQuestions);
}
$totalPages_otherQuestions = ceil($totalRows_otherQuestions/$maxRows_otherQuestions)-1;
$query_Answers = "SELECT * FROM questions";
$Answers = mysql_query($query_Answers, $firm) or die(mysql_error());
$row_Answers = mysql_fetch_assoc($Answers);
$totalRows_Answers = mysql_num_rows($Answers);
$currentPage = $HTTP_SERVER_VARS["PHP_SELF"];
$queryString_taxQuestion = "";
if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) {
$params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_taxQuestion") == false &&
stristr($param, "totalRows_taxQuestion") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_taxQuestion = "&" . implode("&", $newParams);
}
}
$queryString_taxQuestion = sprintf("&totalRows_taxQuestion=%d%s", $totalRows_taxQuestion, $queryString_taxQuestion);
?>
This page is intended to be an information
resource for small businesses and their
owners. The links below provide answers
to frequently asked questions, access
to technical briefings and useful web
addresses. If you can't find what you
are looking for here please use our enquiry
form to email us your problem. |