[Resolved] SIMPLE - need basic syntax for embedding HTML link in PHP

printelectric

Really simple question -

I'm working with DreamWeaver (sorry if that's against etiquette -- but you gotta start somewhere).

I have a DreamWeaver "repeating region", which pulls data from a MySQl database and dumps results into a table. All of this is working fine.

I've pasted in my code for the table, which is working fine without the link. I've also pasted in what I think the link should be - this would replace everythin in the second <td> </td> - within the first chunk of code.

Could someone please let me know if I'm on the right track, or if I should try a completely different approach? I think this is just a syntax problem with quoting or concatenation or something.

Help!

<table>
  <?php do { ?> 
  <tr> 
    <td><?php echo $row_returnAllProjects['project_id']; ?></td>
    <td><?php echo $row_returnAllProjects['projectName']; ?></td>
    <td><?php echo $row_returnAllProjects['projectSum']; ?></td>
    <td><?php echo $row_returnAllProjects['dueDate']; ?></td>
    <td><?php echo $row_returnAllProjects['initDate']; ?></td>
  </tr>
  <?php } while ($row_returnAllProjects = mysql_fetch_assoc($returnAllProjects)); ?>
</table>

<?php echo "<a href='projectDetail?project_id='" . $row_returnAllProjects[project_id] . '>' . $row_returnAllProjects[project_name]. "</a>" ?>

m_tt

Definately a syntax problem...

Either of these would work:

<a href="projectDetail?project_id=<?php echo $row_returnAllProjects['project_id']; ?>"><?php echo $row_returnAllProjects['project_name']; ?></a>

<?php	
echo '<a href="projectDetail?project_id=' . $row_returnAllProjects['project_id'] . '">' . $row_returnAllProjects['project_name'] . '</a>';
?>

I believe your problem was with '>', it should've been "'>" for the correct syntax but I don't believe single quotes work like that in HTML (i've never tried it though).

laserlight

This might be what you are looking for.

<?php echo "<a href='projectDetail?project_id='" . $row_returnAllProjects['project_id'] . '>' . $row_returnAllProjects['project_name']. "</a>" ?>

Basically, the indices of the associative array $row_returnAllProjects are properly delimited, since they are strings, not undefined constants.

m@tt, using single quotes to enclose values in HTML tags should be acceptable, though I prefer using double quotes.

printelectric

Thanks to both for the replies. M@tt - your first option didn't work right out of the box - I was getting a parse error - but it led me to mess around with the single vs. double quotes a few times, and was able to get it fixed. I'm still not exactly sure what the problem was. Thanks alot for your time!

Scott