Need help on how to hyperlink query results in a table!

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
affluent980
Forum Newbie
Posts: 3
Joined: Thu Jan 29, 2009 1:52 pm

Need help on how to hyperlink query results in a table!

Post by affluent980 »

I have a block of code that displays the contents of my table for leads that i collect. I want to be able to hyperlink the "LeadID" so that when clicked, I can a page that displays that lead's info so i can then edit it if necessary. How do i make each returned "LeadID" hyperlinked so it will go to the next page? Here is my code so far that shows the table and i want to make LeadID hyperlinked to go to my next page details.php . Please help!!!

while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['LeadID'] . "</td>";
echo "<td>" . $row['CID'] . "</td>";
echo "<td>" . $row['Category'] . "</td>";
echo "<td>" . $row['Name'] . "</td>";
echo "<td>" . $row['Email'] . "</td>";
echo "<td>" . $row['Phone'] . "</td>";
echo "<td>" . $row['Date'] . "</td>";
echo "<td>" . $row['Time'] . "</td>";
echo "<td>" . $row['Keyword'] . "</td>";
echo "<td>" . $row['More'] . "</td>";
echo "<td>" . $row['Less'] . "</td>";
echo "<td>" . $row['Closed'] . "</td>";
echo "<td>" . $row['Revenue'] . "</td>";
echo "</tr>";
}
mavieng
Forum Newbie
Posts: 10
Joined: Thu Jan 29, 2009 12:34 pm

Re: Need help on how to hyperlink query results in a table!

Post by mavieng »

while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td><a href=\"details.php?leadID=$row['LeadID']\"" . $row['LeadID'] . "</a></td>";
echo "<td>" . $row['CID'] . "</td>";
echo "<td>" . $row['Category'] . "</td>";
echo "<td>" . $row['Name'] . "</td>";
echo "<td>" . $row['Email'] . "</td>";
echo "<td>" . $row['Phone'] . "</td>";
echo "<td>" . $row['Date'] . "</td>";
echo "<td>" . $row['Time'] . "</td>";
echo "<td>" . $row['Keyword'] . "</td>";
echo "<td>" . $row['More'] . "</td>";
echo "<td>" . $row['Less'] . "</td>";
echo "<td>" . $row['Closed'] . "</td>";
echo "<td>" . $row['Revenue'] . "</td>";
echo "</tr>";
}
affluent980
Forum Newbie
Posts: 3
Joined: Thu Jan 29, 2009 1:52 pm

Re: Need help on how to hyperlink query results in a table!

Post by affluent980 »

That didn't work. Got this error:

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/content/c/c/u/ccunet/html/leads.php on line 56
mavieng
Forum Newbie
Posts: 10
Joined: Thu Jan 29, 2009 12:34 pm

Re: Need help on how to hyperlink query results in a table!

Post by mavieng »

Sorry there was a problem with quotes. It working now


while($row = mysql_fetch_array($result))
{
$leadID = $row['LeadID'];

echo "<tr>";
echo "<td><a href=\"details.php?leadID=$leadID\">$leadID</a></td>";
echo "<td>" . $row['CID'] . "</td>";
echo "<td>" . $row['Category'] . "</td>";
echo "<td>" . $row['Name'] . "</td>";
echo "<td>" . $row['Email'] . "</td>";
echo "<td>" . $row['Phone'] . "</td>";
echo "<td>" . $row['Date'] . "</td>";
echo "<td>" . $row['Time'] . "</td>";
echo "<td>" . $row['Keyword'] . "</td>";
echo "<td>" . $row['More'] . "</td>";
echo "<td>" . $row['Less'] . "</td>";
echo "<td>" . $row['Closed'] . "</td>";
echo "<td>" . $row['Revenue'] . "</td>";
echo "</tr>";
}
Post Reply