Member Avatar

Hi All, I want to select rows from dynamic created tables i.e we have tables like web_analytics_mm_yy(ex: web_analytics_06_13, web_analytics_05_13, web_analytics_04_13 and so on) web_analytics -> table name mm_yy -> month_year. I know this can be acheived in PHP by using for loop { // CONSTRUCTING SQL STATEMENT USING // UNION ALL } but is there any thing that can be done using mysql Query only? and i want to know what is the best method to fetch data from multiple tables which are created dynamic. Thx ppl

Member Avatar
0
22
Member Avatar

Hi, I am very new to PHP, and i need small help. i need to fetch data on selection box onchange event and then apply pagination to the results. i have done etching data with ajax and when i tried applying pagination i am unable to load parent page of the ajax page. here is the code follows.please help me to solve this problem. <?php include('auth.php'); $id=$_GET["id"]; //for pagination define('MAX_REC_PER_PAGE', 10); $qry ="SELECT count(*) from user_info,time_data where user_info.user_id = time_data.user_id and manager_id= '$timeapp_id' "; if($id != 0){ $qry = $qry." and user_info.user_id = '$id'"; } $results = mysql_query($qry); list($total) = …

Member Avatar
0
9
Member Avatar

I use this function http://goo.gl/Luxkx to create Fetching Posts by Category with jQuery , but the problem is that I need pagination. For example, I have in some categories more than 10 posts. The first 6 posts show up okay, but I need pagination to show the rest. You can see how it works now on my site: http://sentisoft.com/bwb/ By the way, for pagination I use code from plugin named WP-PageNavi: <div class="navigation"> <?php include('includes/wp-pagenavi.php'); if(function_exists('wp_pagenavi')) { wp_pagenavi(); } ?> </div>

Member Avatar
0
13
Member Avatar

Data fetching I am creating a website and I am facing trouble to fetch URL data .How can i fetch URL data with the help of PHP and AJAX.And i need to fetch the data fast as facebook or the earlier version of Digg did it.If there is a code snippet regarding my query please help me. Thanks in advance.

Member Avatar
0
2
Member Avatar

Hi, I am having a code which fetches say 200 records,after 6 records i got an exception..So after my exception is caught in catch block i have 2 call a method which can help continuing the exception starting from the 7th object. Can anyone help with some piece of code that can help me do this??? Hoping for a favorable response Regards Arathy Nair

Member Avatar
0
4

The End.