Professional Web Applications Themes

[PHP] PHP - MySQL Query... - PHP Development

[snip] $dbh = mysql_connect("localhost", "login", "password") or die('cannot connect to the database because: ' . mysql_error()); mysql_select_db("database"); $query = 'SELECT * FROM cities'; $result = mysql_query($query); while ($row = mysql_fetch_row($result)) { echo ('<tr> <td class="city">' . $row[0] . ', ' . $row[1] . '</td> <td>' . $row[2] . '</td> <td>' . $row[3] . "</td> </tr>\n"); } getting this error: *Warning*: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in... so... is the problem with the $query? I don't see anything wrong (assuming my login and database selection is correct) what are the common errors here? [/snip] mysql_query needs ...

  1. #1

    Default RE: [PHP] PHP - MySQL Query...

    [snip]
    $dbh = mysql_connect("localhost", "login", "password") or
    die('cannot connect to the database because: ' . mysql_error());
    mysql_select_db("database");

    $query = 'SELECT * FROM cities';
    $result = mysql_query($query);

    while ($row = mysql_fetch_row($result)) {
    echo ('<tr> <td class="city">' . $row[0] . ', ' . $row[1] . '</td>
    <td>' . $row[2] . '</td> <td>' . $row[3] . "</td> </tr>\n"); }

    getting this error:

    *Warning*: mysql_fetch_row(): supplied argument is not a valid MySQL
    result resource in...

    so... is the problem with the $query?
    I don't see anything wrong (assuming my login and database selection is
    correct)
    what are the common errors here?
    [/snip]

    mysql_query needs both the query variable and the connection
    variable....
    mysql_query($query, $dbh);

    HTH!
    Jay Blanchard Guest

  2. #2

    Default Re: [PHP] PHP - MySQL Query...

    This is not true, the resource link identifier is optional! If unspecified,
    the last opened link is used. My suggestion is to check the results of
    mysql_error() for more information on the failed query.

    HTH,

    Ivo

    "Jay Blanchard" <jay.blanchardniicommunications.com> wrote in message
    news:C8F323573C030A448F3E5A2B6FE2070B0101FA81neme sis...
    [snip]
    $dbh = mysql_connect("localhost", "login", "password") or
    die('cannot connect to the database because: ' . mysql_error());
    mysql_select_db("database");

    $query = 'SELECT * FROM cities';
    $result = mysql_query($query);

    while ($row = mysql_fetch_row($result)) {
    echo ('<tr> <td class="city">' . $row[0] . ', ' . $row[1] . '</td>
    <td>' . $row[2] . '</td> <td>' . $row[3] . "</td> </tr>\n"); }

    getting this error:

    *Warning*: mysql_fetch_row(): supplied argument is not a valid MySQL
    result resource in...

    so... is the problem with the $query?
    I don't see anything wrong (assuming my login and database selection is
    correct)
    what are the common errors here?
    [/snip]

    mysql_query needs both the query variable and the connection
    variable....
    mysql_query($query, $dbh);

    HTH!


    Ivo Fokkema Guest

  3. #3

    Default Re: [PHP] PHP - MySQL Query...

    I'm used to do like this:

    $query = 'SELECT * FROM cities';
    $result = mysql_query($query);
    if($row = mysql_fetch_array($result))
    do {
    echo ('<tr> <td class="city">' . $row[0] . ', ' . $row[1] . '</td>
    <td>' . $row[2] . '</td> <td>' . $row[3] . "</td> </tr>\n");
    } while ($row = mysql_fetch_array($result));


    -------------------------------------------------------


    "Jay Blanchard" <jay.blanchardniicommunications.com> wrote in message
    news:C8F323573C030A448F3E5A2B6FE2070B0101FA81neme sis...
    [snip]
    $dbh = mysql_connect("localhost", "login", "password") or
    die('cannot connect to the database because: ' . mysql_error());
    mysql_select_db("database");

    $query = 'SELECT * FROM cities';
    $result = mysql_query($query);

    while ($row = mysql_fetch_row($result)) {
    echo ('<tr> <td class="city">' . $row[0] . ', ' . $row[1] . '</td>
    <td>' . $row[2] . '</td> <td>' . $row[3] . "</td> </tr>\n"); }

    getting this error:

    *Warning*: mysql_fetch_row(): supplied argument is not a valid MySQL
    result resource in...

    so... is the problem with the $query?
    I don't see anything wrong (assuming my login and database selection is
    correct)
    what are the common errors here?
    [/snip]

    mysql_query needs both the query variable and the connection
    variable....
    mysql_query($query, $dbh);

    HTH!


    Marcus Edvardsson Guest

  4. #4

    Default RE: [PHP] PHP - MySQL Query...

    [snip]
    This is not true, the resource link identifier is optional! If
    unspecified,
    the last opened link is used. My suggestion is to check the results of
    mysql_error() for more information on the failed query.
    [/snip]

    You are right, of course...my sleepy brain just glanced at the code and
    fired off a reply. I always test queries with the following block;

    if(!($result = mysql_query($query, $connection))){
    echo "A query error has occured: " . mysql_error() . "\n";
    exit();
    }
    Jay Blanchard Guest

Similar Threads

  1. Replies: 0
    Last Post: November 4th, 05:38 PM
  2. Mysql query
    By Albert Ahtenberg in forum PHP Development
    Replies: 20
    Last Post: September 3rd, 08:51 AM
  3. Query log for mySQL?
    By Kevin Thorpe in forum PHP Development
    Replies: 3
    Last Post: November 27th, 05:10 PM
  4. mysql/php query
    By aaron in forum PHP Development
    Replies: 13
    Last Post: November 17th, 11:18 PM
  5. PHP - MySQL Query...
    By Steven Kallstrom in forum PHP Development
    Replies: 2
    Last Post: August 14th, 02:22 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139