<?php
session_start();			
include 'dbc.php';

//select which database you want to edit
mysql_select_db("users");
$search=$_POST["search"];

//get the mysql and store them in $result
//change whatevertable to the mysql table you're using
//change whatevercolumn to the column in the table you want to search
$result = mysql_query("SELECT * FROM users WHERE country LIKE '%$country%' AND state LIKE '%$state%' AND industry LIKE '%$industry%' ORDER BY full_name DESC");


//grab all the content
while($r=mysql_fetch_array($result))

{	
   //the format is $variable = $r["nameofmysqlcolumn"];
   //modify these to match your mysql table columns
  
   $full_name=$r["full_name"];
   $id=$r["id"];
   
   echo '<a href="member_profile.php" target="_blank" id=' . $r['id'] . '">'.$r['full_name'].'</a><br />';
   }
  
?>

<?php
session_start();
require 'dbc.php';
{

$id = $_GET['id'];
$user = mysql_query("SELECT * FROM user WHERE id = '$id'");
$user=mysql_fetch_assoc($user);

}

echo "<h1>User Info</h1>";

echo "<b>Username:".$user['full_name']."<br>";

echo "<br>";
  echo '<form name="backlistfrm" method="post" action="members.php">';
echo '<input type="submit" value="Back to The List">';
echo '</form>';
echo "<br>";

?>