This topic is locked

$data['startdate'] become ''

10/12/2018 7:53:25 PM
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

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

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