} $html .= '<td><label><input type="checkbox" value="' . $row1['sys_id'] . '"/> ' . $row1['description'] . '</label></td>'; $j++; if ($j === 3) { $html .= '</tr>'; $j = 0; } } if ($blank_cell < 3) { for ($i = 1; $i <= $blank_cell; $i++) { $html .= '<td> </td>'; } $html .= '</tr>'; } } MainConfig::closeDB(); echo $html; // } else { if ($_POST['table'] == 'tbl_web_homepg') { $query = "SELECT\r\n web_homepg.wh_id,\r\n web_homepg.wh_image,\r\n web_homepg.wh_head1\r\n FROM\r\n web_homepg WHERE\r\n web_homepg.wh_section = '{$_POST['section']}'"; $system->prepareSelectQueryForJSON($query); } else { if ($_POST['table'] == 'vehicle_spec_table') { $query = "SELECT\r\n vh_tech_spec.spec_title,\r\n vh_tech_spec.spec_id,\r\n vh_tech_spec.eng_cc,\r\n vh_tech_spec.eng_rpm,\r\n vh_tech_spec.perf_max_speed,\r\n vh_tech_spec.trans_type,\r\n vh_tech_spec.fuel_cons_highway,\r\n vh_tech_spec.bd_curb_weight,\r\n vh_tech_spec.cap_fuel_tank\r\n FROM\r\n vh_tech_spec\r\n WHERE\r\n vh_tech_spec.mod_id = '{$_POST['model_id']}'"; $system->prepareSelectQueryForJSON($query); } else { if ($_POST['table'] == 'sendWeb_selectedVh') { $query = "SELECT\r\n vehicle.vh_code,\r\n maker_model.mod_name,\r\n vehicle.package,\r\n vehicle.vh_year,\r\n vehicle.vh_color,\r\n vehicle.vh_id,\r\n maker_model.mod_id\r\n FROM\r\n vehicle\r\n INNER JOIN maker_model ON vehicle.vh_maker_model = maker_model.mod_id\r\n WHERE\r\n vehicle.vh_id IN ({$_POST['idlist']})"; $system->prepareSelectQueryForJSON($query); } else {
function getCountByQuery($query) { $count = 0; MainConfig::connectDB(); $queryResult = mysql_query($query); $count = mysql_num_rows($queryResult); MainConfig::closeDB(); return $count; }