[SOLVED] Need some help with syntax

[magicmoose]

I think I have the right idea with this code, I am just unsure of the correct syntax to use.  The following is meant to simply arrange the results of a query in a table.  However, I would like the first field of each row to echo as a unique hyperlink (based on $dbRecord["title"]) which can then be passed on to another page with GET.

 

while ($dbRecord=mysql_fetch_array($queryResult))

      {

        echo "<TR><TD><A href=\"comic.php?title=$dbRecord["title"]\">".$dbRecord["title"]."</A></TD>"."<TD>".$dbRecord["author"]."</TD>"."<TD>".$dbRecord["artist"]."</TD>"."<TD>".$dbRecord["publisher"]."</TD></TR>";

 

I know I have made a syntax error as I cannot get this to work yet, but are there any other problems with this?

Any help would be greatly appreciated, thanks!

 

 

[jcbarr]

You haven't closed your { } for starters.

 

Other then that I'm not sure yet.

 

Enclose it in php tags on the board and it should highlight it for you which will help.

 

<?php
while ($dbRecord=mysql_fetch_array($queryResult))
      {
        echo "<TR><TD><A href=\"comic.php?title=$dbRecord["title"]\">".$dbRecord["title"]."[/url]</TD>"."<TD>".$dbRecord["author"]."</TD>"."<TD>".$dbRecord["artist"]."</TD>"."<TD>".$dbRecord["publisher"]."</TD></TR>";
}
?>

 

[magicmoose]

Sorry, I have closed the tags, I just cut and pasted 1 line less than I should

[jcbarr]

From the color coding above you should see where your error is;

 

comic.php?title=$dbRecord["title"]

[willpower]

you have double open quotes that are unescaped.

 

You haven't closed your { } for starters.

 

Other then that I'm not sure yet.

 

Enclose it in php tags on the board and it should highlight it for you which will help.

 

<?php
while ($dbRecord=mysql_fetch_array($queryResult))
      {
        echo "<TR><TD><A href=\"comic.php?title=$dbRecord["title"]\">".$dbRecord["title"]."[/url]</TD>"."<TD>".$dbRecord["author"]."</TD>"."<TD>".$dbRecord["artist"]."</TD>"."<TD>".$dbRecord["publisher"]."</TD></TR>";
}
?>

 

Look at the colors.  You will see the blue in the echo statement.  this needs tro be fixed.

[willpower]

he types faster than me!!!

[magicmoose]

Thanks!