2. PHPRunner General questions
  3. 30 sec intervals in the range of two date records
This topic is locked

30 sec intervals in the range of two date records

 		6/7/2010 3:17:24 AM
PHPRunner General questions
D
 danaci author

hi,

my table is

(

sno int

name varchar

adres

date

)
how to 30 sec intervals in the range of two date records on the screen to showing?
J
 		Jane 6/7/2010

I'm not sure that I understand your question.

Please re-phrase it.
D
 		danaci author 6/7/2010

dear jane,
range of two date records (ex. 6 records)

this records interval 30 min. show on the screen but on 30 min only one record.

regards.
A
 		ann 6/7/2010

Hi,
to show records n the time interval of 30 minutes only edit SQL query in the SQL mode on the Edit SQL query tab.

Here is a sample for MySQL:

SELECT

...

`date`,

FROM danaci_interval

WHERE (DATEDIFF(now(),`Date`) <1) and (MINUTE(DATEDIFF(now(),`Date`))<30)
D
 		danaci author 6/7/2010



Hi,
to show records n the time interval of 30 minutes only edit SQL query in the SQL mode on the Edit SQL query tab.

Here is a sample for MySQL:

SELECT

...

`date`,

FROM danaci_interval

WHERE (DATEDIFF(now(),`Date`) <1) and (MINUTE(DATEDIFF(now(),`Date`))<30)



dear Ann,
this code is getting all record and listing all record interval two date.(working and no problem).

but I want that 30 seconds remained on the screen of the records you should show the other records
best regards.
D
 		danaci author 6/8/2010

dear Ann,
this code is getting all record and listing all record interval two date.(working and no problem).

but I want that 30 seconds remained on the screen of the records you should show the other records
best regards.
A
 		ann 6/8/2010

Hi,
try this code:

SELECT

...

`date`,

FROM danaci_interval

WHERE (DATEDIFF(now(),`Date`) <1) and (SECOND(DATEDIFF(now(),`Date`))<30)
D
 		danaci author 6/8/2010

dear Ann,

I could not tell you about my problems.
for ex. I have 6 records two date range.

1 smith

2 john

3 nelson

4 ..

5 ..

6..
Keep record on the screen after 30 seconds, the other reecord.

Do not get to display all records.
best regards.
J
 		Jane 6/8/2010

Hi,
it's hard to understand what you want to do.

Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with detail description (or a couple of screenshots) of what you want to achieve.