gambio_xtc_converter

gambio_xtc_converter.php

<?php
// Gambio to XTC image converter - PHP pseudocode - not tested
// Gambio product table
$sql = "SELECT id, products_name FROM gambio.products_description"
$rows = mysql_fetch_assoc(mysql_query($sql))
foreach ($rows as $row) {
  // match string, e.g "printer (white)"
  if (preg_match("/^(.*)\((.*)\)(.*)$", $row['products_name'], $arrMatches)) {
    $color = $arrMatches[2]; // third element contains color
    // do something with color, e.g
  }
}
?>