Hi, i've been going round in circles for an answer to this one.
Basically, i've downloaded a search application for my website here http://hvn.org.uk/searchengine. This all works fine. What i now need to do is take the link on the results page and populate a new details.php page will display the full database records and fields, as this has to be based on what the user clicks.
As you can see from the site i have managed to get the search.php page to pass the unique ID to the details.php, so that looks to be fine, to me anyway :?:
I'm lost as to how to get the details.php to display the associated data for the record selected. I really dont know where to start past the <?php at the top of the page.
As i say any help would be greatly appreciated. I enclose the search.php code if it helps.
$button = $_GET['submit'];
$search = $_GET['search'];
$id = $_GET['profileid'];
$s = $_GET['s'];
$s = 0;
$e = 10; // Just change to how many results you want per page
$next = $s + $e;
$prev = $s - $e;
echo "Must be greater then 3 chars";
echo "<br /><table><tr><td><img src='juzzy.jpg' /></td><td><form action='search.php' method='GET'><input type='text' onclick=value='' size='100' name='search' value='$search'> <input type='submit' name='submit' value='Search'></form></td></tr></table>";
//connect to database
//explode out search term
$search_exploded = explode(" ",$search);
foreach($search_exploded as $search_each)
$construct .= "keywords LIKE '%$search_each%'";
$construct .= " OR keywords LIKE '%$search_each%'";
$constructx = "SELECT * FROM job_profile WHERE $construct";
$construct = "SELECT * FROM job_profile WHERE $construct LIMIT $s,$e";
$run = mysql_query($constructx);
$foundnum = mysql_num_rows($run);
$run_two = mysql_query("$construct");
echo "No results found for <b>$search</b>";
echo "<table bgcolor='#0000FF' width='100%' height='1px'><br /></table><table bgcolor='#f0f7f9' width='100%' height='10px'><tr><td><div align='right'>Showing 1-10 of <b>$foundnum</b> results found for <b>$search.</b></div></td></tr></table><p>";
while ($runrows = mysql_fetch_assoc($run_two))
$id = $runrows['profileid'];
$title = $runrows['jobtitle'];
$desc = $runrows['jobdescription'];
$url = $runrows['url'];
echo "<table width='650px'>
<h4><a href='details.php?id=$id'><b>$title</b></a><br />
it should like in your db field `profileid` you have PHP code instead of just a number. Make sure you have a unique number in it.
Thanks for the reply. I understand that i need to tell details.php to retrieve the unique profileid that the user clicked in search.php and then display the results, i'm just not quite getting what the php code should be to kick start that process and show some database output on the details page.
Any help greatly appreciated. I think i may be thinking too hard and im gonna kick myself in the end, but if someone could point me in the right direction i'd be really grateful.