使用php数组的mysql select语句

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.

$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);

Try this,

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

    $itemStr = implode(",",$sql_column_headings);

    $qry = "SELECT * FROM table_name WHERE field_name IN('$itemStr')";

    $resSet = mysql_query($qry);

Check this, https://www.w3schools.com/php/func_string_implode.asp