a href

[Anon]

Hi,

I have a table with two fields.
Name and URL

I have a basic search form thats connects to this php file to search and retrieve the name and the url.

<?php

mysql_connect (localhost, username, password);

mysql_select_db (dbname);

if ($URL == "")
{$URL = '%';}

$result = mysql_query ("SELECT * FROM test
WHERE URL LIKE '%$URL%'
");

if ($row = mysql_fetch_array($result)) {

do {
print $row["URL"];

} while ($row = mysql_fetch_array($result));

} else {print "Sorry, no records were found!";}

?>

What do I need to include in this code so that the url is active when returned.

Please help a beginner.

[narch31]

Well I am not sure how the URL is inserted into the database but you can try something like this.

<?
if ($row = mysql_fetch_array($result)) {

do {
?>
<a href=\"<?= $URL; ?>\">LINK NAME</a>
<?
} while ($row = mysql_fetch_array($result));

} else {print \"Sorry, no records were found!\";}

?>

[narch31]

In regards to my last reply, ignore the add_slashes() that the forum inserted.

[Anon]

Yes this will work fine.

When you store hyper links in a database it stores them as text ( varchar ), so when you call the data, you have to put the url field in the html link code.

<a href=\"<?= $URL; ?>\">LINK NAME</a>

Usually when I do this, I set the name code in the part for the link name, so my code looks like this on a loop.

<a href=\"<?= $URL; ?>\"><?= $name; ?></a>

Hope this helps.

Bob

[Anon]

Hi,

Thanks for helping. This is my code:

<?php

mysql_pconnect (localhost, username, password);

mysql_select_db (dmname);

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

if ($row = mysql_fetch_array($result)) {

do {
?>
<a href="<?=$URL;?>">LINK NAME</a> <BR><BR>
<?
} while ($row = mysql_fetch_array($result));

} else {print "Sorry, no records were found!";}

?>

Ok this works and brings up the link but it is not the link in the database.

It brings up the base url where the test script is.

Sorry, can you help with this again.

Justin.