[RESOLVED] help with creating a dynamic link

auddog

I'm lost, how can I add a href to one of my selection results in php5. Here is part of my code along with what I think it should be. I'm getting a parse error, unexpected T_STRING:

if($stmt = $mysqli->prepare($sql))
{
/ execute our SQL query /
$stmt->execute();
/ bind the results /
$stmt->bind_result($id, $comp_name, $comp_address, $comp_city);
/ loop over the result set /
while ($stmt->fetch())
{
/ echo our table rows /
echo '<tr><td>echo("<A HREF='view_company_project.php?comp_id=.$id.'>")</td><td>'.$comp_name.'</td><td>'.$comp_address.'</td><td>'.$comp_city.'</td></tr>';
}
}

thanks for any help you can provide.

tsinka

Hi,

check the echo line. It's a mixture of two echo statements.

Thomas

halojoy

colors make it easier to find such syntax errors

<?php

if($stmt = $mysqli->prepare($sql))
{
/*** execute our SQL query ***/
$stmt->execute();
/*** bind the results ***/
$stmt->bind_result($id, $comp_name, $comp_address, $comp_city);
/*** loop over the result set ***/
while ($stmt->fetch())
{
/*** echo our table rows ***/
echo '<tr><td>echo("<A HREF='view_company_project.php?comp_id=.$id.'>")</td>
<td>'.$comp_name.'</td>
<td>'.$comp_address.'</td><td>'.$comp_city.'</td></tr>';
}
}

?>

auddog

I confused on where to place the single quote, since I put it on each side of the variable - see below:

echo '<tr><td><A HREF='view_company_project.php?comp_id=.$id.'></td><td>'.$comp_name.'</td>

auddog

sorry, I don't know how to put my post inside another box like that!

abc123

When you are doing a reply look at the toolbar at the top where you can select things like Bold and italic.

There is a little button with php written on it. Select the text you want to put into a formatted php box and click the button. It will surround it in the appropriate tags. This certainly does make it easier to see syntax errors.

abc123

In relation to your problem I think you can put the whole thing within double quotes. The varialbe will still be read as a variable.

Also you haven't closed the anchor or have any text in it.

echo "<tr><td><A HREF=view_company_project.php?comp_id=$id>My dynamic link</a></td><td>$comp_name</td>"

Try it and let us know if this works.

auddog

That works great. Thanks for the help. I really have troubles with single quotes and double quotes. Is there a tutorial on this anywhere? Thanks again for the help.

tsinka

The manual contains a nice section about strings.

abc123

The PHP manual would be the place to go. Under "types" you can read about Strings. You might find heredoc useful if you want to echo html. All in the manual. 🙂

PHP Manual Strings

Enjoy.

Apologies. Hadn't noticed this information had already been posted. Doh!