2. PHPRunner General questions
  3. $data['startdate'] become ''
This topic is locked

$data['startdate'] become ''

 		10/12/2018 19:53:25
PHPRunner General questions
K
 KelvinChua author

Hi Gurus,
I have a simple query that crashed in PHPRunner 10. It have been working for the past versions.
$rs = CustomQuery("SELECT sum(totalamt) AS total_bfamt FROM clubbookdetails WHERE ispaid = 1 and datepaid < '".$data['startdate']."'");

$record = db_fetch_array($rs);

$value = "$".number_format($record['total_bfamt'],2);
The error:

ERROR: invalid input syntax for type date: "" LINE 1: ...famt FROM clubbookdetails WHERE ispaid = 1 and datepaid < '' ^
Any idea where is my mistake?
Thanks.
Kelvin Chua

SINGAPORE
Sergey Kornilov admin 10/12/2018

Hard to tell without seeing your project and data. I would suggest uploading your project to Demo Account and contacting support directly.
K
 		KelvinChua author 10/14/2018

Hi Admin,
How do I start a demoaccount?
Thanks.
Kelvin Chua

SINGAPORE
Sergey Kornilov admin 10/15/2018

https://xlinesoft.com/phprunner/docs/what_is_demoaccount.htm
K
 		KelvinChua author 10/16/2018



https://xlinesoft.com/phprunner/docs/what_is_demoaccount.htm


Followed the instructions, went to the finished tab, no demo account button found.
Thanks.
Kelvin Chua

SINGAPORE