visitor (0 QPoints)
  • FR
  • EN
  • NL
  • DE
  • ES
315 experts, 1193 registered users, 1659 questions already answered
European Experts Exchange, the very best site for high-quality IT solutions

New Improved Search!

 


05/10/2011 1h30 : Steve Jobs is dead, the father of Apple ][ is gone, we are all orphaned.

Languages :: PHP :: Selecting timestamps which are only a certain time, ANY date.
By: CrazyPhil U.S.A.  Date: 24/09/2003 00:00:00  English  Points: 275 Status: Answered
Quality : Excellent
How do I make it search for any time?

For getting a date at any time I use:

$date_start = strtotime("$year-$month-$day 00:01");
$date_end = strtotime("$year-$month-$day 23:59");

... date >= '".$date_start."' AND date <= '".$date_end."'"

For time I tried something like this but of course it didn't work:

$time_start = strtotime("2001-01-1 $hour:$minute $amorpm");
$time_end = strtotime("2006-12-27 $hour:$minute $amorpm");

... date >= '".$time_start."' AND date <= '".$time_end."'"

-------

So how would this be done?

For example I want to find all entries at 7:00 PM, doesn't matter what day.

Thanks!
By: LornaJane Date: 24/09/2003 01:46:00 English  Type : Comment
well you could select them all and then do a check:

<?php
$resultset = mysqL-query("select * from table") or die(mysql_error());
while($result = mysql_fetch_assoc($result)
{
$hours = date('H', $result['date']); // this might make these variables strings rather than numbers, watch out!
$mins = date('i', $result['date']);
if($hours == 19 && $mins == 0)
{
// do whatever you were going to
}
}
?>

Or does this miss the point?
By: CrazyPhil Date: 24/09/2003 01:58:00 English  Type : Comment
Its a search function, I need to list all entries with certain assigned variables.


Very small part of what I have:

if ($lines_one_id != -1 AND lines_two_id != -1) {
$query .= (($query_num > 0) ? ' AND ': '')." ((lines_one_id = '".$lines_one_id."' OR lines_one_id = '".$lines_two_id."') OR (lines_two_id = '".$lines_one_id."' OR lines_two_id = '".$lines_two_id."')) ";
$query_num++;
} elseif ($lines_one_id != -1 AND $lines_two_id == -1){
$query .= (($query_num > 0) ? ' AND ': '')." (lines_one_id = '".$lines_one_id."' OR lines_two_id = '".$lines_one_id."') ";
$query_num++;
} elseif ($lines_one_id == -1 AND $lines_two_id != -1){
$query .= (($query_num > 0) ? ' AND ': '')." (lines_one_id = '".$lines_two_id."' OR lines_two_id = '".$lines_two_id."') ";
$query_num++;

}



if ($minute == '') {
$minute = "00";
}

if ($ampm == 1) {
$amorpm = 'AM';
} else {
$amorpm = 'PM';
}
if ($any_time != 1 AND $any_date != 1) {
$timestamp = strtotime("$year-$month-$day $hour:$minute $amorpm");
$query .= (($query_num > 0) ? ' AND ': '')." date = '".$timestamp."' ";
$query_num++;
} elseif($any_time == 1 AND $any_date != 1) {
$date_start = strtotime("$year-$month-$day 00:01");
$date_end = strtotime("$year-$month-$day 23:59");
$query .= (($query_num > 0) ? ' AND ': '')." date >= '".$date_start."' AND date <= '".$date_end."'";
$query_num++;
} elseif ($any_time != 1 AND $any_date == 1) {
$timestamp = strtotime("2001-01-1 $hour:$minute $amorpm");
$timestamp2 = strtotime("2006-12-27 $hour:$minute $amorpm");
$query .= (($query_num > 0) ? ' AND ': '')." date >= '".$timestamp."' AND date <= '".$timestamp2."'";
$query_num++;
}


$query .= ' ORDER BY '.$sort.' '.$sort_2;

$sql = "SELECT * FROM ".GAMES_TABLE.((strlen(str_replace('=','',$query)) == strlen($query)) ? $query : " WHERE ".$query)." LIMIT $offset, $limit";
$result = mysql_query($sql);
--------------

So I just want to replace the any date, with certain with a working function, it would greatly increase the query time to query all entries (There will be ALOT, already is 280), so i cannot do that.
By: LornaJane Date: 24/09/2003 02:07:00 English  Type : Comment
I'm not a mysql nut so I could be wrong, but as I understood it, there isn't a big difference in time for mysql to return all results or to sort and return fewer. However it will of course take longer to iterate through lots of results.

If you really need to do it in MySQL then I can't think of anything except a complicated equation involving a "mod" operation to divide by minutes in a day... bit of a long shot

Another suggestion would be for you to store "year", "month", "day", "hour" "min" separately, then you will easily be able to do a variety of time-based selects really easily... but it makes it harder to work with chronological functions. Depends what your needs are really
By: VGR Date: 24/09/2003 06:11:00 English  Type : Comment
a) "For getting a date at any time I use:

$date_start = strtotime("$year-$month-$day 00:01");
$date_end = strtotime("$year-$month-$day 23:59");

... date >= '".$date_start."' AND date <= '".$date_end."'""

I would have used : where date>='$date_start' and date<='$date_end' (simply)

b) "For time I tried something like this but of course it didn't work:

