> while($row = mysql_fetch_assoc($query)){
>
> $id = $row['id'];
>
> echo '<a href=profile1.php?id= . $row["id"] . >.INFO.</a>';

<?php

mysql_connect("", "", "") or die( mysql_error() );

mysql_select_db("my db")  or die( mysql_error() );

$id = $_GET['id']

$sql =('SELECT * FROM table WHERE id=$id');

$result = mysql_query( $sql ) or die( "Error executing:<br>$sql<br>".mysql_error() ) ;

if( mysql_num_rows($result) )

{

  echo '<div>No records found</div>';

}

else

{
  $row=mysql_fetch_assoc($result);

echo $row['name'];
echo $row['brand'];

}

?>

echo '<a href="profile1.php?id='. $row["id"] .'">.INFO.</a>';