Fetch columns of the mysql database table into a selectbox

[heartsblack]

I want fetch columns of the mysql database table into a selectbox and then transfer the columns into another table which is in another select box.

[Barand]

So what? I want to win the lottery.

 

Why don't you stop posting your "wish list" and try asking a question, preferably with some detail and current code.

 

You have a very similar post here http://forums.phpfreaks.com/topic/298261-transfer-data-from-one-select-box-to-another/

[heartsblack]

How to I display the columns of the table in a database into a select box? I don't have any code

[Barand]

try

$sql = "SHOW COLUMNS FROM tablename";
$res = $mysqli->query($sql);

echo "<select name='column_names'>";

while ($row = $res->fetch_row()) {
    echo "<option>{$row[0]}</option>";
}

echo "</select>\n";

[benanamen]

The jist of your request doesn't make much sense.  What are you trying to accomplish overall?