trying to search to items in the same record

[gatorwire]

here is my problem.....

I have a field saying the communities.

Most builders have the same model homes in multiple communities.

What do I put in mysql to make it search one community of the many.

right now I have Ancient Oaks, Foxbrook....

but it doesn't work. what do I need to do to separate them and be able to be searched?

[eon_sol]

not entirely sure what you're asking, but it just sounds like you need to use a WHERE clause.

IE:

$query = "Select * FROM Homes WHERE Community=\"FoxBrook\" AND Model=\"Chateu\";";