get_results("
SELECT
*
FROM
$table1
WHERE
id = $inst
");
if (!empty($results)) {
foreach ($results as $row) {
$instname = $row->name;
$lat = $row->lat; // latitude
$lng = $row->lng; // longtitude
?>
name; ?>
Elérhetőségek
| Kerület: |
district_id; ?>. kerület |
| Cím: |
zipcode; ?> Budapest, address; ?> |
phone_01)) { ?>
| Telefon (2): |
phone_01; ?> |
phone_02)) { ?>
| Telefon (2): |
phone_02; ?> |
email)) { ?>
| E-mail: |
email, 0, 42, " ..."); ?> |
web) && $row->web != 'http://') { ?>
| Web: |
web, 0, 42, " ..."); ?> |
opening_time)) { ?>
| Nyitvatartás: |
opening_time; ?> |
query_vars['type'])) {
//$sMsdsCat = urldecode($wp_query->query_vars['type']);
//}
if (!isset($_GET['type'])) {
$typeid = 1;
} else {
$typeid = $_GET['type'];
}
if (!empty($_POST["kerulet"])) {
$postker = $_POST['kerulet'];
$results = $wpdb->get_results("
SELECT
*,
inst.*,
instype.`name` as tname,
inst.`name` as iname
FROM
institution AS inst
INNER JOIN
institution_type AS instype
ON
inst.type_id = instype.id
WHERE
inst.type_id = $typeid AND
district_id = $postker
");
} else {
$results = $wpdb->get_results("
SELECT
*,
inst.*,
instype.`name` as tname,
inst.`name` as iname
FROM
institution AS inst
INNER JOIN
institution_type AS instype
ON
inst.type_id = instype.id
WHERE
inst.type_id = $typeid
");
}
?>
query_var('inst'))) {echo 'YEPP';}
?>
tname; ?>
name;
$lat = $row->lat; // latitude
$lng = $row->lng; // longtitude
?>