Professional Web Applications Themes

PHP - MySQL Query... - PHP Development

Hello all... I'm embarrassed by this one... I think it should work but it isn't... $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 ...

  1. #1

    Default PHP - MySQL Query...

    Hello all...

    I'm embarrassed by this one... I think it should work but it isn't...

    $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?

    Thanks,

    SJK
    **


    Steven Kallstrom Guest

  2. #2

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

    Steven Kallstrom wrote:
    > Hello all...
    >
    > I'm embarrassed by this one... I think it should work but it isn't...
    >
    > $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);
    Try this instead;
    $result = mysql_query($query) or die("Query died: " . mysql_error());

    Cheers!

    -Michael
    >
    > 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?
    >
    > Thanks,
    >
    > SJK
    > **
    >
    >
    >

    Michael A Smith Guest

  3. #3

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

    * Thus wrote Steven Kallstrom (stevenkallstrominsightbb.com):
    > Hello all...
    >
    > I'm embarrassed by this one... I think it should work but it isn't...
    >
    > $query = 'SELECT * FROM cities';
    > $result = mysql_query($query);
    >
    > while ($row = mysql_fetch_row($result)) {
    >
    > getting this error:
    >
    > *Warning*: mysql_fetch_row(): supplied argument is not a valid MySQL
    > result resource in...
    Hmm.. I thought I had replied to this.. anyway, check the output of
    mysql_error() after your mysql_query(), mysql_select_db() and
    mysql_connect() to see who is cause the query to fail. The sql
    syntax appears to be correct.

    Curt
    --
    "I used to think I was indecisive, but now I'm not so sure."
    Curt Zirzow Guest

Similar Threads

  1. Is this a MySQL Query bug?
    By Carl Anatorian in forum MySQL
    Replies: 4
    Last Post: June 13th, 07:29 AM
  2. Replies: 0
    Last Post: November 4th, 05:38 PM
  3. Mysql query
    By Albert Ahtenberg in forum PHP Development
    Replies: 20
    Last Post: September 3rd, 08:51 AM
  4. Query log for mySQL?
    By Kevin Thorpe in forum PHP Development
    Replies: 3
    Last Post: November 27th, 05:10 PM
  5. mysql/php query
    By aaron in forum PHP Development
    Replies: 13
    Last Post: November 17th, 11:18 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