You have already pulled the data into an associative array with the column name as the array key. Use array_keys() to spit out the column names at the top of your table.
Fred B <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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' "; } > > file://strip the last character off of $field > > $field = substr($field,0,strlen($field)-2); > file://$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]
