adam1972

The posting was enough of a pointer that I got EXACTLY what I needed. Again... Thank You.

jlhaslip, Thank you so much!!! I have been looking for weeks with very little luck and lots of confusion! It worked like a charm!! Thank you as well for taking the time and making up that page as an example!!!

Thanks for the help jbwebdesign, I tried that route, I found that I actually need an array since I want to use the reults as avariable with the "SELECT" command in a query. I started a new a new thread to help me with converting the array into a string without the extra trailing comma I keep getting (removing the last character deletes ALL commas). If you have any ideas on a different dirction other than this I would sincerely and greatly appreciate the help

Here's the page: > </pre> <table width="99%" border="0" align="center">Search:Column to Search: ForeclosureType RadarID APN County Address City State Zip Owner OwnerFirstName OwnerLastName OwnerSpouseFirstName Owner2 OwnerAddress OwnerCity OwnerState OwnerZip OwnerPhone PropertyType SqFt YearBuilt Beds Baths LotSize EstimatedValue EstimatedTotalLoanBalance RecordingDate Trustee TrusteeSaleNum Sort by: ForeclosureType RadarID APN County Address City State Zip Owner OwnerFirstName OwnerLastName OwnerSpouseFirstName Owner2 OwnerAddress OwnerCity OwnerState OwnerZip OwnerPhone PropertyType SqFt YearBuilt Beds Baths LotSize EstimatedValue EstimatedTotalLoanBalance RecordingDate Trustee TrusteeSaleNum </table> <br><br><br><br><br><div align="left"> ForeclosureType RadarID APN County Address City State Zip Beds Baths SqFt LotSize Owner OwnerFirstName OwnerLastName OwnerSpouseFirstName Owner2 OwnerAddress OwnerCity OwnerState OwnerZip OwnerPhone PropertyType YearBuilt EstimatedValue EstimatedTotalLoanBalance RecordingDate Trustee TrusteeSaleNum TrusteePhone SaleDate SaleTime SalePlace PublishedBid OpeningBid WinningBid EstimatedLoanPosition LoanDate LoanDocNum LoanAmount loan1RecDate loan1DocNumber loan1LoanAmount loan2RecDate loan2DocNumber loan2LoanAmount loan3RecDate loan3DocNumber loan3LoanAmount </div> <br><br><br

I think I figured out how to convert an array into a string and use the string in a query... I have an array with over 40 options on a multi-select drop down list that I want to pass from a form using post to use in a query. When I do it I end up with too many commas and it fails. Here's what I've got.. <?php echo "You selected ".count($display)." for your search"; if (count($display)==1) { for($i=0;$i { $display3 = $display[$i].""; echo $display3; } } else { for($i=0;$i { $display2 = $display[$i].","; $display3 = substr($display2,0,-1); // I've even tried $display3=eregi_replace(',$', '', $display2); echo $display3; } } ?> These methods end up removing the commas across the whole string.. Not just the one at the end. What am I doing wrong?

I've mixed in some of Stefan's code to create a query: and then echoeing them into a table like Stefan suggested.... What I'm wanting to do is create a query where the user can dynamically select what columns from the query results will be displayed on a table (there are currently 49 colums of data and bound to increase). I've looked into changing the query into using a variable from a list instead of the "SELECT *" I'm currently using, but I don't know how to pass the data checked off on a multiple select list on the query form( via an array? using _post) to the search results page. I've also played with creating check boxes on the query form (for all 49 + columns) and then creating variables for each checkbox... and then trying to use if statements while creating a table to control which gets echoe'd to the screen.... I've run into a brick wall.. my head hurts..... Does anyone have any good suggestions???????? Please? What and how would be the easiest way to let the user control the columns that get placed onto the query results table instead of just spitting out every column?