I’ve written a query and been able to access data in a Chrono-connectivity database filled with data input from website users. Results seemed to display OK until I noticed that new entries weren’t being displayed as they are submitted after the display page was refreshed. It didn’t occur to me that the connection could be anything but dynamic and the query would present all data in the db. When I checked the next day, the form input from the previous day was present. Is there something in the connection or query code that may be causing this delay?
Any thoughts you may share are appreciated.
Thanks, John
Any thoughts you may share are appreciated.
Thanks, John
include_once("configuration.php");
$jconf = new JConfig();
$myconn = mysql_connect($jconf->host,$jconf->user,$jconf->password) or die(mysql_error());
mysql_select_db($jconf->db,$myconn);
$myquery = "select name, location, recordtime from ".$jconf->myjoomla_db."jos_chronoforms_my_form_db order by recordtime DESC";
$result = mysql_query($myquery,$myconn) or die (mysql_error());
$sql = mysql_fetch_array($result);
