function getResultsOutputJsn()
{
// connect();
$output = "{";
$query = getJoinQuery();
$sql = mysql_query($query) or die(" Join query Failed!" . mysql_error());
$columns_total = mysql_num_fields($sql);
// Get Records from the table
while ($row = mysql_fetch_array($sql, MYSQLI_ASSOC)) {
$output .= "item:" . json_encode($row) . ",";
}
$output = rtrim($output, ",");
$output .= "}";
echo stripcslashes(json_encode($output));
//mysql_close();
}
function getResultsOutputJsn()
{
$output = "{";
$query = getJoinQuery();
$result = runQuery($query);
// Get Records FROM the table
while ($row = $result->fetch_assoc()) {
//mysql_fetch_array($result, MYSQL_ASSOC)) {
$output .= "item:" . json_encode($row) . ",\n";
}
$output = rtrim($output, ",");
$output .= "}";
echo stripcslashes(json_encode($output));
}
