Getting unfamiliar MySQL error when trying to get data through simple .php file

Question

Possible Duplicate:
mysql_fetch_array() expects parameter 1 to be resource, boolean given in select

Just trying to pull some data from an existing table with existing data, where the search parameter exists.

    <html>
    <body>

    <?php
    $con = mysql_connect("localhost","***","***");
    if (!$con)
      {
      die('Could not connect: ' . mysql_error());
      }

    mysql_select_db("ubook247", $con);

    $result = mysql_query("SELECT * FROM buzz_data 
    WHERE index = '4'");

    while($row = mysql_fetch_array($result))
      {
      echo $row['buzz_img'] . " " . $row['buzz_title'];
      }

    ?>

    </body>
    </html>

error says:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\ubook247\php\display_buzz_data.php on line 16

Where line 16 is:

while($row = mysql_fetch_array($result))

Since I'm using phpMyAdmin, and am not real familiar with MySQL, here's a pic of the field setup:

Screenshot

please check `mysql_query` did return something valid, you can try to use `mysql_error` — ajreal, Aug 24 '11 at 15:17

score 2 · Accepted Answer · answered Aug 24 '11 at 16:22

2

Use index (note the backticks). Index is a reserved word for MySQL. Even better would be to rename the field but that depends on how far you are in the project....

$result = mysql_query("SELECT * FROM buzz_data WHERE `index` = 4");

answered Aug 24 '11 at 16:22

Nin

2,937
18
29

score 1 · Answer 2 · answered Aug 24 '11 at 15:17

1

That's because the following line failed to return a resource.

$result = mysql_query("SELECT * FROM buzz_data WHERE index = '4'");

More than likely this is due to an SQL error or inability to connect to the database. Probably the former since your not getting Could not connect:

Add the following line after the one above. Alternatively you can run the query in MySQL directory to ensure there are no errors.

echo mysql_error();

answered Aug 24 '11 at 15:17

Jason McCreary

69,176
21
125
169

Apparently it didn't like using 'index' as a search parameter. I tried another field and it worked. I have 'index' set to INT. Would that matter? – Adam Aug 24 '11 at 15:27
There's nothing *obviously* wrong with the syntax as far as I can tell without knowing your schema. Is `index` a column? You don't *need* the quotes for an `INT` column, but it shouldn't cause an error. Update your post with the schema for `buzz_data`. – Jason McCreary Aug 24 '11 at 15:31

Getting unfamiliar MySQL error when trying to get data through simple .php file

2 Answers2