HektoR Posted December 20, 2008 Share Posted December 20, 2008 hello everyone. i have msql base and i when i reload site i want to get latest information from php base. and i want also to this script will reload automatically every 10 second. how to make this ? Link to comment https://forums.phpfreaks.com/topic/137796-php-automatic-updates/ Share on other sites More sharing options...
genericnumber1 Posted December 20, 2008 Share Posted December 20, 2008 what? Link to comment https://forums.phpfreaks.com/topic/137796-php-automatic-updates/#findComment-720218 Share on other sites More sharing options...
HektoR Posted December 20, 2008 Author Share Posted December 20, 2008 i want to php get and show last row from mysql database Link to comment https://forums.phpfreaks.com/topic/137796-php-automatic-updates/#findComment-720220 Share on other sites More sharing options...
genericnumber1 Posted December 20, 2008 Share Posted December 20, 2008 Use a query of... SELECT * FROM table ORDER BY thetimecolumn DESC LIMIT 1 Google for php/mysql data retrieval, php mysql, mysql queries, and check the code snippets repository in this forum to see more information of how to do this. You might also check the php.net manual page for mysql_query(). Link to comment https://forums.phpfreaks.com/topic/137796-php-automatic-updates/#findComment-720221 Share on other sites More sharing options...
HektoR Posted December 20, 2008 Author Share Posted December 20, 2008 and does this code work when i have 10000 row in my mysql database? or more? Link to comment https://forums.phpfreaks.com/topic/137796-php-automatic-updates/#findComment-720222 Share on other sites More sharing options...
HektoR Posted December 20, 2008 Author Share Posted December 20, 2008 this code does not work. it show only first row and i want last. Link to comment https://forums.phpfreaks.com/topic/137796-php-automatic-updates/#findComment-720224 Share on other sites More sharing options...
genericnumber1 Posted December 20, 2008 Share Posted December 20, 2008 Then do ASC instead of DESC Link to comment https://forums.phpfreaks.com/topic/137796-php-automatic-updates/#findComment-720416 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.