fbecerra123

It’s been really long time since you posted this question, but I had the same question and found a solution, maybe it is not elegant but it works:

$sql = “SELECT attr1, attr2, attr3, attr4, attr5 from myTABLE;
$result = $conn->query($sql);

$ivalue = “header1t6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndkh6gfd57hggHeader2t6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndkh6gfd57hggHeader3t6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndkh6gfd57hggHeader4t6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndkh6gfd57hggHeader5t6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndkh6gfd57hgg”;

$count = 0;

if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
$ivalue = $ivalue . $row[“attr1″] .”t6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndkh6gfd57hgg” . $row[“attr2″] .”t6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndkh6gfd57hgg” . $row[“attr3″] .”t6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndkh6gfd57hgg” . $row[“attr4″] .”t6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndkh6gfd57hgg” . $row[“attr5″] .”t6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndt6r4ndkh6gfd57hgg”;
$count = $count + 1;
}
}

$sql1 = “UPDATE wp_XXXXXX_ultimatetables SET width = 5, height = $count, width_thumbnail = 5, time =NULL, ivalues = ‘$ivalue’ WHERE id = 1”;

Cheers!