This topic is locked

CusotmQuery PHPRUNNER 8

9/18/2014 6:48:13 AM
PHPRunner General questions
P
prattster1874 author

Any idea why this isn't updating. Code is in Before Record Updated? I think it should be really simple, but can't work it out!
All I want to do is check if there is a value in the record being updated and if so, update another table??
The alert shows!

if($values['quoted_price_pw']<>""){
$sql = "UPDATE quote_request SET status_id='2' WHERE ID='".$values['quote_id']."'";

CustomQuery($sql);
echo "<script>alert('hello');</script>";
}
return true;
Sergey Kornilov admin 9/18/2014

Instead of executing query print it on the web page to see if SQL query is correct.
Besides that, make sure that you run the latest PHPRunner build (22724 at the moment).