Hello all!
First I would like to say thanks to everyone who has posted here because I have found quite a few answers that I needed here on this forum that I have not found anywhere else.
THANKS YOU ALL!!
Now to my question.
I have recently installed PHP on a seperate server than our Pervasive SQL v 9.5 database and have written a few pages and queries to help our Customer Satisfaction Department gather delivery information that our Profit program makes difficult to access.
For testing purposes I have shortened the query to this and have successfully displayed the results in my web browser, see below.
SELECT DISTINCT sls_his_cust_id
FROM sls_his
where sls_his_prchdat_alt = 20080801
This works great but would require me to change the PHP scripting to include a form field for the person to manually enter the date they want to see the info for and have it in the yyyymmdd format.
I would much rather not have to rely on them to enter this and be able to use the curdate feature. What I am shooting for is something like curdate - 3 days so that it would pull the customer data for those deliveries done 3 days ago.
I was also thinking that instead of curdate I could use a max query on the sls_his_prchdat_alt column and subtract 3... would that work and if so how would the syntax look?
First I would like to say thanks to everyone who has posted here because I have found quite a few answers that I needed here on this forum that I have not found anywhere else.
THANKS YOU ALL!!
Now to my question.
I have recently installed PHP on a seperate server than our Pervasive SQL v 9.5 database and have written a few pages and queries to help our Customer Satisfaction Department gather delivery information that our Profit program makes difficult to access.
For testing purposes I have shortened the query to this and have successfully displayed the results in my web browser, see below.
SELECT DISTINCT sls_his_cust_id
FROM sls_his
where sls_his_prchdat_alt = 20080801
This works great but would require me to change the PHP scripting to include a form field for the person to manually enter the date they want to see the info for and have it in the yyyymmdd format.
I would much rather not have to rely on them to enter this and be able to use the curdate feature. What I am shooting for is something like curdate - 3 days so that it would pull the customer data for those deliveries done 3 days ago.
I was also thinking that instead of curdate I could use a max query on the sls_his_prchdat_alt column and subtract 3... would that work and if so how would the syntax look?