$time_start = strtotime("2001-01-1 $hour:$minute $amorpm");
$time_end = strtotime("2006-12-27 $hour:$minute $amorpm");

... date >= '".$time_start."' AND date <= '".$time_end."'""

I would use : where right(date,8)>='$time_start' and right(date,8)<='$time_end'

c) don't forget that MySql's DATETIME format isn't HH:MM [PM] but the SQL standard one, HH:MM:SS so you should issue $hour:$minute:$seconds (after having made sure they are 0-padded on the left, of course, using if (strlen($x)<2)) $x="0$x";
By: CrazyPhil Date: 27/09/2003 09:49:00 English  Type : Comment
so 'right(date,8)' would isolate time from date, and using the same function can be applied to isolate date from time?

For example if I wanted to sort by date, something, time

and date is a unix timestamp .. 'right(date,#)' ?

I'm trying to grasp how this works before I apply it, i'm also going to go through the mysql manual in a sec.
By: CrazyPhil Date: 27/09/2003 09:56:00 English  Type : Comment
Ok a quick browse through it and this is what I come up with related to right():

RIGHT() pulls off the rightmost ...#'s ...

A unix timestamp is based on the date december 31 1969 16:00 = 0..and anything after that is added (If i am not mistaken), so taking away 5 characters would not work.

This has to be possible somehow...
By: CrazyPhil Date: 03/10/2003 13:38:00 English  Type : Comment
I've increased points again, can someone please present me with a viable solution.
By: VGR Date: 03/10/2003 15:00:00 English  Type : Comment
absolutely not

a SQL TIMESTAMP is 20031003070400 which is roughly equivalent to MySql's SQL-DATETIME format 2003-10-03 07:04:00

so extracting time with RIGHT(field,8) and date with LEFT(field,10) is perfectly valid.

Using UNIX_TIMESTAMP is no different on the principle
By: VGR Date: 03/10/2003 15:02:00 English  Type : Comment
and I think I said it all and fully adressed your two points on Date: 09/24/2003 10:11PM CEST
By: CrazyPhil Date: 03/10/2003 15:47:00 English  Type : Comment
I'm not sure If Its me not understanding or you...

1062376200 = August 29,2003 18:00
1062376200 = The amount of seconds since the Unix Epoc (December 31st 1969, 4:00 PM)

December 31, 1969 16:00 + 1062376200 seconds = August 29,2003 18:00

Thats a unix timestamp, how using the same principle will it allow me to extract time from it using left/right in mysql?

...As opposed to:
20031003070400 which easily shows year,month,day,hour,minute,second in exact order.
By: VGR Date: 03/10/2003 16:22:00 English  Type : Comment
RTFM

1) UNIX_TIMESTAMP(date)
If called with no argument, returns a Unix timestamp (seconds since '1970-01-01 00:00:00' GMT) as an unsigned integer. If UNIX_TIMESTAMP() is called with a date argument, it returns the value of the argument as seconds since '1970-01-01 00:00:00' GMT. date may be a DATE string, a DATETIME string, a TIMESTAMP, or a number in the format YYMMDD or YYYYMMDD in local time:

mysql> SELECT UNIX_TIMESTAMP();
-> 882226357
mysql> SELECT UNIX_TIMESTAMP('1997-10-04 22:23:00');
-> 875996580

