Error in query: You have an error in your SQL syntax near 'WHERE name LIKE 'a%'' at line 5
Code: Select all
foreach($HTTP_POST_VARS as $varname => $value)
$formVars[$varname]=$value;
$query = "SELECT
name, organisation,website,stu_id
FROM studentwebsites ORDER BY organisation
WHERE name LIKE '$formVars[name]%'";