ashokk
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
2 Answer(s)      5 years and 11 months ago
Posted in : PHP

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,

Ads

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'";










Related Tutorials/Questions & Answers:
any body have any solutions?
any body have any solutions?  Hi Friends, I just get down my computer, I am working on it, but suddenly get down and can√Ę‚?¨‚?Ęt get start again. If any body have any solutions
please any one can help me to write a code for this question?
please any one can help me to write a code for this question?  1) Copy one file content to other? 2) Count the number of words in a file
Advertisements
please any one can help me to write a code for this question?
please any one can help me to write a code for this question?  Q 1) In a class first day 25 students are joined. After two days that total students will increased to 60. We can develop a program by using ArrayList concept
please help me
please help me  Dear sir, I have a problem. How to write JSP coding, if a user select a value from drop down list for example department, the another... before. This name list should get from the database. Please help me. By the way, I'm
Please help me to modify my java code from php code
]; } } I tried like this (see below JSP code) ... but this is not giving me the exact result as the above PHP code is giving. So please help me to convert...Modify Java code from PHP Code  i want to covert this php code int
Can any one please help me in this ,,,,,,, need java code for this ,,,,please anyone
Can any one please help me in this ,,,,,,, need java code for this ,,,,please anyone  The Airport Valet Parking Company (AVP) is a company which provides a convenient medium cost parking solution to users of a local airport. Key
urgent...pleAse help me.....please!
urgent...pleAse help me.....please!  please help me urgent! how can i do dictionary with the use of array code in java, where i will type the word then the corresponding meaning for that word will appear...thanks
please help me.
please help me.  Please send me a code of template in opencms and its procedure.so i can implement the code. Thanks trinath
Please help me to modify my java code from php code
Please help me to modify my java code from php code  i want to covert...) ... but this is not giving me the exact result as the above PHP code is giving. So please... same, as they alter it before. Please help me on this topic "how to order rows
please help me to this problem..
please help me to this problem..  i wrote a program like keyboard... inside the JTextField) but i want to make this program to let me write where i clicked (i.e allows me to write any thing at the field where i clicked
please help me.
please help me.  I have a jsp page under that i add a list box under i get the countries through my database. so how can i do
please help me.
please help me.  How to read a properties file in java with a suitable example. Please send me. Thanks Trinath   Please visit the following link: Java read properties file
please help me.
please help me.  I have three table in mysql,and i hava create a excel sheet and add this sheet.but my question is in every sheet i can display one one table result.how can i do
help me please
help me please   Hello I want helping for this question , Please Write a program that reads some friends√Ę‚?¨‚?Ę names, stores them in an array, and then prints out on the screen all friends who start by a particular letter
please help me.
please help me.  Please send me the validation of this below link. the link is http://www.roseindia.net/answers/viewqa/JSP-Servlet/9584-JSP-Servlet-Search-and-Edit.html Thanks Trinath
Please help me.
Please help me.  Hi i am trinath in below there is a url.In that url there is a code of edit a jsp page.I understand that code but only one thing i not get it i.e; What is the work of "id".and what is the data type of id? http
please help me.
please help me.  How to move the edits.jsp in below link? http://www.roseindia.net/answers/viewqa/JSP-Servlet/9584-JSP-Servlet-Search-and-Edit.html
inheritance....please help me friends...!!!... this is important project that i have to do it..
inheritance....please help me friends...!!!... this is important project that i have to do it..   Point ................. #x : int #y : int + Point() + Point(xCoordinate:int, YCoordinate:int) + getX() : int + getY() : int
please help me...
please help me...  write an application that print number in the following order using a FOR-Loop 1 2 3 4 5 2 4 6 8 10 3 6 9 1215 4 8 121620 5 10152025
please help me in these prog
please help me in these prog   create 2 jdbc programs including awt create 2 jdbc programs including swing create 2 jdbc programs including command line argument create 2 jdbc programs including io class 4 jdbc prog using
Please help me urgent...........
Please help me urgent...........  For what kind of a problem would... of values in an ascending order, then you have to use Tree Set. Tree Set contains... value, then you have to use Tree Map. The Tree Map contains the data in a key-value
Please help me out
Please help me out    Description* You are hired to develop a laptop inventory information system for Sheridan College in order to keep track... should also be specified. However if user does not provide any data for year, set
help me please
help me please  how can i do dictionary with the use of array code in java, where i will type the word then the corresponding meaning for that word will appear...thanks
Please help me
Please help me  Hi Sir, please send me the code for the following progrems... 1) all sets are integer type: input: set1={10,20,30,40...(" "); for(int i=str.length-1;i>=0;i--){ buffer.append(str[i
Please help me??
Please help me??  Question_1: Using one-dimension array of primitive... to have 8 elements as follows:2, 3, 5, 7, 11, 13, 17, and 19 4. Display... element in array2 in index 0,2,4 and 6 to have new values such as 0,2,4 and 6
Please help me
Please help me  program for when a user enter his card number, it has to create default security pin in the database
please help me here
please help me here  please show me how can this show the right output that i need please continue doing this program using only if else and do while...] Deposit [W] Withdrawal [Q] Quit select you OPtions: once i have chosen an option
please help me here
please help me here  please show me how can this show the right output that i need please continue doing this program using only if else and do while...] Deposit [W] Withdrawal [Q] Quit select you OPtions: once i have chosen an option
PLZ HELP ME. i need php code.
PLZ HELP ME. i need php code.   I want php code for bellow OUTPUT. output is just example but it must be letters only. abc bcd efg jku rgt azs hje qqc wws adt
please help me
please help me  interface Test1 { String toString(); } public class Test { public static void main(String[] args) { System.out.println(new Test1() { public String toString() { return "test
please help me?
please help me?  Define a class named Circle with the following properties: List item An integer data field named radius with protected access modifier, and a String data field named colour with private access modifier. Both

Ads

Advertisement