Oh, sorry, if you're just storing the UNIX timestamps as INT in the db (as in the field data type is INT or BIGINT or whatever) then the first function will work fine
Should be possible using the following script:
SELECT t1.timeStamp, t2.timeStamp
FROM test AS t1, test AS t2
WHERE ABS( t1.timeStamp - t2.timeStamp ) <=300
AND t1.primKey != t2.primKey
ORDER BY...
AFAIK, to compare fields returned by SQL you would need some sort of scripting language. How are you accessing your database?
Even if it is possible, then for what purpose?
If you don't have a...
I'm not sure I understand your question. Is the content.php normally a static page in one language?
For example, do you have a set page in nl, and if you need to convert it to english you instead...
I've posted the code below, but if you are planning on making this site available to the public, you might want to check out jquery and form validation (you can easily make sure they actually enter a...
I'm guessing you figured out how to convert the date to YYYY-MM-DD? (It's better in that format anyway, since mysql uses it and its easy to break down).
hmmm....your server side guy needs to store it in the cookie instead (that makes more sense)
OR, they could store it in a session
perhaps the server side guy doesn't know enough about server-side...
Because of the way you have it coded (one large image map), that would be difficult. It is possible to create HTML elements that get larger and smaller as the browser changes size (by using %'s for...
Well, if you want to figure it out yourself (which is best), here's some hints:
1. Since you're script is using some weird number as a date, you always need a reference point (for my script I chose...
The first thing would be to find out what you have access to. There are a variety of database options out there, but your best bet would be mySQL. You would also need a server-side scripting language...
If all you want to use it for is that one clickable map, I would definitely recommend having a freelancer build it for you. A clickable map like that should cost under $100, and there should be NO...
the form tag has a "method" attribute, which can be either POST or GET. GET puts them in the url of the "action" attribute.
Confusing, so here is an example
that is quite odd...what type of database is it? most databases can store a "date", so it seems weird..
Any idea what the day 1 was? because 2000 years gives me only ~730000 (less than half that...
@WolfShade
I don't use AJAX much, so I totally forgot about that...but from my understanding, AJAX would still need some sort of server side script on the other end to process the file, no?
...