Warning: sqlite_query() expects parameter 1 to be resource, string given

Question

ok so i've looked all over the place and cant find a solution that helps my case. I hope someone can help?

basically i have this, and recieve "Warning: sqlite_query() expects parameter 1 to be resource, string given" relating to $dbresult line - so a problem with the query :(

function Up(){ 
$dbquery = "DELETE FROM toolList WHERE toolId='".$data['toolId']."'";  
$dbresult = sqlite_query($dbhandle, $dbquery);  
}

foreach($result as $data){ 
 print '< a href="'.Up().'">DELETE!< /a>';  
}

Any advice would be really appreciated :)

Thanks

Answer 1

Where is $dbhandle defined? I'm guessing it's a global variable, in which case you have to explicitly mention so within the Up function:

function Up(){ 
  global $dbhandle, $data, $dbresult;
  $dbquery = "DELETE FROM toolList WHERE toolId='".$data['toolId']."'";  
  $dbresult = sqlite_query($dbhandle, $dbquery);  
}

Answer 2

You are either missing a call to sqlite_open(), or your $dbhandle variable is not available in your function.