I'm working on a search results page. actually i have my search form and 
search results page working fine already. but i want to add something on the 
"results page". my search "results page" shows the following fields: 
lastname, firstname, middlename, yeargrad.
what i want is that the lastname results should be linked to a "more 
details" page. so for example, if i have a search result with 'garcia' as 
the lastname..i click on that and i should be transferred to a page showing 
me more details of that garcia..showing me more than just his/her 
firstname,middlename, and yeargrad.

What should i use as my sql statement for the "more details" page? And how 
do i tell the detail page to show which records to retrieve and display?
By the way, here's part of the code that i have for the results page:

// <?php
//   include_once ("connect.php");
//   $sql = "Select * from alumni where yeargrad = ('$search') OR lastname 
like ('%$search%') OR country like ('%$search%') order by lastname";
//   $rs = mysql_query($sql,$db);
//   if (!$r = mysql_fetch_object($rs)) {
//         echo "No record found. Please try again.";
//   exit;
//   }
//   $rs = mysql_query($sql,$db);
//   while ($r = mysql_fetch_object($rs)){
//   echo "<br>$r->lastname";
//   }
// ?>

if anyone can please help me. thanks.

// MM Fernandez

Join the world’s largest e-mail service with MSN Hotmail. 

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to