You are here: Help with SQL statement « PHP « IT news, forums, messages
Help with SQL statement

Posted by Jacques on 02/18/05 07:21

How can I determine which users have signed in and are still on-line during
the first minute after they have signed in? My sql statement currently
reads:

SELECT * FROM tblusers WHERE usignedin = "yes" AND utimesignedin = (time() -
60)

Hoe does one indicate seconds in a SQL statement? Can I use the time()
function or should I use the now() function rather?

Thanks
Jacques

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация