Dear Php Developers ( i have parameter passing issues is there nearly i was trying 15day onwords but still now that issues is not clear) any body please help me

Dear Koushik,

below url all features i was developing my site. just open that site.

http://bangalore.burrp.com/establishment/search.html?q=restaurants+bars+lounges&n=&s=OR&eQ=true#0

now issue is i want to retrieve values in specific locations wise (above url site open check out that page left side By localitys are that is all are belongs to bangalore local areas so here they are retrived each location message counting and when we will press specific location that time retrive only that releated area and categorys information) same feature i want to set it in my website .

i was taken two table one is addevent and fnbylocality

here 1. "addevent" table is

CREATE TABLE IF NOT EXISTS addevent ( ID int(12) NOT NULL auto_increment, register_id int(225) NOT NULL default '0', fnid int(225) NOT NULL default '0', title varchar(100) NOT NULL default '', venue varchar(225) NOT NULL default '', area varchar(100) NOT NULL default '0', address varchar(225) NOT NULL default '', book varchar(225) NOT NULL default '', book1 varchar(225) NOT NULL default '', arrive varchar(225) NOT NULL default '', depart varchar(225) NOT NULL default '', categery varchar(225) NOT NULL default '', message varchar(225) NOT NULL default '', logo varchar(225) NOT NULL default '', name varchar(225) NOT NULL default '', contact varchar(25) NOT NULL default '0', url varchar(225) NOT NULL default '', mail varchar(225) NOT NULL default '', date date NOT NULL default '0000-00-00', time time NOT NULL default '00:00:00', PRIMARY KEY (ID)

)

2." fnbylocality" table is

CREATE TABLE IF NOT EXISTS fnbylocality ( ID int(10) NOT NULL auto_increment, head varchar(255) NOT NULL default '', register_id int(225) NOT NULL default '0', PRIMARY KEY (ID) )

"fnbylocality" this table using retrive all bangalore city locations. So here this table id using ," addevent" table values i want get so that purpose i am using below php code.l

by Locality

include 'include/dbconnect.php';

$sql="SELECT * FROM fnbylocality ORDER BY head"; $rs = mysqlQuery($sql) or Die ('Error query product catergory' . mysqlerror()); while($row=mysqlfetcharray($rs)) { $Id=$row['ID'];
$cat=$row['head']; * $sql1="SELECT COUNT(ID) FROM addevent ID='$id'";

$rsss = mysqlQuery($sql1) or Die ('Error query product catergory' . mysqlerror());

if($rowc=mysqlfetcharray($rsss)) $area=$row['area']; $categery=$row['categery']; $tot0=$rowc['COUNT(ID)'];

?> ()

here abve query i was changed like this * $sql1="SELECT COUNT(ID) FROM addevent ";

that time location massages showing every area is same counting means this one is doesnt follow specific id.

this is my issues please 1 week onwords i am trying but i cont enable solve this issues .

example purpose i am using this site features http://bangalore.burrp.com/establishment/search.html?q=restaurants+bars+lounges&n=&s=OR&eQ=true#0

just check out this page leftside BY Localitys.(bangalore all areas)

Thanking you,

View Answers

December 16, 2010 at 2:16 PM

hello,

First, I want to know where u insert fnbylocality table ID field in addevent table??

Consider.. u have insert fnbylocality table ID field, into addevent table in the name of locality_id

then your second query will be ,

$sql1="SELECT COUNT(ID) FROM addevent where locality_id='$id'";

December 16, 2010 at 2:16 PM

hello,

First, I want to know where u insert fnbylocality table ID field in addevent table??

Consider.. u have insert fnbylocality table ID field, into addevent table in the name of locality_id

then your second query will be ,

$sql1="SELECT COUNT(ID) FROM addevent where locality_id='$id'";