[RESOLVED] CONVERTING MYSQL DATA INTO LINKS

[m92g11]

Hi,

I have two tables, one is [FONT="System"]link_name[/FONT] and one is [FONT="System"]link_url[/FONT]. What I'm wanting to do is to display the row [FONT="System"]link_name[/FONT] onto the page and have the row [FONT="System"]link_url[/FONT] convert the [FONT="System"]link_name[/FONT] into an http link.

Any help would be greatly appropriated.

Thanks In Advance
- Michael

[dagon]

select and loop the results, what do you have so far?

[m92g11]

I have the script which queries the database and then displays the results on the page. But I'm stuck on the linking part. The code I have so far is listed below.

<?php

//Beginning
require_once("config.php");

//Connects to database
$connect = mysql_connect("$database_host", "$database_username", "$database_password") or die(mysql_error());
mysql_select_db("$database_name") or die(mysql_error());
if (!$connect)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("$database_name", $connect);

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

while($row = mysql_fetch_array($result))
  {
  echo $row['link_name'];
   echo "<br>";
     echo "<br>";
  echo $row['link_url'];
    echo "<hr>";
      echo "<br>";
  }

mysql_close($connect);

//Ending
?>

Thanks for replying so fast dagon. & I Hope this helps!

[dagon]

echo '<a href="'.$row['link_url'].'">'.$row['link_name'].'</a>';

[m92g11]

I think a better way to explain this is listed below:

Database:

-----------------------------------------------------

link_name +---------------+ link_url

Script One +--------------+ example.com
-----------------------------------------------------

Output:

Figure 1)
Instead of having the output look like the following:
[FONT="Times New Roman"]Script One

example.com[/FONT]

Figure 2)
It would be along the lines of the below example:
Script One

As you can see in figure 2, the link is clickable. Basically all I'm doing is taking the link from the row link_url and transforming it into a link using the data from the link_name row. If you catch my drift, you will totally understand what I'm trying to explain. So if you know how to develop this idea, than please share with me.

Thanks in Advance!
- Michael

[m92g11]

Dagon,

If you will please read my last post, I think you will understand what I'm trying to explain!

[dagon]

as far as i understand my example is exactly what you want, you just need to put it in your while loop:

<?php

//Beginning
require_once("config.php");

//Connects to database
$connect = mysql_connect("$database_host", "$database_username", "$database_password") or die(mysql_error());
mysql_select_db("$database_name") or die(mysql_error());
if (!$connect)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("$database_name", $connect);

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

while($row = mysql_fetch_array($result))
  {
echo '<a href="'.$row['link_url'].'">'.$row['link_name'].'</a><br>'; 
  }

mysql_close($connect);

//Ending
?>

[m92g11]

Is this what I'm missing:

<a href=

[m92g11]

Thanks Man, You helped me allot.

[dagon]

m92g11;10927395 wrote:

Is this what I'm missing:

<a href=

You where missing the html, not really a php issue. Please, use the thread tools above to mark as solved (if it is)

[m92g11]

Where would I put a line break at to put a space in between links

echo '<a href="'.$row['link_url'].'">'.$row['link_name'].'</a><br>';

[dagon]

The <br> is a html line break, its \n if its just text

[m92g11]

Yes I know But where would I put the <br> in the below text:

echo '<a href="'.$row['link_url'].'">'.$row['link_name'].'</a><br>';

[dagon]

There's already one in there.

[m92g11]

Thanks!

[Weedpacket]

O_o