Need to run while loop on a href tag

[Shibbs]

Hey folks,

I have the following problem, I have created a table that can be sorted and that records how often a link was clicked.
My problem is that at this point i can only set the id manually and not as a part of the while loop, meaning if I want my url to go
a certain site i am using the following code:

 <td bgcolor="gray"><a href="click.php?id=2">' . $row['url'] . '</td>

this code works fine but I dont want to have to set the ID to 2. I want the ID to automatically match the URL.

Here is the whole while loop:

 while ( $row = mysqli_fetch_assoc ( $result ) )
    {
            print '
            <tr>
            <td bgcolor="gray"><a href="click.php?id=2">' . $row['url'] . '</td>
            <td>' . $row['provby'] . '</td>
            <td>' . $row['description'] . '</td>
            </tr>';
    }
     
    print '</table>';

Please let me know if I didnt explain it clearly enough or if you need to see more code to help me.
I will be working on this for the rest of the night so i will reply fast

Thanks a lot!
Shibbs

[Shibbs]

Solved it!