what is wrong with this mysql code

Question

$db_user="root";
$db_host="localhost";
$db_password="root";
$db_name = "fayer";
$conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn't connect to server");

// perform query
$query = 'SELECT * FROM posts';
$result = mysqli_query($conn, $query) or die ("Couldn't execute query.");

// use returned data
while($row = mysqli_fetch_assoc($result))
{
    echo $row['title'];
}

I get in the browser: "mysql problem".

Help!

---

UPDATE

I have echoed the query. It shows SELECT * FROM posts and when I query manually it gets the rows.

I think it has something to do with mysqli. I think i should use mysql. Do u think I have incompatibility problems with mysqli?

Answer 1

You have empty WHERE clause. Remove it or add a search condition.

Answer 2

Change

$result = mysqli_query($conn, $query) or die ("Couldn't execute query.");

to

$result = mysqli_query($conn, $query) or die ("Couldn't execute query because: " . mysqli_error());

and you will know why the query is failing. Rule of thumb: Whenever you have a failed query, print it out and run it through phpmyadmin or some other raw-query executor and you will discover very quickly what the problem is.

Answer 3

i have echoed it. it shows SELECT * FROM posts. and when i query manually it gets the rows.

i think it has something to do with mysqli. i think i should use mysql. do u think i have incompatibility problems with mysqli?

Answer 4

I have solved it myself...do you really want to hear the answer?

I had one row in table "posts" and under column "title" i wrote "mysql problem".

so it echoed "mysql problem" and i thought it was a problem! hahahahha. im really laughing my ass off here!! isnt this funny?