Hmm.. I don't quite understand with the $contracts thingy. Ive tried your code but nothing came out. This is what Im using now, its similar to the code I have previously posted. I just want to include the value from database using php in that alert, but i don't know how.
[PHP]<?php
$expiry_date = $_GET['expiry_date'];
$query = "SELECT * FROM cust_domain WHERE TO_DAYS(expiry_ date)...
User Profile
Collapse
-
ohh ya, it was supposed to be,
"SELECT * FROM cust_domain WHERE TO_DAYS(NOW()) - TO_DAYS(expiry_ date) <= 60"
Is it?but still, I think this code is useless for me.sigh.
What I meant by the code is working fine is the code produces no error and the pop up came out.
What I expect it to do is, every time I log in, if there is a contract that will expire in two months time, in...Leave a comment:
-
Thanks guys for replying. I'm now slowly getting the picture of it. Hmm, but still I think I really am a slow learner and I find it hard to understand the codes in php.
This is the clearer picture of what I wanted to do but i failed. I wanted to do this admin system which to manage the customer data, that have forms to input the data in the database. The admin can insert, edit, delete the data and also view the report. I've finish...Leave a comment:
-
Date calculation in php
Hey guys,
Ive posted a question about making a popup that will come out two months before the expiry date. acoder has helped me with the popup thingy, but im facing this problem of calculating the date that will make the popup come out 2 months before the expiry date, in simpler words, its like a notification. if lets say today is the date that is exactly two months before the expiry date, when the user logs in, the popup will automatically... -
ooops sorry i forgot to check the forum's name.so ill post it in php forum.Leave a comment:
-
-
Date calculation in php
Hey guys,
Ive posted a question about making a popup that will come out two months before the expiry date. acoder has helped me with the popup thingy, but im facing this problem of calculating the date that will make the popup come out 2 months before the expiry date, in simpler words, its like a notification. if lets say today is the date that is exactly two months before the expiry date, when the user logs in, the popup will automatically... -
I don't know how to do both the date calculation and the popup in php. i only know this javascript for popup:
<SCRIPT language="javas cript">
alert('Hello');
</SCRIPT>
Im such a loser eh?Leave a comment:
-
Ahh, i actually understand that, but the thing is, i don't how to start it. can u prolly show me one example?...Leave a comment:
-
Problem in doing popup box
Hi,
I am very new to AJAX because i never learned AJAX back in university but i wanted to do this popup box that will appear two months before the expiry date(this expiry date has to be retrieved from the database because i've made a form which i have to fill in with all the customer's details including their contract's expiry date) which is just like a notification. So, the thing is, i know a lil bit of javascript but i know that javascript...
No activity results to display
Show More
Leave a comment: