PHP - Warning: Mysqli_fetch_array() Expects Parameter 1 To Be Mysqli_result, Boolean Given In /home/myritebook/public_html/footer.php On Line 13

Hi all,

I have received a warning message, which it still puzzles me. I suspect it might be my inner join command, which I have coded it wrongly?

Line 37 refers to this line -  if (mysqli_num_rows($data) == 1) {

Do you guys have any idea? Thanks

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in D:\inetpub\vhosts\123.com\http\viewprofile.php on line 37

Code: [Select]
<?php
  // Connect to the database
  $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

  $query = "SELECT tp.name, tp.nric, tp.gender, tp.race_id, r.race_name AS race" .
        "FROM tutor_profile AS tp " .
        "INNER JOIN race AS r USING (race_id) " .
"WHERE tutor_id = '" . $_GET['tutor_id'] . "'";
  
  $data = mysqli_query($dbc, $query);

  if (mysqli_num_rows($data) == 1) {
    // The user row was found so display the user data
    $row = mysqli_fetch_array($data);
    echo '<table>';
    if (!empty($row['name'])) {
      echo '<tr><td class="label">Name:</td><td>' . $row['name'] . '</td></tr>';
    }
    if (!empty($row['nric'])) {
      echo '<tr><td class="label">NRIC:</td><td>' . $row['nric'] . '</td></tr>';
    }
    if (!empty($row['last_name'])) {
      echo '<tr><td class="label">Last name:</td><td>' . $row['last_name'] . '</td></tr>';
    }
    if (!empty($row['gender'])) {
      echo '<tr><td class="label">Gender:</td><td>';
      if ($row['gender'] == 'M') {
        echo 'Male';
      }
      if ($row['gender'] == 'F') {
        echo 'Female';
      }
      echo '</td></tr>';
    }
if (!empty($row['race'])) {
      echo '<tr><td class="label">Race:</td><td>' . $row['race'] . '</td></tr>';
    }

    echo '</table>'; //End of Table

    echo '<p>Would you like to <a href="editprofile.php?tutor_id=' . $_GET['tutor_id'] . '">edit your 

  } // End of check for a single row of user results
  else {
    echo '<p class="error">There was a problem accessing your profile.</p>';
  }

  mysqli_close($dbc);
?>

<?php
if(isset($_POST['submit'])){
$name = $_POST['name'];
}
?>
<form method="POST" action="hist1.php">
<br />
<input type="hidden" name="name" value="<?php echo $name ?>" />
<?php
$q = mysql_query("SELECT * FROM histact1 ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question1 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5]; 
?>


<div class="Qset" id="q1"><br /><br />
<label class="items">1st Question :</label> <br />
<center>
<textarea class="textareaQ" name="question1" readonly><?php echo $question1; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad1" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />


<input type="radio" name="rad1" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />


<input type="radio" name="rad1" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt"  href="#q2"><label title="Proceed to 2nd Question">Next</label></a>
</center> 
</div> 
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>


<br /><br />
<?php
$q = mysql_query("SELECT * FROM histact1 ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question2 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5]; 
?>


<div class="Qset" id="q2"><br /><br />
<label class="items">2nd Question :</label> <br />
<center>
<textarea class="textareaQ" name="q2" readonly><?php echo $question2; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad2" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />


<input type="radio" name="rad2" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />


<input type="radio" name="rad2" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt"  href="#q1"><label title="Proceed to 1st Question">Back</label></a> &nbsp;|&nbsp; 
<a class="nxt"  href="#q3"><label title="Proceed to 3rd Question">Next</label></a>
</center> 
</div> 
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>


<br /><br />
<?php
$q = mysql_query("SELECT * FROM histact1 ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question3 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5]; 
?>


<div class="Qset" id="q3"><br /><br />
<label class="items">3rd Question :</label> <br />
<center>
<textarea class="textareaQ" name="q3" readonly><?php echo $question3; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad3" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />


<input type="radio" name="rad3" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />


<input type="radio" name="rad3" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt"  href="#q2"><label title="Proceed to 2nd Question">Back</label></a> &nbsp;|&nbsp; 
<a class="nxt"  href="#q4"><label title="Proceed to 4th Question">Next</label></a>
</center> 
</div> 
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>


<br /><br />
<?php
$q = mysql_query("SELECT * FROM histact1 ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question4 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5]; 
?>


<div class="Qset" id="q4"><br /><br />
<label class="items">4th Question :</label> <br />
<center>
<textarea class="textareaQ" name="q4" readonly><?php echo $question4; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad4" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />


<input type="radio" name="rad4" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />


<input type="radio" name="rad4" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt"  href="#q3"><label title="Proceed to 3rd Question">Back</label></a> &nbsp;|&nbsp; 
<a class="nxt"  href="#q5"><label title="Proceed to 5th Question">Next</label></a>
</center> 
</div> 
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>


<br /><br />
<?php
$q = mysql_query("SELECT * FROM histact1 WHERE question != '$question1' AND question != '$question2' AND question != '$question3' AND question != '$question4' ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question5 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5]; 
?>


<div class="Qset" id="q5"><br /><br />
<label class="items">5th Question :</label> <br />
<center>
<textarea class="textareaQ" name="q5" readonly><?php echo $question5; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad5" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />


<input type="radio" name="rad5" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />


<input type="radio" name="rad5" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt"  href="#q4"><label title="Proceed to 4th Question">Back</label></a> &nbsp;|&nbsp; 
<input type="submit" title="Submit Answers" name="submit" class="submit" value=" Submit " onclick="return confirm('Are you sure you want to submit your answers?\nYou can review your answer by click the Back link')" />
</center> 
</div> 
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>
</form>

Edited by mac_gyver, 09 October 2014 - 10:51 AM.
code in code tags please

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\ajaxpages\attendance\student_attendance.php on line 7


<?php $i=1;?>
<?php error_reporting();include("../../connect.php"); session_start();

$class_id = $_POST['class_id'];

$query =  mysql_query("SELECT * FROM attendance WHERE class='$class_id' ORDER BY student ASC ");
while($row = mysql_fetch_array($query))                ####LINE 7<----------------------------------------
{
?>
<li><div class="num"><?php print $i++?></div><?php print $row['student']; ?></li>
<?php }?>

I have this code

Code: [Select]
$id = $_GET['esitysid'];
$esitysnimi = mysql_query("SELECT * FROM varasto WHERE id = '".$id."", $yhteys);
print "esitysnimi $esitysnimi";
$esitysnim = mysql_result($esitysnimi, "0", "nimi");
varasto:
Code: [Select]
nimi hinta maara id lippuja
Esitys Nimi 1 10 14 0 5
Esitys Nimi 2 120 5 1 0
Esitys Nimi 3 950 5 2 0
and it says

Code: [Select]
Warning: mysql_result() expects parameter 1 to be resource, boolean given
How can I fix it? Thank you for help

hey. im new to php and i get this error and i dnt know how to make it r8.here is my code
and also i get undefined index for name/comment/submit but they all seems to work fine.please help




<?php
            require('contact.php');
            $name=$_POST["name"];
            $comment=$_POST["comment"];
            $submit=$_POST["submit"];

            if($submit){
               if($name&&$comment){
                  $insQry=mysql_query("INSERT INTO `comment`.`comment` (`name`,`comment`) VALUES ('$name','$comment')");
               }else{
                  echo "pleace Fill All the Fields";   
               }
            }
         ?>         
         <?php
         $getqry=mysql_query("SELECT * FROM comment ORDER BY id DECS");
         while($grows=mysql_fetch_array($getqry)){
         $id=$grows['id'];
         $name=$grows['name'];
         $comment=$grows['comment'];
         
         echo $name . "<br />".$comment."<br />"."<hr />";
            
         }
         ?>

When i try and use this app on my website i get the error,
Code: [Select]
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/unionc/public_html/auction/scripts/updateTables.php on line 15
Code: [Select]
<?php
    $now = time();

add_column_if_not_exist("WA_SellPrice", "seller", "VARCHAR( 255 ) NULL");
add_column_if_not_exist("WA_SellPrice", "buyer", "VARCHAR( 255 ) NULL");
add_column_if_not_exist("WA_Players", "canBuy", "INT(11) NOT NULL DEFAULT  '0'");
add_column_if_not_exist("WA_Players", "canSell", "INT(11) NOT NULL DEFAULT  '0'");
add_column_if_not_exist("WA_Players", "isAdmin", "INT(11) NOT NULL DEFAULT  '0'");
add_column_if_not_exist("WA_Auctions", "created", "INT(11) NULL");


function add_column_if_not_exist($table, $column, $column_attr){
    $exists = false;
    $columns = mysql_query("show columns from $table");
    while($c = mysql_fetch_assoc($columns)){
        if($c['Field'] == $column){
            $exists = true;
            break;
        }
    }      
    if(!$exists){
        mysql_query("ALTER TABLE `$table` ADD `$column`  $column_attr");
    }
}

?>Please Help!

Code: [Select]
<?php    
$limit=12;
if(isset( $_GET['page']))
      $page=$_GET['page'];
      if($page<=0) $page = 1;
      
      else {$start=0;}
   $sql=mysql_query('select * from tbl_gallery where status=1 AND category_name="0"');
   $count=mysql_num_rows($sql);
   $totalcount=ceil($count/$limit);
   $start=($page-1)*$limit;
   $s=mysql_query('select * from tbl_gallery where status=1 AND category_name="0" limit $start, $limit');
   while($result=mysql_fetch_array($s)){
      $start++;
      
 ?>

MOD EDIT: code tags added.

Hi there
I am having a problem with this warning message being thrown
"Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\wamp\www\css\rnfunctions.php on line 302"
and again for line 303
Here is the code

function receiveuserchange()
{
if (isset($_POST['level'])){
$query = "SELECT * FROM users";
$result=mysql_query($query) or die("Invalid Query : ".mysql_error());
$num=mysql_numrows($result);
$i=0;

while ($i < $num) {

////////////////here are lines 302 and 303///////////////////////////////
$user=mysql_result($result,$i,"user");
$id=mysql_result($result,$i,"id");
/////////////////////////////////////////////////////////////////////////////

if (isset($_POST["$user"])){
$level = ($_POST["$user"]);
$query = "update profiles set level='$level' where pid='$id'";
$result=mysql_query($query) or die("Invalid Query : ".mysql_error());
ViewUsers('viewusers.php');
}else{
echo "$user not recieved";
}
$i++;
}

Can anyone see what the problem is?

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\websiteku\modul\laporan\laporan.php on line 48

 
$query2 = "SELECT count(*) as jum1 FROM transaksi WHERE nama_kategori = '$namaBidang' AND nama_bayar = Uang";
  $hasil2 = mysql_query($query2);
  $data3 = mysql_fetch_array($hasil2);
  $jumGol1 = $data3['jum1'];

help me guys, how i fix this problem ??

Hi, I'm fairly new to PHP and have run into this problem, I have tried looking through some other peoples solutions to this but don't quite understand them!

I have set up a simple news post on a website which works fine, however when I go to edit a post and try to submit it again it comes up with this error:

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /Users/mdfcows/Sites/atelier/editnews.php on line 61

It still works, i.e. posts it, however I don't quite know what this means, and now I am trying to set it up so that another page can be edited and all I am getting is the same error on the page without any of the other info or PHP coming up!

this is the PHP I am using, with the line
"while ($row = mysql_fetch_assoc ($result)) {"
being line number 61


Code: [Select]
<?php
require_once('config.php');

$con = mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
if (!$con){
die('Failed to connect to server' . mysql_error());
}

mysql_select_db(DB_DATABASE);

$ide = $_POST[idf];
$query = "SELECT image,id,title,text FROM news WHERE id = $ide";
$result = mysql_query($query); 

while ($row = mysql_fetch_assoc ($result)) {
$title = htmlentities ($row['title']);
$news = nl2br (strip_tags ($row ['text'], '<a><b><i><u>'));
$image = $row['image'];

echo "<form class ='addform' action='editnews.php' enctype='multipart/form-data' method='post'>";
echo "<input type='hidden' name='ida' value='$ide' />";
echo "<p>Title:<br /><input class='titlefield' type='text' name='title' value='$title' /></p><br />";
echo "<p>News Post:<br /> <textarea name='news' rows='12' cols='50'>$news</textarea></p><br />";
echo "<p>If you uploaded an image with your post you will need to upload it again<br /><input type='hidden' name='MAX_FILE_SIZE' value='20000000' /> <input name='userfile' type='file' value='$image' id='userfile' /></p><br />";
echo "<p><input name='submit' type='submit' value='Submit' /></p>";
echo "</form>";
}

if ($_POST['submit'])
{
  
  mysql_select_db(DB_DATABASE);
  
  $upid = $_POST[ida];
  $uptitle = $_POST[title];
  $upnews = $_POST[news];
  $upimage = $_FILES['userfile']['name'];
  
  $sql = "UPDATE news SET title = '$uptitle', text = '$upnews', image = '$upimage' WHERE id = '$upid'";
  
  mysql_query($sql);
  
  if ($_POST['submit'])
  {
  
  echo "<p class='admintext'>Your post has been Edited - <a href='index.php'>View Latest News Page</a></p><br />";
  $name = $_FILES['userfile']['name'];
  $type = $_FILES['userfile']['type'];
  $size = $_FILES['userfile']['size'];
  $tmpname = $_FILES['userfile']['tmp_name'];
  $ext = substr($name, strrpos($name, '.'));
  
  if (strstr($type, "image"))
  {
  move_uploaded_file($tmpname, "images/".$name);
  }
  
  }
}
  
?>

Any help would be much appreciated!

Thank you

Martin

i give it up after 4 h.

please help me, what i do wrong

don't know what to do next with this error popping up,,,any help?


<?php
      //set up the variables
      $loguser = $_POST['loguser'];
      $logpass = md5($_POST['logpass']);
      $login = $_get['login'];
      
      //connect with the server and the database
      mysql_connect("localhost","root","") or die("Can't connect with the Server!");
      mysql_select_db("comp3project") or die("Can't connect with the database!");
      
      if($login="yes")   
      {
         $get = mysql_query("SELECT count(cid) FROM customer_data WHERE username = '$loguser'
            and password = '$logpass'");
         $result = mysql_result($get,0);
         
         if($result!=1){print "Login Failed!";}
         else {print "Login Successful!";}
      }
   ?>

i am try to make a name, address search system into my website from my database. but i got this msg [Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampplite\htdocs\3\searchresult.php on line 54]

my full php code i.e. searchresult.php is under......

what i have mistake.....

searchresult.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<?php

// TAKE THE INFORMATION FROM FORM.

$search = $_GET['search'];

// IF THERE IS NOT A KEYWORD GIVE A MISTAKE.

if (!$search)

echo "You didn't enter a keyword";

else

{

echo "<td>You searched for: <strong>$search </strong></td>";

mysql_connect('localhost','root','');

mysql_select_db('search');

$id=@$_GET['id'];

//QUERY IS THE CODE WHICH WILL MAKE THE SEARCH IN YOUR DATABASE.

//I WROTE AN EXPLANATION ABOUT IT AFTER THE CODE.

$sql = "CREATE TABLE searchform \n"
    ."(\n"
    ."ID int NOT NULL AUTO_INCREMENT ,\n"
    ."FirstName varchar( 255 ) NOT NULL ,\n"
    ."LastName varchar( 255 ) NOT NULL ,\n"
    ."Email varchar( 255 ) NOT NULL ,\n"
    ."PhoneNumber varchar( 255 ) NOT NULL ,\n"
    ."PRIMARY KEY ( ID ) )";;

$result1 = MySQL_query($query);

if(!$result1) {

echo MySQL_error()."<br>$query<br>";

}

if(MySQL_num_rows($result1) > 5) {

echo "<table width='750' align='center' border='0' cellspacing='0' cellpadding='0'>";

while($result2 = MySQL_fetch_array($result1)) {

//A short description from category.

$description = $result2['category'];

$searchPosition = strpos($description, $search);

$shortDescription = substr($description, $searchPosition, 150);

// I added a link to results which will send the user to your display page.

echo '<tr><td><p><strong><a href="displayresults.php?id='.$result2['id'].'">'.$result2['title'].'</strong></p></td></tr>';

echo "<tr><td>$shortDescription ...</td></tr>";

echo "<td>{$result2['name']} {$result2['surname']}</td><tr/>";

}

echo "</table>";

}else {

echo "No Results were found in this category.<br>";

}echo "<br>";

}

?>

</body>
</html>


and

searchform.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<form action="searchresult.php" method="get">

<div align="center">

<p>

<input name="search" type="text" size="60"/>

<input name="submit" type="submit" value="Search" />

</p>

</div>

</form>
</body>
</html>

HELP ME TO CHANGE THE ERROR


<?PHP
//Include connection to database
include('connect.php');

//Get posted values from form
$status=$_POST['status'];
$date=$_POST['date'];

//Strip slashes
$status = stripslashes($status);
$date = stripslashes($date);
 
//Strip tags
$status = strip_tags($status);
$date = strip_tags($date);

//Inset into database

$insert_status = mysql_query(" insert into status (status) value ('$status')") or die (mysql_error());
$insert_status = mysql_query("insert into status (date) value ('$date')") or die (mysql_error());

while($row = mysql_fetch_array($insert_status)) {  (ERROR IS IN THIS LINE)
$status=$row['status'];
$date=$row['date'];
}


//Line break after every 80
$status = wordwrap($status, 80, "\n", true);

//Line breaks
$status=nl2br($status);

//Display status from data base
echo '<div class="load_status">
<div class="status_img"><img src="blankSilhouette.png" /></div>
<div class="status_text"><a href="#" class="blue">Anonimo</a><p class="text">'.$status.'</p>
<div class="date">'.$date.' &middot; <a href="#" class="light_blue">Like</a> &middot; <a href="#"
class="light_blue">Comment</a></div>
</div>
<div class="clear"></div>
</div>';
?>

I am getting the below error message:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\Program Files (x86)\EasyPHP-5.3.9\www\a.php on line 78

The two issues a

1. The red text I need to somehow use the DISTINCT function as it is duplicating a person for every skill they have.

2. The blue text is causing the error above, if I remove the join it works but assigns every possible skill to the person (because skill table and resource table are not joined). I therefore need the join there but without the error.

My code is below:

<!DOCTYPE  HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"  "http://www.w3.org/TR/html4/loose.dtd">
   <html>
     <head>
       <meta  http-equiv="Content-Type" content="text/html;  charset=iso-8859-1">
       <title>Search  Contacts</title>

<style  type="text/css" media="screen">
   ul  li{
     list-style-type:none;    }
   </style> 
     </head>
 
     <p><body>
       <h3>Search  Contacts Details</h3>
       <p>You  may search either by first or last name</p>
       <form  method="post" action="a.php?go"  id="searchform">
         <input  type="text" name="name">
         <input  type="submit" name="submit" value="Search">
          </form>

<?php
     if(isset($_POST['submit'])){
     if(isset($_GET['go'])){
     if(preg_match("/^[  a-zA-Z]+/", $_POST['name'])){
     $name=$_POST['name'];
    
//connect  to the database
     $db=mysql_connect  ("127.0.0.1", "root",  "") or die ('I cannot connect to the database  because: ' . mysql_error());
    
//-select  the database to use
     $mydb=mysql_select_db("resource matrix");
    

//-query  the database table



     $sql="SELECT * FROM ((resource l inner join resource_skill ln on l.Resource_ID = ln.Resource_ID) inner join skill n on ln.Skill_ID = n.Skill_ID) WHERE First_Name LIKE '%" . $name .  "%' OR Last_Name LIKE '%" . $name ."%' OR Skill_Name LIKE '%" . $name ."%'";
    
//-run  the query against the mysql query function
     $result=mysql_query($sql);
    
//-create  while loop and loop through result set
     while($row=mysql_fetch_array($result)){
             $First_Name  =$row['First_Name'];
             $Last_Name=$row['Last_Name'];
             $Resource_ID=$row['Resource_ID'];
    
//-display the result of the array
     echo "<ul>\n";
     echo "<li>" . "<a  href=\"a.php?id=$Resource_ID\">"   .$First_Name . " " . $Last_Name .  "</a></li>\n";
     echo "</ul>";
     }
     }
     else{
     echo  "<p>Please enter a search query</p>";
     }
     }
     }

//end of our letter search script
if(isset($_GET['id'])){
$contactid=$_GET['id'];

//connect  to the database
$db=mysql_connect  ("127.0.0.1", "root",  "") or die ('I cannot connect to the database  because: ' . mysql_error());

//-select  the database to use
$mydb=mysql_select_db("resource matrix");

//-query  the database table
$sql="SELECT * FROM ((resource l inner join resource_skill ln on l.Resource_ID = ln.Resource_ID) inner join skill n on ln.Skill_ID = n.Skill_ID) WHERE Resource_ID=" . $contactid;

//-run  the query against the mysql query function
$result=mysql_query($sql);

//-create  while loop and loop through result set
while($row=mysql_fetch_array($result)){
         $First_Name =$row['First_Name'];
            $Last_Name=$row['Last_Name'];
            $Mobile_Number=$row['Mobile_Number'];
            $Email_Address=$row['Email_Address'];
       $Level=$row['Level'];
       $Security_Cleared=$row['Security_Cleared'];
            $Contract_Type=$row['Contract_Type'];
            $Contract_Expiry=$row['Contract_Expiry'];
            $Day_Rate=$row['Day_Rate'];
            $Post_Code=$row['Post_Code'];
       $Skill_Name=$row['Skill_Name'];

//-display  the result of the array
echo  "<ul>\n";
echo  "<li>" . $First_Name . " " . $Last_Name .  "</li>\n";
echo  "<li>" . $Mobile_Number . "</li>\n";
echo  "<li>" . "<a href=mailto:" . $Email_Address .  ">" . $Email_Address . "</a></li>\n";
echo  "<li>" . $Level . "</li>\n";
echo  "<li>" . $Security_Cleared . "</li>\n";
echo  "<li>" . $Contract_Type . "</li>\n";
echo  "<li>" . $Contract_Expiry . "</li>\n";
echo  "<li>" . $Day_Rate . "</li>\n";
echo  "<li>" . $Post_Code . "</li>\n";
echo  "<li>" . $Skill_Name . "</li>\n";
echo  "</ul>";
}
}



   ?>




   </body>
   </html>