To make this back to being a MySQL question....
What if you used the encode or md5 functions when you retrieve the list of results,
and then do your lookup on the item details by matching it to decoding the same id?
ex. get list-
select fid as open_fid, MD5(fid) as crypt_id
from your_table
where <whatever your criteria is >
Which when you make url will look like:
echo " <a href=\"FacDetails.php?fid=$crypt_id\">$fname</a> "
which will generate something like:
<a href="FacDetails.php?fid=23rh23kjne2323j4k23n234l">Jordan</a>
and on your lookup, do
select col1, col2, col3
from FacDetails
where MD5(fid) = $fid;
My $0.02 cents...
> > At 01:32 PM 10/17/2003, Jordan Morgan wrote:
> > >Hi,
> > >
> > >I'm still learning on this. Pls. excuse me if I simply overlooked
> > >something.
> > >
> > >Originally I had this:
> > >
> > ><?
> > >// list matches
> > >
> > >while (list($fid, $title, $lname, $fname) =
> mysql_fetch_row($result))
> > > {
> > > echo "<table border=2 width=400 cellpadding=2
> cellspacing=2><tr>";
> > > echo "<td width=200><a
> > >href=FacDetails.php?fid=$fid>$fname $lname</a></td><td
> > >width=200>$title</td>";
> > > echo "</tr></table>";
> > > }
> > >?>
> > >
> > >to list the search results and display them as a link
> which will take
> > >the user to a detailed page. However, the fid has to show
> up as part of
> > >the URL. I want to hide the fid as I don't want people to
> view the other
> > >detailed records just by randomly entering the number for
> the fid. So I
> > >tried to modify it and came up with the following:
> > >
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
