html - Issue with using php variable in hyperlink

Question

How do you use one php variable for the url in a hyperlink around another php variable? Below is my code, which is clearly not working. I want $url to be the hyperlinked text of $songTitle.

if ($result) {
    $numberOfRows = $result->num_rows;

    for($i=0; $i < $numberOfRows; $i++) {
        $row = $result->fetch_assoc();
        echo '<tr>';
        echo '<td>' . $row['artistName'] . '</td>';
        echo '<td>'<a href=". $row['url'] . > . $row['songTitle'] . </a> '</td>';
        echo '<td>' . $row['yOR'] . '</td>';
        echo '</tr>';
    }
}

Answer 1

You are not concatenating your strings properly.

for($i=0; $i < $numberOfRows; $i++) {
        $row = $result->fetch_assoc();
        echo '<tr>';
        echo '<td>' . $row['artistName'] . '</td>';
        echo '<td><a href="' . $row['url'] . '" >' . $row['songTitle'] . '</a></td>';
        echo '<td>' . $row['yOR'] . '</td>';
        echo '</tr>';
    }