Nikola, hvala ti puno na pomoci, razumevanju....
u potpunosti si shavito sta bi ja hteo, na istoj strani i podaci i filter i rezultat filtera
evo sad videh tvoj odgovor i omah ga proba
javlja gresku
Parse error: syntax error, unexpected T_STRING in D:\xampp\htdocs\tas\administracija\3.php on line 50
gde li sam sad pogresio
Code:
<?php require_once('../Connections/tas034.php'); ?>
<?php
mysql_select_db($database_tas034, $tas034);
$query_kuce = "SELECT id, indikacije, mesto, adresa, fiksni, mobilni, vrstanekretnine FROM stankuca WHERE vrstanekretnine = 'Kuća' AND (mesto LIKE '%$search_query%' OR adresa LIKE '%$search_query%') ORDER BY indikacije ASC";
$kuce = mysql_query($query_kuce, $tas034) or die(mysql_error());
$row_kuce = mysql_fetch_assoc($kuce);
$totalRows_kuce = mysql_num_rows($kuce);
mysql_select_db($database_tas034, $tas034);
$query_lokal = "SELECT id, indikacije, mesto, adresa, fiksni, mobilni, profesija, vrstanekretnine FROM lokal WHERE mesto LIKE '%$search_query%' OR adresa LIKE '%$search_query%' ORDER BY indikacije ASC";
$lokal = mysql_query($query_lokal, $tas034) or die(mysql_error());
$row_lokal = mysql_fetch_assoc($lokal);
$totalRows_lokal = mysql_num_rows($lokal);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1250" />
<title>Untitled Document</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<p>
<fieldset>
<form name = "pretraga" action = "<?php echo $_SERVER['PHP_SELF']; ?>" method = "POST">
<input type = "text" name = "searchInput" />
<input type = "submit" name = "performSearch" value = "Search" />
</form>
</fieldset>
</p>
</p>
<table width="800" border="0" cellspacing="2" cellpadding="2">
<tr>
<td>
<legend class="tahoma_zeleno_18">Kuće </legend>
<table width="800" border="0" align="left" id="sf">
<tr>
<td>Klijent</td>
<td>mesto, adresa</td>
<td>fiksni</td>
<td>mobilni</td>
<td>profesija</td>
<td>vrstanekretnine</td>
</tr>
<?php do {
if ($_POST['performSearch']) {
$search_query = trim($_POST['searchInput']);
}
else {
$query_kuce1 = "SELECT * FROM stankuca WHERE SELECT id, indikacije, mesto, adresa, fiksni, mobilni, vrstanekretnine FROM stankuca WHERE vrstanekretnine = 'Kuća' ORDER BY indikacije ASC";
$query_lokal1 = "SELECT id, indikacije, mesto, adresa, fiksni, mobilni, profesija, vrstanekretnine FROM lokal ORDER BY indikacije ASC";
}
?>
<tr>
<td><?php echo $row_kuce['indikacije']; ?></td>
<td><?php echo $row_kuce['mesto']; ?>, <?php echo $row_kuce['adresa']; ?></td>
<td><?php echo $row_kuce['fiksni']; ?></td>
<td><?php echo $row_kuce['mobilni']; ?></td>
<td><?php echo $row_kuce['profesija']; ?></td>
<td><a href="kuce_detaljno.php?id=<? echo $row_kuce['id']; ?>" target="_blank"><?php echo $row_kuce['vrstanekretnine']; ?></a></td>
</tr>
<?php } while ($row_kuce = mysql_fetch_assoc($kuce)); ?>
</table>
</fieldset>
</p>
<p>
</p>
</p>
<table width="800" border="0" id="sf">
<tr>
<td>indikacije</td>
<td>mestoadresa</td>
<td>fiksni</td>
<td>mobilni</td>
<td>profesija</td>
<td>vrstanekretnine</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_lokal['indikacije']; ?></td>
<td><?php echo $row_lokal['mesto']; ?><?php echo $row_lokal['adresa']; ?></td>
<td><?php echo $row_lokal['fiksni']; ?></td>
<td><?php echo $row_lokal['mobilni']; ?></td>
<td><?php echo $row_lokal['profesija']; ?></td>
<td><a href="lokal_detaljno.php?id=<? echo $row_lokal['id']; ?>" target="_blank"><?php echo $row_lokal['vrstanekretnine']; ?></a></td>
</tr>
<?php } while ($row_lokal = mysql_fetch_assoc($lokal)); ?>
</table></td>
</tr>
</table>
<p> </p>
</body>
</html>
<?php
mysql_free_result($kuce);
mysql_free_result($lokal);
?>
spantelic