This topic is locked

WHERE EXPRESSION

5/5/2009 8:17:14 AM
PHPRunner General questions
F
futo author

Hello,
I need to exclude somme values from results.
here is custom code:
//selected companies (Tvrtka)

global $conn,$smarty;

$rowsearch=array();

$rstt = db_query("SELECT clanovi.Tvrtka, Count(clanovi.Tvrtka) AS CountOfTvrtka FROM clanovi WHERE Tvrtka NOT LIKE "UMRLI" AND NOT LIKE UMIROVLJENIK GROUP BY clanovi.Tvrtka", $conn);

$ind=0;

while($data=db_fetch_array($rstt))

{

$rows=array();

$TvrtkaName = str_Replace(" ","+",$data["Tvrtka"]);

$rows["href"]="clanovi_list.php?a=search&value=1&SearchFor=".$TvrtkaName."&SearchOption=Contains&SearchField=Tvrtka";

$rows["1Tvrtka_value"]=$data["Tvrtka"]." (".$data["CountOfTvrtka"].")
";

$rowsearch="<a href=\"".$rows["href"]."\">".$rows["1Tvrtka_value"]."</a>";

echo $rowsearch;

}
table name = clanovi

table field = Tvrtka

Can someone tell me what's wrong???
THANKS
PHPRunner 5.1 beta (build 1844)

J
Jane 5/5/2009

Please see my changes below:

$rstt = db_query("SELECT clanovi.Tvrtka, Count(clanovi.Tvrtka) AS CountOfTvrtka FROM clanovi WHERE Tvrtka NOT LIKE 'UMRLI' AND NOT LIKE 'UMIROVLJENIK' GROUP BY clanovi.Tvrtka", $conn);

F
futo author 5/5/2009

THANKS JANE

ILL TRY THIS

Please see my changes below:


F
futo author 5/5/2009

not good,
i have error like this

J
Jane 5/6/2009

Sorry for my fault.

Here is the correct code:

$rstt = db_query("SELECT clanovi.Tvrtka, Count(clanovi.Tvrtka) AS CountOfTvrtka FROM clanovi WHERE Tvrtka NOT LIKE 'UMRLI' AND Tvrtka NOT LIKE 'UMIROVLJENIK' GROUP BY clanovi.Tvrtka", $conn);