When UNIX_TIMESTAMP is used on a TIMESTAMP column, the function returns the internal timestamp value directly, with no implicit ``string-to-Unix-timestamp'' conversion. If you pass an out-of-range date to UNIX_TIMESTAMP() it returns 0, but please note that only basic checking is performed (year 1970-2037, month 01-12, day 01-31). If you want to subtract UNIX_TIMESTAMP() columns, you may want to cast the result to signed integers. See section 6.3.5 Cast Functions.


2) FROM_UNIXTIME(unix_timestamp)
FROM_UNIXTIME(unix_timestamp,format)
Returns a representation of the unix_timestamp argument as a value in 'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS format, depending on whether the function is used in a string or numeric context:

mysql> SELECT FROM_UNIXTIME(875996580);
-> '1997-10-04 22:23:00'
mysql> SELECT FROM_UNIXTIME(875996580) + 0;
-> 19971004222300

If format is given, the result is formatted according to the format string. format may contain the same specifiers as those listed in the entry for the DATE_FORMAT() function:

mysql> SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(),
-> '%Y %D %M %h:%i:%s %x');
-> '2003 6th August 06:22:58 2003'



3) demonstration of how it's rather easy...

mysql> select @a:=from_unixtime(1062376200),left(@a,10) as thedate,right(@a,8) as thetime;
+-------------------------------+------------+----------+
| @a:=from_unixtime(1062376200) | thedate | thetime |
+-------------------------------+------------+----------+
| 2003-09-01 02:30:00 | 2003-09-01 | 02:30:00 |
+-------------------------------+------------+----------+
1 row in set (0.00 sec)
By: CrazyPhil Date: 03/10/2003 16:23:00 English  Type : Comment
Another example is:

I have three entries, each with two columns (place_id,date):


1,1066503600
2,1066503600
1,1066504200

AND I want get it like this:

1,1066503600
1,1066504200
2,1066503600


..Your saying I do this?:

SELECT * FROM table ORDER by LEFT(date,10),place_id,RIGHT(date,8)

..And your telling me

Left(date,10) will get only the date not including time, RIGHT(date,8) will only get the time.

Anyways.. Thanks for trying to help me figure it out so far.
By: VGR Date: 03/10/2003 16:23:00 English  Type : Comment
and Epoch0=01/01/1970 00:00:00 as anybody knows
By: CrazyPhil Date: 03/10/2003 16:24:00 English  Type : Comment
Ha. Nice Timing, Until I check what you just wrote, disregard what I have written last.
By: CrazyPhil Date: 03/10/2003 16:26:00 English  Type : Comment
Well the server I use when I do a date get on 0 .. I get December 31st..Don't ask!
By: VGR Date: 03/10/2003 16:35:00 English  Type : Comment
I don't ask :D

mysql> select from_unixtime(0);
+---------------------+
| from_unixtime(0) |
+---------------------+
| 1970-01-01 01:00:00 |
+---------------------+
1 row in set (0.00 sec)

mysql>


01:00:00 huh huh huh huh
By: VGR Date: 03/10/2003 16:36:00 English  Type : Comment
quoting manual : "UNIX_TIMESTAMP... [is] a Unix timestamp (seconds since '1970-01-01 00:00:00' GMT) as an unsigned integer"

huh huh huh :D
By: CrazyPhil Date: 03/10/2003 16:46:00 English  Type : Comment
Well I assume its because of the server timezone or something:

But that gives me:

+-------------------------------+------------+----------+
| @a:=from_unixtime(1062376200) | thedate | thetime |
+-------------------------------+------------+----------+
| 2003-08-31 17:30:00 | 2003-08-31 | 17:30:00 |
+-------------------------------+------------+----------+
1 row in set (0.00 sec)


Anyways, furthurmore how do I use it in selecting from the database like I wish too, I'm not sure how to mix those functions? This stuff has become pretty complicated for me, and I am getting confused quite easily lol...plus its 2:40 am...

Thanks for being patient with me!
By: CrazyPhil Date: 03/10/2003 16:49:00 English  Type : Comment
Btw..unix time again:

from_unixtime( 0 )
1969-12-31 16:00:00


Stupid server...
Yes before I knew it was 1/1/1970..but decided to change my mind based on my webservers mind lol.
By: VGR Date: 03/10/2003 16:52:00 English  Type : Comment
yes, for sure it's a TZ problem : I'm at GMT+1, you must be at GMT-8 (probably in the USA)

