[PHP] php and tables

[b]

i have created a program that allows users to make custom sql queries to
a mysql db and display the output to the browser.
the program works as desired but what i would like to do is display the
data in a table.
as there can be up to 4 columns with up to 13 different titles, i cannot
hard code this info in.
i would like to have the title used in the query to the be the title of
the table with the relevant data
below in an easily read format.

here is a sample of my code can any one help???

function db_search(){
global
$search,$search0,$search1,$search2,$search3,$where,$boulean,$variable;

// from the subnet and the host make the ip address
$ip_addr = $ip . $address;

// check to see if the variable is empty and discard other wise add the
contents to $field

if(!empty($search)) {
$field .= "$search, "; }
if(!empty($search0)) {
$field .= "$search0, "; }
if(!empty($search1)) {
$field .= "$search1, "; }
if(!empty($search2)) {
$field .= "$search2, "; }

if(!empty($where)) {
$field1 .= "$where "; }
if(!empty($search3)) {
$field1 .= "$search3 "; }
if(!empty($boulean)) {
$field1 .= "$boulean "; }
if(!empty($variable)) {
$field1 .= "'$variable' "; }

//strip the last character off of $field

$field = substr($field,0,strlen($field)-2);
//$field1 = substr($field1,0,strlen($field1)-2);

// prepare the query
$sql = "select $field from machine $field1 ";
print $field;

// action the query
$result = mysql_query($sql)
        or die ("Cannot do query, query = $sql");

// Printing results in HTML
           print "<table>\n";
                while ($line = mysql_fetch_array($result, MYSQL_ASSOC))
{
                print "\t<tr>\n";
                   foreach ($line as $col_value) {
                   print "\t\t<td>$col_value</td>\n";
                }
               print "\t</tr>\n";
           }
           print "<hr width='100%'>";
           print "</table>\n";

                print "<hr width='100%'>";

echo "\n\n<center>Your Job has Completed</center>\n\n\n<a
href=\"javascript:history.back();\">\n\n<center>Back</center></a>";
}




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]