Returning URL with mysql record id after search

[braden]

I wanted to know how to post the mysql record "id" in the url (ie http://mysite.com/searchresult.php?id=326) after a search.  Is there a particular function that would let me echo that variable in the url after a search?  This way I can use "get" for navigation.

 

Regards,

Bradem

 

[atticus]

Bradem, please give more details about the search.  Do you want the pages found in the search to have the link id, or the actual search results page.

[soycharliente]

<?php
$id = $_GET['id'];
$sql = "SELECT * FROM `table` WHERE `id`='$id'";
$result = mysql_query($sql) OR DIE("$sql :: ".mysql_error());
if (mysql_num_rows($result) > 0)
{
while ($row = mysql_fetch_array($result))
{
	// do something
}
} else
{
// do something else
}
?>

[soycharliente]

Also you want to remember that with using $_GET comes some security issues. So Google for $_GET and security to see what some of the best practices are when using it.