<?php
/*
IPHONE SERVICE SERVER PART

*/
    if ($dbg == "1")
    {
        print("Hello World");
        print_r($_GET);
    }
    $dbg = $_GET['dbg'];
    $ct_id = (int)$_GET['CID'];
    $link = mysql_connect(' PASSWORD INFO NOT FOR YOUR EYES!! ' )
        or die("ERROR Could not connect: " . mysql_error());
    //if ()
    if ($dbg == "1")
        print ("Connected successfully <br>\n");

    mysql_select_db('flowerserv_shop', $link)
        or die ('Can\'t use flowerserv_shop : ' . mysql_error());
    if ($dbg == "1")
        print ("DB select flowerserv_shop successfully <br>\n");


    $result = mysql_query("SELECT * FROM products_to_categories AS pc JOIN products ON pc.products_id = products.products_id JOIN products_description AS pd ON pd.products_id = products.products_id WHERE pc.categories_id = $ct_id AND pd.language_id = 4", $link)

    while ($row = mysql_fetch_array($result))
    {
        $finalRes[] = $row;
    }
    if ($dbg == "1")
        print_r($finalRes);
    print(json_encode($finalRes));
    mysql_close($link);
?>