[Resolved] why cant i simply access data from my mysql database?

jt-developer

Hi all, I've used php and mysql quite a bit now so i know how to retrieve data from a database, but for some reason this new site I'm working on is causing a bit of grief. I'm just trying to access the country table and retrieve the correct variable in the COUNTRY_DESC column which sounds straight forward but the code I'm using is bringing up errors. any ideas? heres the code as it is...

$get_query = mysql_query("SELECT * FROM country WHERE COUNTRY_CODE = 'A0';");
$get_result = mysql_fetch_array($get_query);
$country_name = $get_result['COUNTRY_DESC'];

...the databaseis being accessed fine, but i get the "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource" error

cheers all

Installer

What do you get form this code:

$get_query = mysql_query("SELECT * FROM country WHERE COUNTRY_CODE = 'A0';");
if ($get_query === false) {
    echo 'mysql_query() failed';
} else {
    echo 'mysql_query() succeeded';
}

Installer

Also, from the manual:

Note: The query string should not end with a semicolon.

jt-developer

i get mysql_query() failed;

also tried getting rid of the semi colons, no diff

Installer

Then probably your database connection is being lost by the time you execute the query. Try reconnecting again just before.

stfuji

I advocate testing all the steps in this process to make sure you have a clean connection etc...

$get_query = mysql_query("SELECT * FROM country WHERE COUNTRY_CODE = 'A0';") or 
     die("Could not query db" . mysql_error());

echo mysql_num_rows($get_query);  //  Make sure you query holds information and is not an empty rowset...

$get_result = mysql_fetch_array($get_query) or
     die("Couldn't get array from query" . mysql_error()); 

$country_name = $get_result['COUNTRY_DESC'];

Depending on where you are actually having an error will help identify how to fix it. I suspect you are not returning anything from your query perhaps the Country_Code field is typed incorrectly or is of a numeric type etc...

HTH

Geoffrey