missing ) after arguments

[grasperstail]

switch($which_logic) {case "radio":if ($radio_value == "project"){$query_string = "SELECT * FROM source WHERE description LIKE \"%$keyword_str%\"";}else{$query_string = "SELECT * FROM source WHERE " . $radio_value . "=" . $keyword_str;}var_dump($query_string);echo "<br/>";break;case "link":$query_string = $link_sql_string;var_dump($query_string);echo "<br/>";break;default://Build query with all words in the keyword search value wrapped in % wildcard signs//$query_string = "SELECT * FROM source WHERE description LIKE '%";foreach($trimmed_array as $append_value){$query_string .= "$append_value%";}$query_string .= "'";var_dump($query_string);echo "<br/>";break;}echo "<td><a class='link' href='#' id='page_next' 		onclick= \"page_setter($next,$query_string)\">>NEXT</a></td>";

keep getting an error "missing ) after arguments" in javascript after building the string in PHP. Can't figure out why.thanks

[justsomeguy]

There's probably an unclosed quote in one of the arguments. You probably want to quote both of those arguments in the first place. View the HTML source to see what the Javascript code looks like after it's generated.Also, for the sake of security, it's a terrible idea to send raw SQL queries using something like a form or Javascript, it's too easy for someone to hack the database.

[grasperstail]

any suggestions on where I can find a better way?BTW, the HTML on the javascript looked legit to me. exampleonclick="page_setter(2,SELECT * FROM source WHERE description LIKE '%msri%')">2</a></td><td><a class='link' href='#' id='page_link'

[Ingolme]

You have a string that's not enclosed within quotes.page_setter(2,SELECT * FROM source WHERE description LIKE '%msri%')To fix it do this:echo "<td><a class='link' href='#' id='page_next'onclick= \"page_setter($next,\\\"$query_string\\\")\">>NEXT</a></td>";