Hi All, I am pretty much a newbie when it comes to php and mysql. I am having trouble doing a job for work where I have multiple drop down boxes attached to a mysql database, each linked to a separate table. I want to select an option from each dropdown and generate a query which will search another table that all the dropdown tables are linked to and give me the data selected and print to a new page. I have the dropdowns working I am just not sure how to do the query to incorporate the user selected options and print it to a new page, any help would be much appreciated, this is the gist of what I have so far.... // set up form for selecting required soil type print "<form>"; print "<center>"; print "<table height=20 cellSpacing='0' cellPadding='5' border='2' width='30%' bgColor='#DFF7FF' >"; print "<tr>"; print " <td width='30%'> <font face='Arial' size='2'>Pool Type:</font></td>"; print " <td width='*'>"; print " <select NAME='soil Type' ID='soilType' onChange='displayProcedure(this.form)'> '\n"; print " <option value='nil'> Choose a soil Type .... \n"; // connect and execute query $query = "SELECT soilType FROM soilType ORDER BY soilType "; $resulta = mysql_query($query, $dbcnx) or die ("Database query error: " . mysql_error()); while ( $a_row = mysql_fetch_object($resulta) ) { print "<option value='$a_row->soilType'> $a_row->soilType \n"; }; print "</select>"; print "</tr>"; print "</table>"; print "</form>"; this gives me my dropdown selection of soil type, I also have location and area, this info is linked to tblgrower which is the table I want to query. please help I have been fiddling with this for ages and can not get it, especially sending the result to a new page