Multiple Queries

cap97

Up until now I've only queries based on a single request. (i.e. SELECT * FROM links where Type = $Type). But what if I had more than one $Type? For instance, I have a links table set up that groups links into different types. So what I'd like is for the user to be able to "check" which types they want to see and then list the links defined by that type. Manually I know how to do this:

SELECT * FROM links WHERE Type = a AND Type = b, etc.

But how do I get PHP to automate this to know which types the user has picked and than run a query accordingly?

Pig

I'm not sure I understand. Do you mean, if they choose A, B, and C that you want all of the results that match any of those?

If so, check out IN.
$result = mysql_query("SELECT * FROM table_name WHERE col_name IN ('a', 'b', 'c')");

cap97

Okay but how do I communicate to the query string that A, B, and C were chosen by the user?

Pig

If you use checkboxes, you can create an array. Name all of the boxes the same thing. eg: name[]

Then you can just implode() the array into a useful string, formatted like you saw.

superwormy

Or just concatanate variables... or loop through an array with for or foreach...

$query = "SELECT * FROM table WHERE ID = " . $POST['var1'] . " OR ID = " . $POST['var2'] . " ";

Pig

be careful if you go wormy's route. Build the string for your query first, so you can use if() statements to check your variables first.. If you end up with an empty variable, you will destroy your query.