<?php

// Make a MySQL Connection
mysql_connect("server", "user", "password") or die(mysql_error());
mysql_select_db("dbase") or die(mysql_error());

$start = 1;
if (isset($_REQUEST['start']))
{
  $start = $_REQUEST['start'];
}
$limit = 10;
if (isset($_REQUEST['limit'])) {
  $limit = $_REQUEST['limit'];
}




$query ="Select
title,
threadid,
username,
userid,
dateline,
postid,
forumtitle,
forumid,
replycount,
lastpost
 from test Limit ".$start.", ".$limit;

$result = mysql_query($query)
or die(mysql_error());
$row = mysql_fetch_assoc($result);

$data = array();

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
	$data[] = array(
	'title' => $row['title'],
	'threadid' => $row['threadid'],
	'username' => $row['username'],
	'userid' => $row['userid'],
	'dateline' => $row['dateline'],
	'postid' => $row['postid'],
	'forumtitle' => $row['forumtitle'],
	'forumid' => $row['forumid'],
	'replycount' => $row['replycount'],
	'lastpost' => $row['lastpost']
	);

}



$myData = array(
    "topics" => $data,
    "totalCount" => count($data)
);


echo json_encode($myData);
?>

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `test`
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `title` varchar(50) DEFAULT NULL,
  `threadid` int(11) DEFAULT NULL,
  `username` varchar(50) DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  `dateline` date DEFAULT NULL,
  `postid` int(11) DEFAULT NULL,
  `forumtitle` varchar(50) DEFAULT NULL,
  `forumid` int(11) DEFAULT NULL,
  `replycount` int(11) DEFAULT NULL,
  `lastpost` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=cp1251;

-- ----------------------------
-- Records of test
-- ----------------------------
INSERT INTO `test` VALUES ('23423', '234234', '23423', '4234', '0000-00-00', '4234', '234234', '234', '23423', '423423');
INSERT INTO `test` VALUES ('111', '22', '333', '444', '0000-00-00', '4444', '5555', '555', '55', '55');
INSERT INTO `test` VALUES (null, '6', '6', '6', null, '6', '6', '5', '6', null);
INSERT INTO `test` VALUES (null, null, '5', '5', '0000-00-00', '5', null, null, null, null);