How to handle "Select ...INTO..."?

[Anon]

I search phpbuilder database and found following codes to select unique field and then insert into other table written by Scott.

select distinct field1, field2, field3 into some_table from some_other_table;

But How we can select fields, then directly insert into some_table?

Appreciate your help.

[Anon]

$sql = "select field name from table";
$sql_result = mysql_query($sql);
$sql_row = mysql_fetch_array($sql_result);

$sql_insert = "insert into table ... here is the insert command";
$sql_insert_result = mysql_query($sql);

hope it help you🙂