Grabbing links from table

dj_j3m

I'm trying to a file name and site link from a table in mysql, but can't figure out how to make the site link work correctly in <a href=".....

I can pull the file name from the table just fine, but can't figure out a way to pull the link from the table. Any suggestions?

<html>
<head>
<title> </title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>

<?php
  // Connect to the database server
  $dbcnx = @mysql_connect("localhost", "user", "pass");
  if (!$dbcnx) {
    echo("<p>Unable to connect to the database server at this time.</p>");
	exit();

  }

  // Select the sites database
  if (! @mysql_select_db("sites") ) {
    echo("<p>Unable to connect to the Sites database at this time.</p>");
	exit();
  }

  echo("<p>Use CTRL+F to search for the file you want.</p>");

  // Get the list of sites
  $result = @mysql_query("SELECT file_name FROM sites");
  if (!$result) {
    echo("<p>Error performing query: " . mysql_error() . "</p>");
	exit();
  }

  // Display the sites with the proper links

  while ($row = mysql_fetch_array($result) ) {
    echo("<p><a href=\"http://localhost\" target=\"_blank\">" . $row["file_name"] . "</a></p>\n");
  }

?>

</body>
</html>

When I try to put in a value for [url]http://localhost,[/url] I keep getting an error that says the variable is undefined. The variable I'm trying to put in there is "site_link".

Atom

First off I don't know where "site_link" is coming from or how it is formatted. I would store the link in the database with "file_name" and format it something like this:
http://your.website.com
This would allow you to change 2 lines of code and get your script working. The first line you would change would be your select statement. Change it from:

"SELECT file_name FROM sites"

"SELECT file_name, site_link FROM sites".

The second line to change would be where you echo your link. Change it from:

echo("<p><a href=\"http://localhost\" target=\"_blank\">" . $row["file_name"] . "</a></p>\n");

echo("<p><a href=\"" . $row["site_name"] . "\" target=\"_blank\">" . $row["file_name"] . "</a></p>\n");

I hope this helps you out a bit.

Atom

dj_j3m

I actually did store site_link in with file_name, but didn't know you could select two columns like that.

Learning something new everyday. 😃

Thanks

Atom

No problem buddy...we're all in this together eh? 🙂

Atom