a href to each result in a query

[knaj11]

i want each result of my query to have a link or be in a <a href =" "> tag..

 

code is this...

$query = "select artist from lyrics where artist like 'a%' order by artist ASC";
$result = mysql_query($query) or die ("Error in query: $query . " . mysql_query());

if (mysql_num_rows($result) > 0)
{
	while ($row = mysql_fetch_object($result))
	{
	?>
		<?php echo $row->artist; ?><br>
	<?php
	}
}
else
{
	echo 'No Content';
}

 

the result of this code is just this....

 

Adam Sandler

Aqua

Avril Lavigne

 

 

all w/o links...

 

how can i have the resulting queries have links???

 

 

[Matthias_]

$query = "select artist from lyrics where artist like 'a%' order by artist ASC";
$result = mysql_query($query) or die ("Error in query: $query . " . mysql_query());

if (mysql_num_rows($result) > 0)
{
	while ($row = mysql_fetch_object($result))
	{
		echo "<a href = \"somepage.php\">$row->artist;</a>";
	}
}
else
{
	echo 'No Content';
}

 

Not sure if it is

 

echo "<a href = \"somepage.php\">$row->artist;</a>";

 

or

 

echo "<a href = \"somepage.php\">$row->artist</a>";

[GoneNowBye]

echo('<a href="view_artist_details.php?id='.$row->id.'">'.$row->artist.'</a><br>');

 

your welcome

[knaj11]

thanks alot  both of you it really did work...

[knaj11]

bout the double post....

 

i think you got it all wrong...

 

my first post w/ subject "SELECT QUERY HELP" was on how to query something base on its first letter....

 

my second post w/subject "a href to each result in a query" was on how my result queries to have links on it...

 

just to clear things up mod fenway..

 

im not sure if my pm for you was sent it was not in my sent items so i did it here instead.