trouble retrieving data from sql database with php

Question

I'm pretty new to php, and I'm teaching myself. I've looked at a few different resources, and the php script I have now doesn't return any critical errors when executed, but its not returning the data from the table.

 <?php

$connect = mysqli_connect("localhost","*","*","*");

if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$comments = "SELECT * FROM commentstable";

$rs = mysqli_query($connect,$comments);

$fetch = mysqli_fetch_array($rs);

while($fetch = mysqli_fetch_array($rs)) {
    echo $fetch['comments'];

    }
echo $fetch;

mysqli_close($connect);

echo "hello";

?>

change $rs = mysqli_query($connect,$comments); to $rs = mysqli_query($connect,$comments) or die(mysqli_error($connect)); — Iłya Bursov
– Iłya Bursov, Commented Nov 6, 2013 at 21:43

mmr · Accepted Answer · 2013-11-07 01:07:57Z

1

you have double entry:

$fetch = mysqli_fetch_array($rs); //<--- remove this as you are calling it again in the while loop

while($fetch = mysqli_fetch_array($rs)) {    
    echo $fetch['comments'];

}

answered Nov 7, 2013 at 1:07

mmr

51612 silver badges30 bronze badges

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

Comments

PKolos · Accepted Answer · 2013-11-06 22:05:40Z

0

Check this

$connect = mysqli_connect("localhost","turlough","samus1","comments");
if (mysqli_connect_errno())
{
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
else
{
    $comments = "SELECT * FROM commentstable";

    $rs = mysqli_query($connect,$comments);
    if($rs)
    {
        while($fetch = mysqli_fetch_array($rs)) {
            echo $fetch['comments'];
        }
    }
    else
    {
        // no results from query
    }

    mysqli_close($connect);

}

answered Nov 6, 2013 at 22:05

PKolos

4023 silver badges6 bronze badges

Collectives™ on Stack Overflow

trouble retrieving data from sql database with php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related