PHP - Save Each Record Into Database And Then Update Table For All Users

Hello folks I am new to php and I have been trying to put together a database that a user can search and choose from the results. I have managed to make this script by copying code from google searches and trial and error.
The script so far has been tested and works.
The hard part is the code for choosing from the results, I have tried some things but I have been far from the mark, the thing is I can't get my head around the problem, if the first field is a number which is unique to each row, how can I pick that up in a php argument.
I have tried making the first field an href link to send that number to a different table which would collect the results of the users choices, but I'm just not sure what to put in the code.
Could someone throw me a lifeline here I've searched for hours on google to find any code that looks like it would work with no luck. 


// Get the search variable from URL
  
  $var = @$_GET['a'] ;
  $trimmed1 = trim($var); //trim whitespace from the stored variable
      
  $var = @$_GET['b'] ;
  $trimmed2 = trim($var);
  
  $var = @$_GET['c'] ;
  $trimmed3 = trim($var);
  
  $var = @$_GET['d'] ;
  $trimmed4 = trim($var);
  
  $var = @$_GET['e'] ;
  $trimmed5 = trim($var);
  
  $var = @$_GET['f'] ;
  $trimmed6 = trim($var);


 //connect to your database
mysql_connect("localhost","root",""); //(host, username, password)

//specify database 
mysql_select_db("a2149809_MV") or die("Unable to select database"); //select which database we're using

// Build SQL Query  
$query = "SELECT *  FROM `table` WHERE `field1` LIKE \"%$trimmed1%\" AND `field2` LIKE \"%$trimmed2%\" AND `field3` LIKE \"%$trimmed3%\" 
  AND `field4` LIKE \"%$trimmed4%\" AND `field5` LIKE \"%$trimmed5%\" AND `field6` LIKE \"%$trimmed6%\" order by `field1`";  
  
$result=mysql_query($query);
$num=mysql_num_rows($result);

mysql_close();



    <table width="100%" border=2 cellspacing=2 cellpadding=2>
<tr><form name="form" action="" method="get">
<td colspan="6"><input type="submit" name="Submit" value="Search" />
</td>
</tr>
<tr>
<td><input type="text" name="a" value="" size="4" /></td>
<td><input type="text" name="b" value="" size="40" /></td>
        <td><input type="text" name="c" value="" size="3"  /></td>
<td><input type="text" name="d" value="" size="10" /></td>
<td><input type="text" name="e" value="" size="10" /></td>
<td><input type="text" name="f" value="" size="10" /></td>
</form></tr>


         

<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"Field1");
$f2=mysql_result($result,$i,"Field2");
$f3=mysql_result($result,$i,"Field3");
$f4=mysql_result($result,$i,"Field4");
$f5=mysql_result($result,$i,"Field5");
$f6=mysql_result($result,$i,"Field6");

?>

                 <tr>
                     <td><?php echo $f1; ?></td>
                     <td><?php echo $f2; ?></td>
             <td><?php echo $f3; ?></td>
             <td><?php echo $f4; ?></td>
             <td><?php echo $f5; ?></td>
             <td><?php echo $f6; ?></td>
</tr>


    

<?php
$i++;
}
?>
</table>

Not sure how to update a record in my table here. I got my insert and delete statement working. Just can't get the update to work correctly. I'm not really sure how to do it.



Here is my code for my page, and my update and delete page



Code: [Select]
<?php

ini_set ("display_errors", "1");
error_reporting(E_ALL);

require_once('database.php');
session_start();




if (isset($_POST['add_grade']))
{



$query = "INSERT INTO grades (grade_id, student_id, grade_type, grade_name, grade_points) ";
$query .= "VALUES (:grade_id, :student_id, :grade_type, :grade_name, :grade_points) ";

$statement = $db->prepare($query);
$statement->bindValue (':student_id', $_SESSION['student_id']);
$statement->bindValue (':grade_id', $_SESSION['grade_id']);
$statement->bindValue (':grade_type', $_POST['grade_type']);
$statement->bindValue (':grade_name', $_POST['grade_name']);
$statement->bindValue (':grade_points', $_POST['grade_point']);

$statement->execute();

$statement->closeCursor();





$grade_type = $_POST['grade_type'];

if ($grade_type == 'Lab') {


$final *= .60;
}

echo $final;


$grade_type = $_POST['grade_type'];

if ($grade_type == 'Mid-Term') {


$final *= .20;
}

echo $final;



$grade_type = $_POST['grade_type'];

if ($grade_type == 'Final') {


$final *= .20;
}

echo $final;


}

?>
<!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=utf-8" />
<title>View Course Grades</title>

<link rel="stylesheet" type="text/css" href="main.css" />
</head>

<body>


   



<?php

$student_name = $_SESSION['student_name'];
$student_id = $_SESSION['student_id'];
$query = "SELECT * FROM grades WHERE student_id = :student_id ";

$statement = $db->prepare($query);
$statement->bindValue (':student_id', $student_id);
$statement->execute();
$grades = $statement->fetchAll();
$statement->closeCursor();


echo "<h1>Show Grades for $student_name </h1>";

foreach ($grades as $grade)
{

echo $grade['grade_type'] . " " . $grade['grade_name']. " " . $grade['grade_points'] . "<br />";
}





?>

