Re: Sql/PHP question

I had the values set for $department and $location set with the quotes. I removed that after my posting realizing the mess I was creating. This could get pretty complex. I just noticed that what happens if all is selected for both departments and locations. then you can't have where in the query, also the and will give me a fit too if I only select one. I can do it, it will just take some planning, and I will have to be careful if I add any more selections. Mike On Wednesday, April 16, 2003, at 01:21 PM, CPT John W. Holmes wrote:

I am creating a page that will generate a report. On the first page I have drop down menus that you can select what you want in the report. The table, department, and location. So in the query, I have this: $query = "select * from $database_table where department = $department and location = $location"; Now this works fine if in the department menu I select a department, and in the location menu I select a location, but I also want to be able to show all. For instance I want to create a report on all items for a single department in all locations. Is there such a thing as a wildcard within a where statement? location = * doesn't work of course, but what else could I use.

Remember, queries are just strings. Create the right string to suit your needs. If $location is set, then add it to your where clause, if $department is set, add it, too. if(isset($location)) { $where[] = " location = $location "; } if(isset($department)) { $where[] = " department = $department "; } $query = "select * from $database_table where " . implode(' and ', $where); You may want to use empty() instead of isset(), or check for a certain value, that's up to you. Are you sure you don't need quotes around $department and $location in your query? Are those integer or string columns? ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php