* @copyright 2007-2012 PrestaShop SA * @version Release: $Revision: 14007 $ * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) * International Registered Trademark & Property of PrestaShop SA */ include(dirname(__FILE__).'/config/config.inc.php'); include(dirname(__FILE__).'/header.php'); if ($id_dotaz = (int)Tools::getValue('id_dotaz')) { $result = Db::getInstance(_PS_USE_SQL_SLAVE_)->ExecuteS(' SELECT dotaz.id_customer_message as dotaz_id, odpoved.id_customer_message as odpoved_id, employee.firstname as jmeno, employee.lastname as prijmeni, employee.id_employee as zam_id, dotaz.message as dotaz, odpoved.message as odpoved FROM `ps_customer_message` as dotaz left join `ps_customer_message` as odpoved on ( dotaz.id_customer_thread=odpoved.id_customer_thread and odpoved.id_customer_message>dotaz.id_customer_message) left join `ps_employee` as employee on (odpoved.id_employee=employee.id_employee) where dotaz.id_employee=0 and odpoved.id_customer_message is not null and dotaz.id_customer_message='.$id_dotaz.' group by dotaz.id_customer_message'); echo '

Dermatologická poradna

Dotaz:	'.html_entity_decode($result[0]["dotaz"]).'
'.html_entity_decode($result[0]["jmeno"]).' '.html_entity_decode($result[0]["prijmeni"]); echo ' '; echo '	'.str_replace(array('<br/>','<br />'),array(' ',' '),$result[0][odpoved]).'

'; echo 'Zpět

'; echo '

'; /* echo '

';
print_r($result);
echo '

'; */ } else { echo "Tento dotaz neexistuje."; } include(dirname(__FILE__).'/footer.php');