[SOLVED] just a quick question

[HAVOCWIZARD]

guys, after you have the result from the query how can you filter out on the specific result, let say i have all the peoples telephone number, how can i filter out now those that only live in my area ?

[willpower]

this is done in your select statement

 

ie SELECT * FROM 'telephone_dir' WHERE 'area'='myarea'

 

you will need to be more specific about your table and fields before we can give a precise answer

[HAVOCWIZARD]

okey i understand that, i have the select all, but now i get all the info in that area, okey now i have my result off let say "bevery hills" now in that result i want to find all the numbers of ending with 5432, can i run a query on a query ?.

[aniesh82]

Please go through the entire records and check using an if

Example:

$result=mysql_query("your query");

while($data=mysql_fetch_array($result))

{

  if($data['arae'] == "YourArea")

        $array[] = $data['telephoneNumber'] ;

}

 

print_r($array) has the list telephone number in your area.

 

I think it is better to change the select query to select  the telephone number in your area.

Example:

SELECT * FROM table WHERE area="YourArea"

 

 

[HAVOCWIZARD]

thanks will try that...

[aniesh82]

 

Change your query like this :

 

SELECT * FROM table WHERE area="YourArea"  AND telephoneNumber LIKE '%5432'