Most of what you need is located into query_factory.php 1. standard way to browse extracted records ( no pagination): $sql= “YOUR SQL STATEMENT” $result_list = $db->Execute($sql) while (!$result_list->EOF) { …………….. YOUR PHP / HTML CODE …………….. $result_list->MoveNext(); } Eventually set …
Category Archives: MySQL Server
Define pages part 2, database and admin – ZenCart
Data about Zencart are stored in two tables : YOURPRFIX_configuration_grp YOURPRFIX_configuration For Define page the ID from YOURPRFIX_configuration_grp table is 25 Into admin area the page used to change/save parameters into configuration tables from database is /admin/configuration.php In 1.3.8a it …
MySQL- server time response
Even MySQL accept a decent set of SQL (standard) comands, do not implement in production any query before testing and checking twise the production server response time. Do you get more than 0.1000 sec then you may try to optimise. …




(8 votes, average: 4.88 out of 5, rated)