Re: Dynamic querys to SQl Server

If I understand you correctly, then you could try something like this: =======Page 1: Select info to view... <input type="checkbox" name="columns[]" value="Name"> Name<br> <input type="checkbox" name="columns[]" value="Email"> Email<br> <input type="checkbox" name="columns[]" value="City"> City =======Page 2: $query = 'SELECT '; $first = true; foreach ($columns AS $value) { if (!$first) {

    $query .= ', ';

} else {

    $first = false;

} $query .= $value; } $query .= 'FROM MyTable '; $query .= 'ORDER BY Name'; $result = mysql_query($query); echo '<table>'; while ($row = mysql_fetch_row($result)) { echo '<tr>'; foreach ($row AS $value) {

    echo "<td>$value</td>";

} echo '</tr>'; } echo '</table>'; Obviously this is a pretty rough outline, but it gives you a basic idea of the way you could do this. You can add bells & whistles and make it look nicer, add error checking, stuff like that. -Mike At 09:41 AM 4/11/2002 -0500, R.S. Herhuth wrote:

I'm new to php and I'm trying hard to get a grasp on pulling data from SQL Server. I'm looking for an efficient method for making dynamic queries to SQL server. Basically what I have created so far is a page that dynamically builds all of the column names of a database. I have assigned each a unique variable name. When the user selects the check box next to the name and submits the form, I am using the HTTP_POST_VARS() to explode out the variables on the following page. What I need to do though is create a way to dynamically query the DB only returning the selected columns. What is an efficient way of doing this? Does anyone know of any tutorials or examples that can get me close? Ron -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Mike Flynn - Burlington, VT http://www.mikeflynn.net/ - mike@mikeflynn.net home=>work=>home=>store=>home [repeat daily]