Sql Table

NZ_Kiwis

I want a write a code which will list all the colums in my SQL table and it will put them in a HTML drop down menu...
How do I do this???

edcellgavin

try this and perhaps you can read on to show columns syntax and mysql_query function

 
<?php
	$db = mysql_connect("database_host", "user");
	mysql_select_db("Database_name");
	$result = mysql_query("SHOW COLUMNS FROM TableName");
	$cbo_field_names = "";
	while (list($field_name) = mysql_fetch_row($result)) {
		$cbo_field_names .= "<option>$field_name</option>";
	}
?>

just echo the $ret variable between select tags just like
<select><?=$cbo_field_names?></select>

NZ_Kiwis

Originally posted by edcellgavin
try this and perhaps you can read on to show columns syntax and mysql_query function
 
<?php
	$db = mysql_connect("database_host", "user");
	mysql_select_db("Database_name");
	$result = mysql_query("SHOW COLUMNS FROM TableName");
	$cbo_field_names = "";
	while (list($field_name) = mysql_fetch_row($result)) {
		$cbo_field_names .= "<option>$field_name</option>";
	}
?>
just echo the $ret variable between select tags just like
<select><?=$cbo_field_names?></select> [/B]

Thanks.... is there a way of doing a query for a coloum which has a value in it... for example im going to add lots of rows and most colums will have 0 but some will have a value such as 23 or 4323 or 66 basicly a nubmer greater the 0... how can a do a query for records with numbers greater than 0??
thanks

kender

<?php 
    $db = mysql_connect("database_host", "user"); 
    mysql_select_db("Database_name"); 
    $result = mysql_query("SHOW COLUMNS FROM TableName WHERE field != 0"); 
    $cbo_field_names = ""; 
    while (list($field_name) = mysql_fetch_row($result)) { 
        $cbo_field_names .= "<option>$field_name</option>"; 
    } 
?>