Link to home
Start Free TrialLog in
Avatar of maccaj51
maccaj51Flag for Afghanistan

asked on

Using Timestap to show messages

Hello there,

I have a mysql database that has an arriving timestamp and a departing timestamp. How would i filter, using php, to get the name (also from the database) of the visitor if they current time is between the two timestamps?! and show a message if there is no current visitor?

Many thanks
Avatar of Kalpan
Kalpan
Flag of India image

you can query the database using the following

$sqlquery = "SELECT * FROM `dt_tb` WHERE dt BETWEEN '2005-01-01' AND '2005-12-31' ";

$saResults = mysql_query($sqlquery);

while($obResults = mssql_fetch_row($saResults))
{
   echo $obResults[0]." ".$obResults[1]; // change the field/column as your db table
}


Avatar of maccaj51

ASKER

Im not 100% but i think you may have misunderstood... very sorry if im wrong.

But i need to see whether the current time is between any of the database entries arriving and departing time...
Haven't tested it but try like this (if you have dates in your db) - if a straight timestamp just use UNIX_TIMESTAMP(NOW())

$sqlquery = "SELECT * FROM mytable WHERE UNIX_TIMESTAMP(NOW()) BETWEEN UNIX_TIMESTAMP(mydate1) AND UNIX_TIMESTAMP(mydate2) ";
please refer the following query

$sqlquery = "SELECT * FROM `dt_tb` WHERE ".$arr_time." <= CURTIME()  AND ".$dep_time." >=  CURTIME()";
hi Roads_Roads,

Your solution works great but how will i then make a different message if there are no returned results?

ASKER CERTIFIED SOLUTION
Avatar of Lukasz Chmielewski
Lukasz Chmielewski
Flag of Poland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
HERO!