Getting Resource ID #6 Result

mcubedma

I'm hoping someone can tell me why I am getting Resource ID #6 as part of my php script results. Can someone please tell me what this means? The results are coming out as:

JoeSmithFirestoneMDResource id #6

Here is the php code:

<html>
<head>
  <title>LOC Member Search</title>
</head>
<body>
<h>Search By Member Name</h>

<form method="post" action="<?php echo $PHP_SELF;?>">

Enter All or Part of Last Name:&nbsp&nbsp&nbsp<input type="text" name="l_name" value=""><br>
Enter All or Part of First Name:&nbsp&nbsp&nbsp<input type="text" name="f_name" value="">
<br><br>
<p>Search By City and/or State</p>
<?php
//connect to database

$link = mysql_pconnect('localhost', 'xxxxx', 'xxxxx');
if (!$link) {die('Could not connect: ' . mysql_error());}
mysql_select_db("loc", $link);


// put city data in dropdown menu
  $city_res = mysql_query("SELECT city FROM address ORDER BY city")
      or die("Invalid query: " . mysql_query());
  echo '<label>Select City:&nbsp&nbsp</label>';
  echo '<select id="city" name="city">';
  echo '<option value=""> ------------ </option>';
  while ($row = mysql_fetch_assoc($city_res)) {
     $city = $row['city']; 
     echo "<option value='$city'>$city</option>";
  }
  echo '</select>';
  echo '&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp';

// put state data in dropdown menu
  $state_res = mysql_query("SELECT state FROM address ORDER BY state")
      or die("Invalid query: " . mysql_query());
  echo '<label>Select State:&nbsp</label>';
  echo '<select id="state" name="state">';
  echo '<option value=""> ------------ </option>';
  while ($row = mysql_fetch_assoc($state_res)) {
     $state = $row['state']; 
     echo "<option value='$state'>$state</option>";
  }
  echo '</select>';

?>
</select><p><p>
<input name="submit" value="Submit" type="submit">
</form>

<?php
//connect to database

$link = mysql_pconnect('localhost', 'xxxxx', 'xxxxx');
if (!$link) {die('Could not connect: ' . mysql_error());}
mysql_select_db("loc", $link);

$f_name = $_POST["f_name"];
$l_name = $_POST["l_name"];
$city = $_POST["city"];
$state = $_POST["state"];
if (!isset($_POST['submit'])) { // if page is not submitted to itself echo the form
} else {
echo $f_name;
echo $l_name;
echo $city;
echo $state;
$member_record = mysql_query("SELECT * from member_name where l_name = 'l_name'")
			   or die("Invalid query: " . mysql_query());
echo $member_record;
}

?> 

</body>
</html>

jrolands

right at the end of your php code you hav "echo $member_record;"
because the variable $member_record is a return of the mysql_query() function you won't get a "readable" answer. instead you get a
resource.

TheDefender

To expand on jrolands' reply, if you want to output the result of your query, you will need to use something like [man]mysql_fetch_array/man (if you're expecting multiple results) or [man]mysql_fetch_row/man (if you're expecting a single result).

mcubedma

Thanks jrolands and The Defender.

The script is now working and I am getting results, but I am also getting Warning: mysql_fetch_array(): 6 is not a valid MySQL result resource in C:\wamp\www\testphp.php on line 70. I highlighted Line 70 and the code around it in red, below.

Can you tell me what that might mean?

Here is the new script:

<html>
<head>
  <title>LOC Member Search</title>
</head>
<body>
<h>Search By Member Name</h>

<form method="post" action="<?php echo $PHP_SELF;?>">

Enter All or Part of Last Name:&nbsp&nbsp&nbsp<input type="text" name="l_name" value=""><br>
Enter All or Part of First Name:&nbsp&nbsp&nbsp<input type="text" name="f_name" value="">
<br><br>
<p>Search By City and/or State</p>
<?php
//connect to database

  $link = mysql_pconnect('localhost', 'xxxxx', 'xxxxx');
if (!$link) {die('Could not connect: ' . mysql_error());}
mysql_select_db("loc", $link);

// put city data in dropdown menu
  $city_res = mysql_query("SELECT city FROM address ORDER BY city")
      or die("Invalid query: " . mysql_query());
  echo '<label>Select City:&nbsp&nbsp</label>';
  echo '<select id="city" name="city">';
  echo '<option value=""> ------------ </option>';
  while ($row = mysql_fetch_assoc($city_res)) {
     $city = $row['city']; 
     echo "<option value='$city'>$city</option>";
  }
  echo '</select>';
  echo '&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp';

// put state data in dropdown menu
  $state_res = mysql_query("SELECT state FROM address ORDER BY state")
      or die("Invalid query: " . mysql_query());
  echo '<label>Select State:&nbsp</label>';
  echo '<select id="state" name="state">';
  echo '<option value=""> ------------ </option>';
  while ($row = mysql_fetch_assoc($state_res)) {
     $state = $row['state']; 
     echo "<option value='$state'>$state</option>";
  }
  echo '</select>';

?>
</select><p><p>
<input name="submit" value="Submit" type="submit">
</form>

<?php
//connect to database

$link = mysql_pconnect('localhost', 'xxxxx', 'xxxxx');
if (!$link) {die('Could not connect: ' . mysql_error());}
mysql_select_db("loc", $link);

$in_lname = $_POST["l_name"];

$get_member_sql = "SELECT mbr_id, f_name, l_name from member_name where l_name like '%$in_lname%'";
$get_member_res = mysql_query($get_member_sql, $link)
			   or die("Invalid query: " . mysql_error());

if (mysql_num_rows($get_member_res) >0) {

[COLOR="Red"]while ($member_info = mysql_fetch_array($get_member_res))
{$mbr_id = ($member_info['mbr_id']);
$f_name = ($member_info['f_name']);
$l_name = ($member_info['l_name']);
$display_member .= "<p>$mbr_id<br>$f_name<br>$l_name</p>";
echo $display_member;[/COLOR]

//free result 
mysql_free_result($get_member_res); 
}

}
?> 
</body>
</html>

laserlight

Typically that is a strong hint that:
a) The database connection failed, or
b) No database was selected, or
c) The SQL query is incorrect

In this case a and b cannot be the case since the other queries succeeded. Yet c does not seem likely since you have a die("Invalid query: " . mysql_query()) to detect it, and yet that die() was not triggered.

In short, I have no idea. I suggest that you try and find the smallest and simplest script that demonstrates the problem.

TheDefender

Also something to help out with your debugging...

Echo the $get_member_sql string out right after you define it to make sure your query is what you expect it to be.

I think you'll find this SQL statement is the source of your angst...