display it in a link

[kir441]

if(($R1=="V1"))
{
if(!$T1=="")
{
$search=$T1;
$query="SELECT TABLE_NAME FROM xxx WHERE TABLE_NAME LIKE '" . $search . "%'";
$result1=odbc_exec($cnx,$query);

while(odbc_fetch_row($result1))
{
for($i=1;$i<=odbc_num_fields($result1);$i++)
{

echo  "        " . odbc_result_all($result1,$i) </a>;

   }
}

}
}

Can any one help in displaying the value in "$result" variable as a hyperlink so that I can write some queries if the user clicks on the result. I know that I need to use <a href> but i culd not figure out the exact syntax.

Thanks

[ofSHIZ]

I'm not exactly sure if this would work.. but you could try it..

if(($R1=="V1")) 
{ 
if(!$T1=="") 
{ 
$search=$T1; 
$query="SELECT TABLE_NAME FROM xxx WHERE TABLE_NAME LIKE '" . $search . "%'"; 
$result1=odbc_exec($cnx,$query); 

while(odbc_fetch_row($result1)) 
{ 
for($i=1;$i<=odbc_num_fields($result1);$i++) 
{ 

<a href="link.php">echo " " . odbc_result_all($result1,$i) </a>; 

} 
} 
} 
}