Mysql Query Returns "array"

[Hummingbird]

For some reason which I obviously don't know, these two queries do not return any variables.

The $zone variable for the first query is defined in the address, and the $id variable is defined in the included header.php. I have tested the two variables with the print function to ensure they were set, they are.

I have tried hard coding the variables into the queries, still nothing was being selected. Then I tried copying the SELECT syntax to MyPHPadmin, that ended up working fine. When I try to print the results with print_r it returns an error as if its a variable and when I try doing it with print it returns 'array'.

Other than those signs there are no actual errors being output. Any more questions feel free to ask. Thanks in advance.

<?php
/***************************************************************************
                             world.php
                             -------------------
    begin                : Fri August 12 2005
    copyright            : (C) 2005 Tyler Roberts
    email                : [e-mail]

$Id: codingstandards.htm,v 1.0 2005/08/12 natec Exp $

 ***************************************************************************/
/***************************************************************************
 *
 *   This program is property of Tyler Roberts.  Any usage on a web
 *   site, other than http://www.t-robs.com/ is again copyright law.
 *   Violators will be dealt with accordingly.  Subject to change!
 *
 ***************************************************************************/

$login_req = 1;
$title = 'World';
$menu = 'world';

require ("./includes/header.php"); 

// CHECK IF LOCATION EXISTS 
$location_query = mysql_query (" 
                    SELECT * 
                    FROM `zones` 
                    WHERE `name` = '$zone' 
                    LIMIT 0,1") or die (mysql_error ()); 
$location = mysql_fetch_array ($location_query); 

// CHECK USER'S LOCATION 
$get_place_query = mysql_query (" 
                    SELECT `place`, `nation`, `currency` 
                    FROM `users` 
                    WHERE `id` = '$id' 
                    LIMIT 0,1") or die (mysql_error ()); 
$get_place = mysql_fetch_array ($get_place_query);

[thorpe]

mysql_fetch_array() returns, you guessed it, an array. this array contains the current record. try this and see what you get.

$location = mysql_fetch_array ($location_query);
foreach ($location as $loc) {
  echo $loc.'<br />';
}

also, if your expecting more than one record, you need to loop through your result resource. eg;

while ($location = mysql_fetch_array ($location_query)) {
  foreach ($location as $loc) {
    echo $loc.'<br />';
  }
}

[sapoxgn]

this is a simple example how to use this array:

$get_place = mysql_fetch_array ($get_place_query); 

foreach($get_place as $data) {
    echo "Place: " . $data['place'] . "<br />";
    echo "Nation: " . $data['nation'] . "<br />";
    echo "Currency: " . $data['currency'] . "<br />";
}

just try it out 😉

Or maybe better 😉

while($get_place = mysql_fetch_array ($get_place_query)) {
    echo "Place: " . $get_place['place'] . "<br />";
    echo "Nation: " . $get_place['nation'] . "<br />";
    echo "Currency: " . $get_place['currency'] . "<br />";
}