mysql_fetch_array() returns 'supplied argument is not a valid MySQL result resource'

Question

I am trying the following code:

<?php

    $link = mysql_connect('localhost', 'root', 'geheim');
    if (!$link) {
        die('Could not connect: ' . mysql_error());
    }
    echo 'Connected successfully';



    $query = "SELECT * FROM Auctions";
    $result = mysql_query($query);

    while($row = mysql_fetch_array($result, MYSQL_ASSOC))
    {
        foreach($row as $field=>$value)
        {
            echo "$field: {$value} <br />";
        }
    }
    mysql_close($link);

?>

And get this error:

Warning: mysql_fetch_array(): supplied argument is not a
    valid MySQL result resource in
    C:\Programme\EasyPHP 2.0b1\www\test.php on line 14

What am I missing?

possible duplicate of Warning: mysql_fetch_* expects parameter 1 to be resource, boolean given error — John Conde
– John Conde, Commented Jul 31, 2012 at 2:17

paxdiablo · Accepted Answer · 2008-10-31 13:38:39Z

9

You haven't selected a database - use mysql_select_db()

That would be something like:

<?php
    $link = mysql_connect('localhost', 'root', 'geheim');
    if (!$link) {
        die('Could not connect: ' . mysql_error());
    }
    echo 'Connected successfully';

    $db_selected = mysql_select_db('foo', $link);
    if (!$db_selected) {
        die ('Error selecting database: '. mysql_error());
    }
    echo 'Using database successfully';

    $query = "SELECT * FROM Auctions";
    $result = mysql_query($query);
    while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
        foreach($row as $field=>$value) {
            echo "$field: {$value} <br />";
        }
    }
    mysql_close($link);
?>

edited Oct 31, 2008 at 13:38

paxdiablo

888k243 gold badges1.6k silver badges2k bronze badges

answered Oct 31, 2008 at 13:01

Greg

323k55 gold badges378 silver badges338 bronze badges

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

Comments

Community · Accepted Answer · 2023-11-17 20:08:53Z

2

Your MySQL query possibly does not match any rows in the database.

Check the return value of mysql_query(), which returns "resource" on success and "false" on failure.

$query = "SELECT * FROM Auctions"; 
$result = mysql_query($query);

if ($result !== false) {
    while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { 
        foreach ($row as $field=>$value) { 
            echo $field . ':' . $value
        }
    }
} else {
    // query returned 0 rows
}

As others also suggested, you can use mysql_error() to look if the query returns any mySQL errors

edited Nov 17, 2023 at 20:08

CommunityBot

11 silver badge

answered Oct 31, 2008 at 12:57

Aron Rotteveel

83.4k17 gold badges106 silver badges129 bronze badges

1 Comment

KernelM Over a year ago

mysql_query only returns false on an actual error. An empty result set is not an error.

andy.gurin · Accepted Answer · 2008-10-31 12:57:34Z

1

$query = "SELECT * FROM Auctions";

$result = mysql_query($query) or die(mysql_error());

so you'll see the error

answered Oct 31, 2008 at 12:57

andy.gurin

3,9141 gold badge25 silver badges14 bronze badges

Comments

MattBelanger · Accepted Answer · 2008-10-31 12:56:28Z

0

Are you getting anything returned? If no results are found, mysql_query returns FALSE.

Check that before running fetch_array.

answered Oct 31, 2008 at 12:56

MattBelanger

5,3586 gold badges39 silver badges35 bronze badges

1 Comment

Lucas Oman Over a year ago

If no results are found, it still returns a resource, but there are no results in it. mysql_query() only returns false if there is an error.

Collectives™ on Stack Overflow

mysql_fetch_array() returns 'supplied argument is not a valid MySQL result resource'

4 Answers 4

Comments

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related