Please HELP ME with HTTP LINK

dcjones

Hi all. I have posted this problem before and have had some of you good people reply, but I don't understand the replies:

I have a database with a structure containing TEXT fields only.

When I retrieve the data I want to be able to use one of the fields as a link to another page & query.

the code I am using is as follows:

while ($row = @ mysql_fetch_array($result))

echo "\n\t<td background=\"../../Gif/Background.gif\"><font color=\"black\" face=\"arial\"size=\"-6\" ><a href=\"$url\"> $row["street"] </a>" .
"</td>\n</tr>";

The field concerned is $row["street" ] I want to convert the output into a temp URL to link to my other page. How can this be done. I have tried all the ways I know (which is not a lot) with no sucess. It was suggested that I use the code "><a href=\"$url\"> " but I am not sure if I am using it corectly.

Can you help please.

Dereck

goa103

hi,

first I don't think you should use @ with mysql_fetch_array, control your mysql_query first, and there shouldn't be any error message with mysql_fetch_array. if it happens, it means something is wrong with PHP or something. moreover if you use @ in a loop, it won't display anything at all! no error message, no nothing 🙂

about link. first avoid echo to generate HTML it's 10 times better and easier to use ?><?PHP

echo "\n\t<td background=\"../../Gif/Background.gif\"><font color=\"black\" face=\"arial\"size=\"-6\" ><a href=\"$url\"> $row["street"] </a>" .
"</td>\n</tr>";

\n: doesn't mean anything, use HTML tags! <BR>... same for \t
</tr>: you forgot <tr>, no?
...: use ?><?PHP and <?= ?> to quickly display a PHP value
$url: where does it come from ? does $row ["url"] existin your table ? you said you wanted to use an url from your query so...
$row["street"]: use the . operator to separate the text from the variable. It's so hard to understand what you're trying to do!

here's a clean and neat version:

... PHP ...
?><td background="../../Gif/Background.gif"><font color="black" face="arial"size="-6" ><a href="<?= $row ["url"] ?>"><?= $row["street"]?></a></td></tr><?PHP
... PHP ...

benefits:
- easier to write, easier to read, easier to debug. separate the script (PHP code and variables) from the design (HTML)
- no more \ 🙂
- if you plain to use a WYSIWYG software then It will understand that code, note the one you used with echo. or It will do something wrong and stupid with it.

So if you want to generate a link in PHP, simply use the A HTML tag and <?=?> tags to display PHP values

netizen

Not enough data here. Assuming that the variables are valid, it looks okay.

If you are calling the $url from the database it should be $row['url']

dcjones

Hi Guys,

You to guys are the best, it works,

I have been playing with this on and off for days. I THANK YOU BOTH for your help .

Thanks

Dereck