hello,
i have problemwith where statements
// Put your code here.
global $conn,$smarty;
$rowsearch=array();
$rstt = db_query("SELECT jcd.Obveznik, Count(jcd.Obveznik) AS CountOfObveznik FROM jcd WHERE Postupak='Izvoz'
GROUP BY jcd.Obveznik", $conn);
$ind=0;
while($data=db_fetch_array($rstt))
{
$rows=array();
$ObveznikName = str_Replace(" ","+",$data["Obveznik"]);
$rows["href"]="jcd_list.php?a=search&value=1&SearchFor=".$ObveznikName."&SearchOption=Contains&SearchField=Obveznik";
$rows["1Obveznik_value"]=$data["Obveznik"]." (".$data["CountOfObveznik"].")
";
$rowsearch="<a href=\"".$rows["href"]."\">".$rows["1Obveznik_value"]."</a>";
echo $rowsearch;
}
-------------------------------------------------------------------------------------------------------------------
this code search and display records wich have value Izvoz and count them (for each company / column - Obveznik/). But showing me all of records for specific Company (records "Izvoz" and "Uvoz")
PHP RUNNER 4.2 368, MySQL - 5