right ?
By: CrazyPhil Date: 03/10/2003 16:54:00 English  Type : Comment
Not my personal webserver, just one I'm paying for, i'm up in canada, GMT -5 .

The server is in the U.S. though.
By: VGR Date: 03/10/2003 16:57:00 English  Type : Comment
shouldn't you be asleep ? :D
By: CrazyPhil Date: 03/10/2003 16:58:00 English  Type : Comment
I am asleep, just wanna finish this before my head hits the floor.
By: CrazyPhil Date: 04/10/2003 05:14:00 English  Type : Comment
Damnit lol, i've tried too many things:

SELECT @a:=from_unixtime(1062376200),left(@a,10) as thedate,right(@a,8) as thetime,* FROM table ORDER by thedate,place_id,thetime

....alllll wrong!

How do I intergrate that to do what I wanted to do above:
-------------
I have three entries, each with two columns (place_id,date):

1,1066503600
2,1066503600
1,1066504200

AND I want get it like this: Order by date(no time),place_id,time(no date)

1,1066503600
1,1066504200
2,1066503600

---------
By: VGR Date: 04/10/2003 05:20:00 English  Type : Comment
for selecting from the DB :

I have three entries, each with two columns (place_id,date):


1,1066503600
2,1066503600
1,1066504200

AND I want get it like this:

1,1066503600
1,1066504200
2,1066503600


SELECT * FROM table ORDER by place_id ASC,date ASC;
By: VGR Date: 04/10/2003 05:23:00 English  Type : Comment
or :

SELECT * FROM table ORDER by (date DIV 86400) ASC,place_id ASC,(place_id MOD 86400) ASC;
By: VGR Date: 04/10/2003 05:24:00 English  Type : Comment
sorry syntax error :should be :

SELECT * FROM table ORDER by (date DIV 86400) ASC,place_id ASC,MOD(place_id, 86400) ASC;
By: CrazyPhil Date: 04/10/2003 05:58:00 English  Type : Comment
You have an error in your SQL syntax....

lol

Let me put out a bigger example:

I have eight entries, each with two columns (place_id,date):
(ignore the timestamps..lets say they equal)
1,1066503600 -> Jan 1 2003 10:00 AM
2,1066503600 -> Jan 1 2003 10:00 AM
1,1066504200 -> Jan 1 2003 11:00 AM
2,1066505000 -> Jan 1 2003 2:00 PM
1,1066505000 -> Jan 2 2003 10:00 AM
1,1066509000 -> Jan 2 2003 11:00 AM
2,1066518900 -> Jan 2 2003 11:00 AM
1,1066519000 -> Jan 2 2003 12:00 AM


And sort by date(no time), place_id, time(no date)

So I should get this:

1,1066503600 -> Jan 1 2003 10:00 AM
1,1066504200 -> Jan 1 2003 11:00 AM
2,1066503600 -> Jan 1 2003 10:00 AM
2,1066505000 -> Jan 1 2003 2:00 PM
1,1066505000 -> Jan 2 2003 10:00 AM
1,1066509000 -> Jan 2 2003 11:00 AM
1,1066519000 -> Jan 2 2003 12:00 AM
2,1066518900 -> Jan 2 2003 11:00 AM

So it sorts first by the day its on, then sorts by the place_id , then sorts by the time..


By: VGR Date: 04/10/2003 06:26:00 English  Type : Comment
that's what I wrote. I thought that was what you asked for : data first, then place_id, then time

isn't it ?

I made a type : third and last element

Trivially, it's not MOD(place_id,86400) but MOD(date,86400)
By: CrazyPhil Date: 04/10/2003 06:53:00 English  Type : Comment
Still not working :(

SQL-query :

SELECT *
FROM `table`
ORDER BY (date DIV 86400) ASC , place_id ASC , MOD( date, 86400 ) ASC

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DIV 86400 ) ASC , place_id ASC , MOD( date, 86400 ) ASC
By: VGR Date: 04/10/2003 07:02:00 English  Type : Comment
ah ok . I hadn't understood there was a syntax error. Let me sort this out. Must be a datatype problem
By: VGR Date: 04/10/2003 07:18:00 English  Type : Comment
foudn the cause :

DIV is new in MySQL 4.1.0.
By: VGR Date: 04/10/2003 07:19:00 English  Type : Comment
is this ok for you now ?

