mysql query

[piyush23424]

Hi,

 

i am using the following query to fetch records from the database

$q="select * from the list where address='%$searchString'";

 

The above query is fetching the matching results.

Now what i want is it should also fetch the other records having same city id as that of the resultant row.

city_id is a other column in the list table.

 

Thanks

[sader]

$q="select * from the list where address='%$searchString' and city_id=$citi_id";

[piyush23424]

$q="select * from the list where address='%$searchString' and city_id=$citi_id";

 

Thanks for replying but you are taking my question in wrong way.

 

what i need is first it will find the result with address and then it will check the cityid of the resultant row. after that it will fetch all other records from list table having same cityid as that of resultant row's city id.

i know it can be done with nested select query but i don't know how to write that. ?

 

[mapleleaf]

Sounds like you need a subquery

Select * from the list WHERE city_id = '(select city_id from the list where address='%$searchString')' ;

 

My syntax is almost certainly wrong but you get the idea and can probably look up subqueries somewhere.