MayncUsandy
New Member
i want to make my table can filtering in each column. i get client side script from DataTable.net. To make this work, i must make change at server side script for this datatable. My table fields is: Line, Model_name, Version, Lot, Serial_number, ID_number, Lot_no_S_Serial, and Prod_date.i have tried to syncronizing each column to this server script, but i always get an error.this the following script:\[code\]sSearch:bEscapeRegex:truesSearch_0:bEscapeRegex_0:truebSearchable_0:truesSearch_1:bEscapeRegex_1:truebSearchable_1:truesSearch_2:bEscapeRegex_2:truebSearchable_2:true //data array same until sSearch_7\[/code\]EDITand this the query:\[code\]$sWhere = "";if (postVar('sSearch') !="" ){ $sWhere = " WHERE Line LIKE '%".mysql_real_escape_string( $_POST['sSearch'] )."%' ";}if (postVar('sSearch_0') !=""){ $sWhere = " AND Line LIKE '".mysql_real_escape_string( $_POST['sSearch_0'])."' ";}if (postVar('sSearch_1') !="") { $sWhere = " AND Model_name LIKE '%".mysql_real_escape_string( $_POST['sSearch_1'])."%' ";\[/code\]//until sSearch_7i'm getting error at this query:\[quote\] error: "Error occuered during query execution: (): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND Line LIKE '2' ORDER BY Model_name desc LIMIT 0, 10' at line 1";\[/quote\]