mysql> select *,from_unixtime(thedate) from timestamps;
+----+----------+------------+------------------------+
| id | place_id | thedate | from_unixtime(thedate) |
+----+----------+------------+------------------------+
| 1 | 1 | 1066503600 | 2003-10-18 21:00:00 |
| 2 | 2 | 1066503600 | 2003-10-18 21:00:00 |
| 3 | 1 | 1066503600 | 2003-10-18 21:00:00 |
| 4 | 2 | 1066503600 | 2003-10-18 21:00:00 |
| 5 | 1 | 1066505000 | 2003-10-18 21:23:20 |
| 6 | 2 | 1066509000 | 2003-10-18 22:30:00 |
| 7 | 1 | 1066519000 | 2003-10-19 01:16:40 |
+----+----------+------------+------------------------+
7 rows in set (0.01 sec)

mysql> select * from timestamps ORDER BY floor(thedate/86400) ASC , place_id ASC , MOD( thedate, 86400 ) ASC;
+----+----------+------------+
| id | place_id | thedate |
+----+----------+------------+
| 1 | 1 | 1066503600 |
| 3 | 1 | 1066503600 |
| 5 | 1 | 1066505000 |
| 7 | 1 | 1066519000 |
| 2 | 2 | 1066503600 |
| 4 | 2 | 1066503600 |
| 6 | 2 | 1066509000 |
+----+----------+------------+
7 rows in set (0.05 sec)
By: VGR Date: 04/10/2003 07:26:00 English  Type : Comment
just to double-check, I used the first suggestion on the DATETIME format deduced from the unix timestamp :

mysql> select @a:=from_unixtime(thedate), timestamps.id,timestamps.place_id,timestamps.thedate from timestamps ORDER BY left(@a,10)
ASC , place_id ASC , right(@a,8) ASC;
+----------------------------+----+----------+------------+
| @a:=from_unixtime(thedate) | id | place_id | thedate |
+----------------------------+----+----------+------------+
| 2003-10-18 21:23:20 | 5 | 1 | 1066505000 |
| 2003-10-18 21:00:00 | 3 | 1 | 1066503600 |
| 2003-10-19 01:16:40 | 7 | 1 | 1066519000 |
| 2003-10-18 21:00:00 | 2 | 2 | 1066503600 |
| 2003-10-18 21:00:00 | 4 | 2 | 1066503600 |
| 2003-10-18 22:30:00 | 6 | 2 | 1066509000 |
| 2003-10-18 21:00:00 | 1 | 1 | 1066503600 |
+----------------------------+----+----------+------------+
7 rows in set (0.01 sec)
By: VGR Date: 04/10/2003 07:27:00 English  Type : Answer
this doesn't seem to work either, so I debugged a bit and found that to use UDVs like @s and parts of it, those parts needed to be SELECTed before they could be used in the ORDER BY clause... How strange.

Anyway, it works now even if it looks messy ::

mysql> select @a:=from_unixtime(thedate), left(@a,10), right(@a,8), timestamps.id,timestamps.place_id,timestamps.thedate from timest
amps ORDER BY left(@a,10) ASC, place_id ASC , right(@a,8) ASC;
+----------------------------+-------------+-------------+----+----------+------------+
| @a:=from_unixtime(thedate) | left(@a,10) | right(@a,8) | id | place_id | thedate |
+----------------------------+-------------+-------------+----+----------+------------+
| 2003-10-18 21:00:00 | 2003-10-18 | 21:00:00 | 1 | 1 | 1066503600 |
| 2003-10-18 21:00:00 | 2003-10-18 | 21:00:00 | 3 | 1 | 1066503600 |
| 2003-10-18 21:23:20 | 2003-10-18 | 21:23:20 | 5 | 1 | 1066505000 |
| 2003-10-18 21:00:00 | 2003-10-18 | 21:00:00 | 2 | 2 | 1066503600 |
| 2003-10-18 21:00:00 | 2003-10-18 | 21:00:00 | 4 | 2 | 1066503600 |
| 2003-10-18 22:30:00 | 2003-10-18 | 22:30:00 | 6 | 2 | 1066509000 |
| 2003-10-19 01:16:40 | 2003-10-19 | 01:16:40 | 7 | 1 | 1066519000 |
+----------------------------+-------------+-------------+----+----------+------------+
7 rows in set (0.00 sec)
By: CrazyPhil Date: 04/10/2003 08:09:00 English  Type : Comment
Works 100% Perfect. Thanks!

