Activity Stream

Filter
Sort By Time Show
Recent Recent Popular Popular Anytime Anytime Last 24 Hours Last 24 Hours Last 7 Days Last 7 Days Last 30 Days Last 30 Days All All Photos Photos Forum Forums Blog Blogs
Filter by: Last 7 Days Clear All
  • ianhaney's Avatar
    Today, 04:41 PM
    ianhaney replied to a thread paginate search results in PHP
    Sorry I did not mean lost all the records, I meant it displays all the records on one page insteading of paginate them to 5 per page, sorry I can't...
    19 replies | 162 view(s)
  • styxlawyer's Avatar
    Today, 04:32 PM
    styxlawyer replied to a thread paginate search results in PHP
    Without access to your live page, I can only guess what's going on.
    19 replies | 162 view(s)
  • ianhaney's Avatar
    Today, 04:19 PM
    ianhaney replied to a thread paginate search results in PHP
    This worked but lost all the results, it does not paginate them to 5 per page for example?
    19 replies | 162 view(s)
  • styxlawyer's Avatar
    Today, 03:46 PM
    styxlawyer replied to a thread paginate search results in PHP
    I've had a scour through Google and it looks as though OFFSET on its own is invalid. The only way to get all the records from a particular start...
    19 replies | 162 view(s)
  • ianhaney's Avatar
    Today, 03:16 PM
    ianhaney replied to a thread paginate search results in PHP
    I tried the first way and got the following error Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE: Syntax error or access...
    19 replies | 162 view(s)
  • styxlawyer's Avatar
    Today, 03:09 PM
    styxlawyer replied to a thread paginate search results in PHP
    First try: $result = $db->prepare("SELECT * FROM purchased_software WHERE sales_month BETWEEN :a AND :b ORDER BY id OFFSET $start_from+1"); ...
    19 replies | 162 view(s)
  • ianhaney's Avatar
    Today, 02:51 PM
    ianhaney replied to a thread paginate search results in PHP
    Sorry I modified the query and now got this error Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE: Syntax error or access...
    19 replies | 162 view(s)
  • styxlawyer's Avatar
    Today, 02:24 PM
    styxlawyer replied to a thread paginate search results in PHP
    Hmmm, it doesn't seem to like an OFFSET of 0. Try this in your query: OFFSET $start_from+1
    19 replies | 162 view(s)
  • ianhaney's Avatar
    Today, 02:19 PM
    ianhaney replied to a thread paginate search results in PHP
    I just modified the query but gave the error below when I clicked search Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE:...
    19 replies | 162 view(s)
  • styxlawyer's Avatar
    Today, 12:24 PM
    styxlawyer replied to a thread paginate search results in PHP
    You have set a limit in your search query on line 42: $result = $db->prepare("SELECT * FROM purchased_software WHERE sales_month BETWEEN...
    19 replies | 162 view(s)
  • ianhaney's Avatar
    Today, 11:35 AM
    ianhaney replied to a thread paginate search results in PHP
    Hi Can you please check the modified coding, I used the alternative method you suggested and is paginating the search results to 5 per page but...
    19 replies | 162 view(s)
  • jscheuer1's Avatar
    Today, 06:43 AM
    Right. We are not strict like some forums are. However - just something to bear in mind. When someone posts a question, they have a reasonable...
    23 replies | 745 view(s)
  • mlegg's Avatar
    Today, 01:42 AM
    the video feature may be helpful for you and your customers too
    2 replies | 60 view(s)
  • mlegg's Avatar
    Today, 01:36 AM
    I would think that using Hangouts from Google would be easier. I think most people all over the world use Gmail. I have a Galaxy android phone and it...
    2 replies | 60 view(s)
  • ianhaney's Avatar
    Yesterday, 11:36 PM
    ianhaney replied to a thread paginate search results in PHP
    Thank you really appreciate it, will try that first thing in the morning and post a update if it works or not, thank you again
    19 replies | 162 view(s)
  • styxlawyer's Avatar
    Yesterday, 11:23 PM
    styxlawyer replied to a thread paginate search results in PHP
    Two things spring to mind. Firstly, mysqli_num_rows() requires a query result as a parameter (see here) and $data is not a mysqli result but an...
    19 replies | 162 view(s)
  • Rattar's Avatar
    Yesterday, 09:27 PM
    Hey All, I am developing a new programming language: *Juliar * It's a functional language that focuses on the idea of recursion and that you...
    0 replies | 40 view(s)
  • ianhaney's Avatar
    Yesterday, 09:19 PM
    ianhaney replied to a thread paginate search results in PHP
    Oh right ok, I have added below the modified code <?php ini_set('display_startup_errors',1); ini_set('display_errors',1);...
    19 replies | 162 view(s)
  • styxlawyer's Avatar
    Yesterday, 09:09 PM
    styxlawyer replied to a thread paginate search results in PHP
    It was only a possible error. The page you have quoted returns a 404 error, so nobody can see your modified code.
    19 replies | 162 view(s)
  • ianhaney's Avatar
    Yesterday, 08:38 PM
    ianhaney replied to a thread paginate search results in PHP
    Hi I have updated the script now to what you said as quoted here but got the following error Warning: mysqli_num_rows() expects parameter 1 to...
    19 replies | 162 view(s)
  • theremotedr's Avatar
    Yesterday, 08:01 PM
    http://www.theremotedoctor.co.uk/index.html Take the above page as an example. At the bottom of the page you will see social media icons. The...
    2 replies | 60 view(s)
  • theremotedr's Avatar
    Yesterday, 07:50 PM
    Thanks. Playing around with Firebug I found the part I needed to alter. Having said that it didn't look to great so opted for white bar removed...
    6 replies | 143 view(s)
  • styxlawyer's Avatar
    Yesterday, 05:18 PM
    styxlawyer replied to a thread paginate search results in PHP
    You appear to have included "connect.php" twice. The first is on line 7 and again on line 143. That could be the reason that you cannot connect to...
    19 replies | 162 view(s)
  • bojangles's Avatar
    Yesterday, 04:59 PM
    Perfect! Does the job great!
    2 replies | 67 view(s)
More Activity