I need to make an echo into a url/link

Here is the code

PHP Code:

<?php
$con = mysql_connect("*****","*****","*****");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("*****", $con);

$result = mysql_query("SELECT * FROM Persons");


while($row = mysql_fetch_array($result))
  {
  echo "<br>";
  echo "" . $row['FirstName'] . "";
  echo "<br>";
  echo "" . $row['LastName'] . "";
  echo "<br>";
  echo "" . $row['LINK'] . "";
  echo "<br>";
  echo "" . $row['AddedDate'] . "";
  echo "<br>";
  echo "******************************";
  }
echo "</table>";

mysql_close($con);
?>

See where it says

PHP Code:

  echo "" . $row['LINK'] . ""; 


I need that to be a url, so can someone edit that echo so it will show as a url. And I can type in the url manually.

I need that to be a url

Then add the necessary HTML code to create a URL.

I did, the page shows up blank...

You need it to look like this:
echo '<a href="' . $row['LINK'] . '">Name of the Link</a>';

Assuming $row['LINK'] contains the url

PHP Code:

echo '<a href="' . $row['LINK'] . '">Link Text</a>'; 


A couple unrelated things:

Why are you appending the empty string to your variables?

PHP Code:

echo "" . $row['FirstName'] . ""; 


will function the same as:

PHP Code:

echo $row['FirstName']; 


There is a difference between single and double quotes. When a string is encased in double quotes it is parsed in order to determine if it contains any variables. This creates a small amount of unnecessary overhead if the string does not contain any variables. Normally you should use single quotes instead.
Ex.

PHP Code:

$name = 'Matt';
echo "My name is $name"; //will output My name is Matt
echo 'My name is $name'; //will output My name is $name 


Originally Posted by sith717

I did, the page shows up blank...

Then show us the code you had for that

Originally Posted by sith717

I need to make an echo into a url/link

Here is the code

PHP Code:

<?php
$con = mysql_connect("*****","*****","*****");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("*****", $con);

$result = mysql_query("SELECT * FROM Persons");


while($row = mysql_fetch_array($result))
  {
  echo "<br>";
  echo "" . $row['FirstName'] . "";
  echo "<br>";
  echo "" . $row['LastName'] . "";
  echo "<br>";
  echo "" . $row['LINK'] . "";
  echo "<br>";
  echo "" . $row['AddedDate'] . "";
  echo "<br>";
  echo "******************************";
  }
echo "</table>";

mysql_close($con);
?>

See where it says

PHP Code:

  echo "" . $row['LINK'] . ""; 


I need that to be a url, so can someone edit that echo so it will show as a url. And I can type in the url manually.

In PHP you can put whatever HTML code in a php code, not only links... Ya it should be put HTML code and put $row['LINK'] inside the <?php ?>

I think what you are looking for is this.


echo "<a href=\"http://www.google.com\">Name of the link</a>

OR

echo "<a href=\"$row['LINK']\">Name of the link</a>

Hope that helps.

the \" is used to echo " in php . because you cannot simply echo "

Prateek.
PDJSolutions.