GET variable after doing a Join Query
<p>For the code below, on the second link (<code>http://www...com/sandbox/comments/index.php?submission='.$row["title"].'</code>), I would like to pass $row["submissionid"], on as a GET variable.  I tried this and it caused all of the code below to produce a blank result.  Is there a way that I can do I want?</p>

<p>Thanks in advance,</p>

<p>John</p>

<pre><code>$sqlStr = "SELECT 
                s.loginid
                ,s.title
                ,s.url
                ,s.displayurl
                ,l.username
                ,COUNT(c.commentid) countComments
             FROM 
                 submission s
            INNER
             JOIN
                 login l
               ON
                s.loginid = l.loginid
             LEFT OUTER
             JOIN
                 comment c
                ON
                 s.submissionid = c.submissionid
             GROUP
                BY
                 s.submissionid
             ORDER  
                BY 
                 s.datesubmitted DESC
             LIMIT 
                 10";           

$result = mysql_query($sqlStr);

$arr = array(); 
echo "&lt;table class=\"samplesrec\"&gt;";
while ($row = mysql_fetch_array($result)) { 
    echo '&lt;tr&gt;';
    echo '&lt;td class="sitename1"&gt;&lt;a href="http://www.'.$row["url"].'"&gt;'.$row["title"].'&lt;/a&gt;&lt;/td&gt;';
    echo '&lt;/tr&gt;';
    echo '&lt;tr&gt;';
    echo '&lt;td class="sitename2"&gt;&lt;a href="http://www...com/sandbox/members/index.php?profile='.$row["username"].'"&gt;'.$row["username"].'&lt;/a&gt;&lt;a href="http://www...com/sandbox/comments/index.php?submission='.$row["title"].'"&gt;'.$row["countComments"].'&lt;/a&gt;&lt;/td&gt;';
    echo '&lt;/tr&gt;';
    }
echo "&lt;/table&gt;";    
</code></pre>