Now I just have to figure out my first question, searching for all things at a certain time lol.

hm..

select @a:=from_unixtime(thedate), left(@a,10), right(@a,8), timestamps.* from timestamps WHERE right(@a,8) = '.$time.' ORDER BY left(@a,10) ASC, place_id ASC , right(@a,8) ASC;

Will try that ;)
By: CrazyPhil Date: 04/10/2003 08:50:00 English  Type : Comment
Hm.. that doesn't work. Want 300 more Points? ;)
By: CrazyPhil Date: 04/10/2003 09:03:00 English  Type : Comment
I thought that right(@a,8) created a temporary column I could use ..but it appears not, $time would be equal to something like '18:00:00'...

I guess I could retrieve them all, and as the come through just check if its 18:00:00, that is if PHP recognizes that temporary column.
By: CrazyPhil Date: 04/10/2003 09:03:00 English  Type : Comment
I thought that right(@a,8) created a temporary column I could use ..but it appears not, $time would be equal to something like '18:00:00'...

I guess I could retrieve them all, and as the come through just check if its 18:00:00, that is if PHP recognizes that temporary column.
By: VGR Date: 04/10/2003 15:22:00 English  Type : Comment
it is

just alias it

select @a:=from_unixtime(thedate) as a, left(@a,10) as b, right(@a,8) as c, timestamps.id,timestamps.place_id,timestamps.thedate from timestamps ORDER BY left(@a,10) ASC, place_id ASC , right(@a,8) ASC;
By: CrazyPhil Date: 04/10/2003 15:39:00 English  Type : Comment
then I do, WHERE c = '18:00:00' ?

Unknown column 'C' in 'where clause'

Thats what I get :(
By: VGR Date: 04/10/2003 15:43:00 English  Type : Comment
no, use where right(@a,8) etc

don't use the aliases in the WHERE clause(s), but use them in PHP to retrieve the columns. isn't this what you wanted ?
By: CrazyPhil Date: 04/10/2003 15:56:00 English  Type : Comment
I don't need to retrieve the column in php, but if I can't use WHERE right(@a,8) = VALUE .. I'll have too. Its just to retrieve only certain other data to php.

I tried the (WHERE right(@a,8) = VALUE) and It doesn't give me an error, but doesn't work either. It just gives me 0 tables, and even if I do (WHERE right(@a,8) != VALUE), It still returns 0 tables.. not too sure whats going on, since there is no error.
By: VGR Date: 04/10/2003 16:35:00 English  Type : Comment
???

"I thought that right(@a,8) created a temporary column I could use ..but it appears not, $time would be equal to something like '18:00:00'...

I guess I could retrieve them all, and as the come through just check if its 18:00:00, that is if PHP recognizes that temporary column."


???

Don't use the @a anymore :

mysql> select @a:=from_unixtime(thedate), left(@a,10), right(@a,8), timestamps.id,timestamps.place_id,timestamps.thedate from timestamps where right(from_unixtime(thedate),8)='21:0
0:00' ORDER BY left(@a,10) ASC, place_id ASC;
+----------------------------+-------------+-------------+----+----------+------------+
| @a:=from_unixtime(thedate) | left(@a,10) | right(@a,8) | id | place_id | thedate |
+----------------------------+-------------+-------------+----+----------+------------+
| 2003-10-18 21:00:00 | 2003-10-18 | 21:00:00 | 1 | 1 | 1066503600 |
| 2003-10-18 21:00:00 | 2003-10-18 | 21:00:00 | 3 | 1 | 1066503600 |
| 2003-10-18 21:00:00 | 2003-10-18 | 21:00:00 | 2 | 2 | 1066503600 |
| 2003-10-18 21:00:00 | 2003-10-18 | 21:00:00 | 4 | 2 | 1066503600 |
+----------------------------+-------------+-------------+----+----------+------------+
4 rows in set (0.00 sec)
By: CrazyPhil Date: 04/10/2003 16:40:00 English  Type : Comment
Your Awesome man!!!

Thanks Again!

Do register to be able to answer

©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page! Post to Twitter Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to Facebook Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

EContact
browser fav
page generated in 672.252890 milliseconds

Why Google AdSense ads ?
compteur
 Ranking-Hits PageRank for this page