A database from which users can make choices and save them

[okeddy]

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>

[okeddy]

What happened to all the replies to this post, I wasn't finished here!

[okeddy]

SORRY WRONG FORUM