<div id="content">
            <!-- display a table of products -->
           
            <table>
                <tr>
                    <th>Grade Type</th>
                    <th>Grade Name</th>
                    <th>Grade Points</th>
                    <th>Remove</th>
                </tr>
                <?php foreach ($grades as $grade) : ?>
                <tr>
                    <td><?php echo $grade['grade_type'];   ?></td>
                    <td><?php echo $grade['grade_name'];   ?></td>
                    <td><?php echo $grade['grade_points']; ?></td>
                    <td><form action="delete_grade.php" method="post">
                       
                        <input type="submit" name="remove" value="Delete" />




                    </form></td>
                </tr>
                <?php endforeach; ?>
            </table>
           
        </div>
    </div>

    <div id="footer">
       
    </div>






<form name="grades" method="post" action="grades.php">

<p>Grade Type<SELECT NAME="grade_type">
<OPTION VALUE="Mid-Term">Mid-Term
<OPTION VALUE="Final">Final
<OPTION VALUE="Lab">Lab
</SELECT>
<br>







Grade Name:<input type="text" name="grade_name" value=""><br />
Grade Points:<input type="text" name="grade_point" value="">

<input type="submit" name="add_grade" value="Add Grade">


</form>

</table>

</body>

</html>





My delete and update page




Code: [Select]
<html>
<head>
<title>Delete Grade</title>
</head>
<body>
<form method="post" action="delete_grade.php">

<?php


ini_set ("display_errors", "1");
error_reporting(E_ALL);

$dbc = mysqli_connect('localhost', 'se266_user', 'pwd', 'se266') 
or die(mysql_error());

//delete grades

if (isset($_POST['remove']))
{          
foreach($_POST['delete'] as $delete_id)
{             
$query = "DELETE FROM grades WHERE grade_id = $delete_id";             
mysqli_query($dbc, $query) or die ('can\'t delete user');          
}        
echo 'user has been deleted.<br />';   
}

if (isset($_POST['update']))
{          
foreach($_POST['update'] as $update_id)
{             
$query = "UPDATE grades SET grade_id = $grade_id";             
mysqli_query($dbc, $query) or die ('can\'t update user');    
       
}
}

//Display grade info with checkbox to delete  
$query = "SELECT * FROM grades";  
$result = mysqli_query($dbc, $query);  
while($row = mysqli_fetch_array($result))
{      
echo '<input type="checkbox" value="' .$row['grade_id'] . '" name="delete[]" />'; 
echo ' ' .$row['grade_type'] .' '. $row['grade_name'];
echo '<br />';  
}
mysqli_close($dbc);

?>

<input type="submit" name="remove" value="Remove" />
<input type="submit" name="update" value="Update" />

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

Hello I'm trying to set up a user area for my site where it displays the current logged in users ranking and other information in the future.  

<?
 ini_set('display_errors', 1);
require_once "header.php";

$sql = "SELECT * FROM users WHERE username = ?";

  if($stmt = mysqli_prepare($link, $sql)){
  
    mysqli_stmt_bind_param($stmt, 's', $_SESSION['username']);
  
   if(mysqli_stmt_execute($stmt)){
                
   
   $info = mysqli_fetch_array($stmt);
   
   echo "Current rank:" . $info['rank'];
   
   
   } else {
   
   echo "Can't find user";
   }
   }
   mysqli_stmt_close($stmt);





?>

That's the code I currently have but it gives me the error "but get an error message of mysqli_fetch_array() expects parameter 1 to be mysqli_result"

Good morning:

This is the output of my test database table:

2011-05-30 Chevrolet Monte Carol 1975 9000 15000 James Bond's 007-1212 james@bond.com B I am setting the rocord for bond's most active movies.
2011-05-31 Dodge Stratus 2008 5000 7500 James Cagney 555-1818 jc@hollywood.com S This is not going to be the best of time's. Ain't it?

Within my table I have two important fields--the record date-created field shown on the left and the (hidden) EXPIRED field--on which the UPDATE function depends.  This is my code for (wherein lies the problem) UPDATING the record within my table and setting the EXPIRED field to 'Y' for filtering and easy deletion of the record(s).
Code: [Select]
<?php
// Connect to database.
include("connect.php");
// Access the database 

@mysql_select_db($database,$con) or die( "Unable to select database");

$result = mysql_query("SELECT * FROM Autos"); //read all records into array

while($row = mysql_fetch_array($result)) //loop through array 
 {
  if (1 - strcmp(date("Y-m-d"),$row['DateCreated']) == 0) //compare current date with record date and act when result is zero 
  {
    mysql_query("UPDATE Autos SET Expired = 'Y' WHERE Expired == 'N'"); //if ready to expire then update table EXPIRED field  
  } else {
     if ($row['BuyerSeller'] == 'B') {
     echo "Contact buyer below";
   } elseif ($row['BuyerSeller'] == 'S') {
     echo "Contact seller below";
   }
   echo "<br />";
    echo $row['DateCreated'] . " " . $row['Make'] . " " . $row['Model'] . " " . $row['Year'] . " " . $row['MinPrice'] . " " . $row['MaxPrice'] . " " . $row['POC'] . " " . $row['POCPhone'] . " " . $row['POCEmail'] . " " . $row['Notes'];
    echo "<br />";
  }
 }
mysql_close($con)
?>
Lastly, does the mysql_close function with the single parameter $con also close the database?

MOD EDIT: code tags added.

Hai..   currently i am developing client dashboard using php/mysql.Here is my problem i need to create a tab named as notes.Using this tab the logged in users can add a new note or edit his existing note and save as text file..