Thanks millions Dan! That's exactly what I need. And I used your method and it worked
beautifully!
I'm so excited! Thanks again!
Jordan
Dan Greene wrote:
> 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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
