[SOLVED] if statement help please

[netpants]

I need to know how to write an if statement. For example I have a form dropdown called Cook, and Kendall, if someone selects Cook it will look in a certain table in the database, or if someone chooses Kendall it will look in a different table. Heres what I have currently it only works from one table.

 

$result = mysql_query("SELECT * FROM coords WHERE city='$city' AND county='$county' AND street='$street'")

 

What do I need to put in there for the if statement to say if $county == Cook then search in a different table that I will create. I will eventually have 7 different counties I will need to put if statements for.

[fenway]

You can't use expression to determine which table to query... you'll have to do that in the application code.

[netpants]

so the easiest thing to do would be to create a different form for eatch of the counties?

[fenway]

No, the easiest thing would be to have a single table for all counties with a county_id field.

 

What I was talking about was having a switch or if/else blocks to specify a PHP variable with the table.

[netpants]

There are eventually going to be over 91,000 entries into the database, so I thought by dividing it up into different tables it would make it a little faster when someone searches the database.

 

Eatch of the counties has its own field, there is a field called county in my table.

[fenway]

There are eventually going to be over 91,000 entries into the database, so I thought by dividing it up into different tables it would make it a little faster when someone searches the database.

 

Eatch of the counties has its own field, there is a field called county in my table.

91K isn't enough to make it worthwhile.

[netpants]

Great, thanks then I think what I have already will work just fine then.