[SOLVED] Create MYSQL query from array

[lindm]

I have got the following code working that creates an array in $col of all columns beginning with cx in my table:

 

$qColumnNames = mysql_query("SHOW COLUMNS FROM table LIKE 'cx%'") or die("mysql error");
$numColumns = mysql_num_rows($qColumnNames);
$x = 0;
while ($x < $numColumns)
{
    $colname = mysql_fetch_row($qColumnNames);
    $col[$colname[0]] = $colname[0];
    $x++;
}

 

Now I want to create the following mysql query including all columns from the array:

 

mysql_query(
"UPDATE table SET

cx1	 = '',
cx2	 = '',
cx3	 = '',
cx4	 = '',
cx5	 = '',
etc
etc

");

 

Need help finishing the code.

 

Many thanks

 

 

 

[.josh]

$qColumnNames = mysql_query("SHOW COLUMNS FROM table LIKE 'cx%'") or die("mysql error");
$numColumns = mysql_num_rows($qColumnNames);
$x = 0;
while ($x < $numColumns)
{
    $colname = mysql_fetch_row($qColumnNames);
    $col .= $colname[$x] . ",";
    $x++;
}
$col = rtrim($col,',');

[lindm]

Solved it now

 

$qColumnNames = mysql_query("SHOW COLUMNS FROM table LIKE 'cx%'") or die("mysql error");
$numColumns = mysql_num_rows($qColumnNames);
$x = 0;
while ($x < $numColumns)
{
    $colname = mysql_fetch_row($qColumnNames);
    $col[$colname[0]] = $colname[0];
    $x++;
}
$querycx = 'UPDATE `table` SET '. implode( '=\'\', ', $col ) .'=\'\' WHERE `userName` = \''. $user2 .'\'';
mysql_query($querycx);