dynamic links

[ekinzie]

I have a small database containing a large text field. The fields are coming from a user-submitted form. On the index page of my site, I'm displaying the 5 newest latest entries into the database but limiting the text field to 60 characters due to space limitations.

My question is this...how do I dynamically link the $card_number in this statement to a detail page where someone could the read the entire description.

$description=mysql_result($result,$i,"description");
$text = substr($description,0,60); 
$date=mysql_result($result,$i,"date");
echo "<FONT size=2><p>Card Number <b>$card_number</b> was entered in $city, $state on $date<br>
Decription: $text ...<p></font>";
</font>";

Any help would be greatly appreciated!

Thanks ~ Eric

[Kudose]

Assuming you have stored the link in the database under the column link, the code would look like this:

<?php
 $description=mysql_result($result,$i,"description");
  $text = substr($description,0,60);
  $date=mysql_result($result,$i,"date");
  $link = mysql_result($result, $i, "link");
  echo "<FONT size=2><p>Card Number <b><a href=\"$link\">$card_number</a></b> was entered in $city, $state on $date<br>
  Decription: $text ...<p></font>";
?>

[ekinzie]

I've not stored the link in the database. Actually, I want to build the links dynamically using a the static URL plus a variable (card number) from the database. I'm not sure how to write the code but here is how it will end up:

$card_number=mysql_result($result,$i,"card_number");
echo "<a href="http://www.mywebsite.com/results.php?=$card_number">Click here for details"</a>;

Thanks again!

[ekinzie]

Nevermind....huge DUH! I got it figured out. I'm not sure why I struggled with that but your post did point me in the right direction so thank you!!

Eric