why isn't my php query working?

Question

I've looked everywhere and have no idea why my query wont work!

<table>
<?php
    $con = mysqli_connect("127.0.0.1","root","pass","database");

    $query = mysqli_query("SELECT role FROM dicetrack");
    while($row = mysqli_fetch_array($query))
    {
        echo "<tr><td>" + $row["role"] + "</td></tr>";
    }

    mysqli_close($con);
?>
</table>

Im trying to record dice roles from different users. Everything seems to work fine but when i test the query in any way possible, it comes out to fail. Does anyone know what i did wrong? I've checked all spelling like 10 times and still cant find anything. Thanks in advance.

I doubt you want to do math here `echo "" + $row["role"] + "";`, or do you? ;-) — Funk Forty Niner, Jun 16 '14 at 20:12

score 2 · Accepted Answer · edited May 23 '17 at 12:13

2

mysqli_query() takes two parameters: the mysqli connection and your query:

$query = mysqli_query("SELECT role FROM dicetrack");

should be:

$query = mysqli_query($con, "SELECT role FROM dicetrack");

You need to enable error reporting as PHP would throw an error explaining this to you.

edited May 23 '17 at 12:13

Community

1
1

answered Jun 16 '14 at 20:10

John Conde

217,595
99
455
496

2

This was the first correct answer ;-) by yes... 13 seconds. I lucked out... again! – Funk Forty Niner Jun 16 '14 at 20:13
thanks, ill accept this one – Ozay34 Jun 16 '14 at 20:14

score 2 · Answer 2 · answered Jun 16 '14 at 20:10

2

$query = mysqli_query("SELECT role FROM dicetrack");

You didn't specify the connection.

$query = mysqli_query($con, "SELECT role FROM dicetrack");

Correct one.

answered Jun 16 '14 at 20:10

prq

271
2
9

wow... dont i feel dumb.... thanks – Ozay34 Jun 16 '14 at 20:13

why isn't my php query working?

2 Answers2