使用php数组的mysql select语句

Question

Suppose I have an array as following

$sql_column_headings = array("Week Period", "Comments Approved", "Comment Replies");

Number of items in the array is not fixed as they are selected from a 'select multiple lists'.

The list may consist more than 3 items and any number of items may be selected. Then submit button is pressed. How can I create a select statement where the column headings are taken from the array mentioned above. Thanks.

Answer 1

$sql_column_headings = array("Week Period", "Comments Approved", "Comment Replies");
 
    $columns = implode(",",$sql_column_headings);
 
    $sql = "SELECT '$columns' FROM table_name";
 
$result = mysql_query($sql);