hyperlink

[phui_99]

Hi,

I tried to make hyperlink, but my code seemed to be not working.

Partial code below:

while($row = mysql_fetch_array($result))
{
echo ("<table border=1>");
echo ("<tr aling=center>");
echo ("<td width=40>");
echo ("AccNum");
echo ("</td>");
echo ("<td width=400>");
echo $row["<a href=\"http://www.blast.html\">AccNum</a>"];
echo ("</td>");
echo ("</tr>");
}

or Change like

echo ("<a href=\"http://www.blast.html\">$AccNum</a>");

Not working.

But I can get data if I dont want to make hyperlink.

I really appreciate your suggestions!

HR

[Anon]

This line of code:

echo $row["<a href=\"http://www.blast.html\">AccNum</a>"];

Needs to look more like:

echo "<a href=\"http://www.blast.com\">" . $row["AccNum"] . "</a>";

$row is an array, and all you need between the brackets ( [ and ] ) is the name of the row you wish to output. If you look before and after that, we have just plain text in quotes, with a . before and after the $row["AccNum"]. This is the concatenation operator, telling it to put these three strings together. Hope that helps!

Chris King

[Anon]

Hi,

Thank so much for your help.

When I used echo "<a href =\"http://www.blast..com\">"
.$row["AccNum"] . "</a>", I could retrieve AccNum.

Assume that my input AccNum 888, after I retrieved related information from database and AccNum, I want to make dynamic link to do further search. my hyperlink should be like followed.

http://www.blast.com/query?db=2&form=1&term=888.

So I tried to write code:

Code

echo ("<a href =\"http://www.blast.com/query?db=2&form=1&term=AccNum\">" . $row["AccNum"] . </a>");

---

After I clicked the AccNum hyperlink, I couldn't reach the direct link because hyperlink was changed into http://.../query?db=2&form=1&term=AccNum, not actuall number like 888.

If I tried to write alternative code like

Code

echo ("<a href= \"http://../..$term= $AccNum\">" .$row["AccNum"] . "</a>");

After clicked hyperlink, hyperlink's term is blank, no result either.

If I tried this way

Code:

---------------------------------------echo("<a href=\"http//www.blast.com/query?db=2&form=1&term= . $row["AccNum"] . \">" .$row["AccNum"] . "</a>");

Then I got parser error, expecting "T_String" or "T_Variable" or "T_Num_String".

Have any suggestions.

HR

[Anon]

Well, the parse error is here:

echo("<a href=\"http//www.blast.com/query?db=2&form=1&term= . <-- (RIGHT HERE) $row["AccNum"] --> (HERE TOO) . \">" .$row["AccNum"] . "</a>");

You need to close the quotes before you to $row["AccNum"] and after as well

so,

echo("<a href=\"http//www.blast.com/query?db=2&form=1&term=" . $row["AccNum"] . "\">" .$row["AccNum"] . "</a>");

Should work. Hope that helps!

Chris King

[phui_99]

Hi Chris,

Thank you so much for your helps.

The code is working now. It is great help.

HR