This topic is locked

events

7/30/2008 3:31:21 PM
PHPRunner General questions
F
futo author

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

J
Jane 7/31/2008

Hi,
you need to form advanced search link with two parameters: Postupak and Obveznik.

Check following thread:

http://www.asprunner.com/forums/index.php?showtopic=5705

F
futo author 7/31/2008

Hi,

you need to form advanced search link with two parameters: Postupak and Obveznik.

Check following thread:

http://www.asprunner.com/forums/index.php?showtopic=5705


Hi Jane,
I am not sure that I understand what you say.

I have advanced search page with those parameters: Postupak and Obveznik.

On the advanced search page I have replace the metod to "GET".
BUT DONT WORKS

J
Jane 7/31/2008

Hi,
then build the project and run advanced search. Copy and paste the URL into your code.

$rows["href"]="jcd_list.php?a=advsearch...