[Resolved] Search result as links

[dcc55]

Hi

Im new to all this bur have managed to solve all problems by searching this forum and RTFM up till now..

I just need a hint since i dont know what im looking for.

Im working on a customer database and i want my search results to show up with a link, and when i click in the link it will show all the information about the customer.

As i said i just need to know what to look for to accomplish this so any hints will be appreciated 🙂

[Drakla]

If you'd done a search on surnames for example, you could have something like this.

	$q = "SELECT id, name, surname
				FROM customers
			WHERE surname like '$searchvar%' ORDER BY surname";

$db->safe_query($q);

if( !$db->num_rows() ) return;

echo '<table border="1">'."\n";

while ( $row = $db->fetch_assoc() )
{
	echo 
		'<tr>',
		'<td><a href="customer-details.php?id=', $row['id'], '">', $row['name'], ' ', $row['surname'],'</a></td>',
		"</tr>\n";
}

echo "</table>\n";	

I use a class I wrote to encapsulate all the query results gunk, just replace with the appropriate mysql functions.

[dcc55]

Thanks!!

Your code example got me into the right direction.