php mysqli help, first line in DB not being returned?

Question

Here is my code

     <?php require_once 'connect.php';

                    $sql = "SELECT * FROM `db-pages`";
                    $result = $mysqli->query($sql) or die($mysqli->error.__LINE__);
                        while ($row = $result->fetch_assoc()) {
   echo($row['pagetitle'].' - To edit this page <a href="editpage.php?id='.$row['id'].'">click here</a><br>');
 }  
                    }
      ?>

I've added a couple more rows to the Database and it's returning them all, apart from id=1 in the DB. Any idea why?

try to check count of returned rows before you do the while, use echo $result->num_rows; — Mohd Moe
– Mohd Moe, Commented Nov 12, 2012 at 17:03
@GBD you forgot the i in mysql. @wiiliamsongibson: how many data are there in database? — itachi
– itachi, Commented Nov 12, 2012 at 17:03
You can find and answer to a similar question [here][1] [1]: stackoverflow.com/questions/2285600/… — VicoMan
– VicoMan, Commented Nov 12, 2012 at 17:07

Tiit · Accepted Answer · 2012-11-12 17:05:53Z

1

try it like this:

 while ($row = $result->fetch_assoc()) {
   echo($row['pagetitle'].' - To edit this page <a href="editpage.php?id='.$row['id'].'">click here</a><br>');
 }

answered Nov 12, 2012 at 17:05

Tiit

5304 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

williamsongibson Over a year ago

Thanks, I've added your example above and more than 2 rows in the DB. It is working, but the first row id=1 is never displayed. Any idea why?

Tiit Over a year ago

what if you printed the mysqli_fetch_assoc(), what is shown? print_r(mysqli_fetch_assoc());

John · Accepted Answer · 2012-11-13 04:56:39Z

1

Double check the title and ensure it's got nothing that will affect php out-putting it.

Also escape all of your DB output using htmlentities, it makes for good practise in the event someone gets creative.

answered Nov 13, 2012 at 4:56

John

874 bronze badges

Collectives™ on Stack Overflow

php mysqli help, first line in DB not being returned?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related