Generate random timestamp?

DylanButler · 08-30-2007, 11:26 PM

how can I generate a random timestamp (between now and a few seconds from now / before now) with PHP?

PHP Code:

  $this->db->Execute("UPDATE ".T_BANNERS." SET impressions=impressions+1, date_last_displayed=NOW() WHERE id=?",array($banner['id'])); 

????: NamePros.com http://www.namepros.com/programming/368481-generate-random-timestamp.html

That is my PHP that does the update. The problem is I am doing this multiple times quickly and the same date/time is getting inserted for each banner (we are updating banners here) which as a result is causing trouble randomizing banners to display.

What I want to do:

Create a random time (in seconds) from now and a few seconds in the future. Just enough time so the banners don't get the same date_last_displayed value in each row.

I have searched everywhere for an easy way to do this and most don't explain how to randomize time without treating it as a string.

Any help is greatly appreciated.

geronimo · 08-31-2007, 05:21 AM

hi,

instead of "randomizing" your timestamp as you put it, you could order your data by the timestamp and id

Order by timestamp, id....

that way you will get the banners sorted in the correct order

Zurvan · 08-31-2007, 06:44 AM

You can convert your timestamp to an integer, and create a random number & add it on to the time. No need to work with strings. Look at the time() function

DylanButler · 08-31-2007, 08:57 AM

Originally Posted by geronimo

hi,
????: NamePros.com http://www.namepros.com/showthread.php?t=368481

instead of "randomizing" your timestamp as you put it, you could order your data by the timestamp and id

Order by timestamp, id....

that way you will get the banners sorted in the correct order

Yes thats exactly what I did to fix this, order by date_last_modified, rand()

and that seems to work. I just wanted to see how this would be done like the last poster said, by adding an integer.

geronimo · 08-31-2007, 09:15 AM

fair enough, glad you fixed it.

08-30-2007, 11:26 PM	THREAD STARTER #1 (permalink)
DylanButler NamePros Regular Join Date: Jan 2006 Location: San Diego, CA Posts: 734	Generate random timestamp? how can I generate a random timestamp (between now and a few seconds from now / before now) with PHP? PHP Code: `$this->db->Execute("UPDATE ".T_BANNERS." SET impressions=impressions+1, date_last_displayed=NOW() WHERE id=?",array($banner['id'])); ????: NamePros.com http://www.namepros.com/programming/368481-generate-random-timestamp.html` That is my PHP that does the update. The problem is I am doing this multiple times quickly and the same date/time is getting inserted for each banner (we are updating banners here) which as a result is causing trouble randomizing banners to display. What I want to do: Create a random time (in seconds) from now and a few seconds in the future. Just enough time so the banners don't get the same date_last_displayed value in each row. I have searched everywhere for an easy way to do this and most don't explain how to randomize time without treating it as a string. Any help is greatly appreciated. __________________ -Dylan Butler EXAMP - San Diego Web Design

08-31-2007, 06:44 AM	#3 (permalink)
Zurvan NamePros Member Join Date: May 2007 Posts: 56	You can convert your timestamp to an integer, and create a random number & add it on to the time. No need to work with strings. Look at the time() function __________________ Web Design and Internet Services - Oshawa, Ontario

08-31-2007, 05:21 AM	#2 (permalink)
geronimo NamePros Regular Join Date: Aug 2007 Posts: 352	hi, instead of "randomizing" your timestamp as you put it, you could order your data by the timestamp and id Order by timestamp, id.... that way you will get the banners sorted in the correct order

08-31-2007, 09:15 AM	#5 (permalink)
geronimo NamePros Regular Join Date: Aug 2007 Posts: 352	fair enough, glad you fixed it.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)