$label = ""; $sql = "SELECT pn_tid as id, concat(pn_name, '" . $label . "' ) as label, concat('http://www.eyedock.com/index.php?option=com_pnlenses&lens_id=' , pn_tid ) as link\n FROM pn_lenses \n LEFT JOIN pn_lenses_companies ON pn_comp_tid = pn_comp_id\n WHERE\n {$where} \n ORDER BY pn_name"; //echo($sql); $mysqli = DBAccess::getConnection(); $result = $mysqli->selectQuery($sql); while ($row = $result->fetch_assoc()) { array_push($return, $row); } } // ----------------------------- for keratometry -------------------------------------- if (($k || $all) && !$hasSign) { if ($isNumber) { $kValObj = new KvalObject($q); if ($kValObj->isValidK()) { if ($kValObj->isMM()) { $kInfo['label'] = $kValObj->prettyStringMM() . "mm = " . $kValObj->prettyStringD() . "D"; } if ($kValObj->isD()) { $kInfo['label'] = $kValObj->prettyStringD() . "D = " . $kValObj->prettyStringMM() . "mm"; } $kInfo['type'] = "keratometry"; $kInfo['k'] = $q; array_push($return, $kInfo); } } $kObj = kStringBreaker($q); if ($kObj->isValidK()) { $kInfo['label'] = $kObj->prettyString() . ": get info"; $kInfo['type'] = "keratometry"; $kInfo['k'] = $kObj->prettyString(); array_push($return, $kInfo);