Current location: Hot Scripts Forums » Programming Languages » PHP » extraction one randomly weekly (plz help)


extraction one randomly weekly (plz help)

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 04-06-06, 10:13 PM
MAT_ MAT_ is offline
Newbie Coder
  
Join Date: Apr 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Question extraction one randomly weekly (plz help)
firstly, I want to thank you for your efforts.

secondly:
I have DataBase in her a many of telephone numbers.

what I want is :
extraction one randomly weekly telephone number by spontaneous to win a present for example,
and I choose the day and time to extraction the telephone number.

How can I do that please?
Reply With Quote
  #2 (permalink)  
Old 04-07-06, 03:57 PM
MAT_ MAT_ is offline
Newbie Coder
  
Join Date: Apr 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
any body can help me please ?
Reply With Quote
  #3 (permalink)  
Old 04-08-06, 10:57 PM
Wuiqed Wuiqed is offline
Wannabe Coder
  
Join Date: Aug 2004
Location: Sverige
Posts: 124
Thanks: 0
Thanked 0 Times in 0 Posts
Quote:
Originally Posted by MAT_
any body can help me please ?
Something like this should suffice: SELECT phonenumber FROM table ORDER BY RAND() LIMIT 1
Reply With Quote
  #4 (permalink)  
Old 04-09-06, 06:06 AM
MAT_ MAT_ is offline
Newbie Coder
  
Join Date: Apr 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
yes, thank you..

but how I can timing by hosting server not user pc,
to apply my Query :
SELECT phonenumber FROM table ORDER BY RAND() LIMIT 1 ?
Reply With Quote
  #5 (permalink)  
Old 04-09-06, 08:24 AM
FiRe FiRe is offline
Code Guru
  
Join Date: Oct 2004
Location: UK
Posts: 801
Thanks: 0
Thanked 0 Times in 0 Posts
use cron jobs
__________________
Alexa Share <-- Trade virtual shares in websites with this online game.

codR.us <-- Submit and vote for your favorite code snippets with codR.us.

XEWeb.net <-- The ultimate PHP resource network.
Reply With Quote
  #6 (permalink)  
Old 04-09-06, 10:27 AM
MAT_ MAT_ is offline
Newbie Coder
  
Join Date: Apr 2006
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Quote:
Originally Posted by FiRe
use cron jobs
can you explain more please ?
Reply With Quote
  #7 (permalink)  
Old 04-09-06, 11:20 AM
FiRe FiRe is offline
Code Guru
  
Join Date: Oct 2004
Location: UK
Posts: 801
Thanks: 0
Thanked 0 Times in 0 Posts
http://en.wikipedia.org/wiki/Cron_job
if you have cpanel you can setup cron jobs from their...
__________________
Alexa Share <-- Trade virtual shares in websites with this online game.

codR.us <-- Submit and vote for your favorite code snippets with codR.us.

XEWeb.net <-- The ultimate PHP resource network.
Reply With Quote
Reply

Bookmarks

« dynamic list menu | MySQL table join and php »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
help me plz... josethomasrajesh Everything Java 0 03-30-06 01:25 AM
want to validate Time in asp formconfused: plz help sumitbharatiya JavaScript 1 05-06-05 02:44 PM
Searching after a "Skillscript", or help for this one: -important plz read!!!- Dr. Prozessor Script Requests 0 01-25-05 07:57 AM


All times are GMT -5. The time now is 07:07 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.