Forums

PHP

This topic is locked

Accessing Records Question

Posted 14 May 2007 07:11:47
1
has voted
14 May 2007 07:11:47 Sean C posted:
I have a members name in one database...
I want to retrieve some data from another database and display it in
an HTML textarea or table with the username from the other database.
I have the following variables (I can do the sql stuff to get the
records)


(database 1) <?php echo $row_membrdb['username']; ?> = John
(database 2) <?php echo $row_addata['firstad']; ?> = <a href="<a href="www.domain.com/">www.domain.com/</a><?php echo $row_membrdb['username']; ?>/"><a href="www.domain.com/">www.domain.com/</a><?php echo $row_membrdb['username']; ?>/</a>

If I do this in my HTML it works as desired as far as how it's displayed

<textarea>
Go to the following url for more information
<a href="www.domain.com/">http://www.domain.com/</a><?php echo $row_membrdb['username']; ?><a href="www.domain.com/">http://www.domain.com/</a><?php echo $row_membrdb['username']; ?>/</a><br>Thank you
</textarea>

would display correctly in a text box.

Example 1.1
_____________________________________
Go to the following url for more information
www.domain.com/John/
Thank yo
_____________________________________

I want to achieve the same result is as follows

<textarea>
<?php echo $row_addata['firstad']; ?>
</textarea>

I want it to display like Example 1.1
www.domain.com/John/
but I get this in the text area.

Example 1.2
_____________________________________
Go to the following url for more information
<a href="www.domain.com/">http://www.domain.com/</a><?php echo $row_membrdb['username']; ?></span>/"><a href="www.domain.com/">http://www.domain.com/</a><?php echo $row_membrdb['username']; ?>/</a><br>Thank you
_____________________________________

Any idea how to get 1.2 to look like 1.1

Edited by - seancon1 on 14 May 2007 09:29:56

Edited by - seancon1 on 14 May 2007 09:34:27

Edited by - seancon1 on 14 May 2007 09:35:41

Edited by - seancon1 on 14 May 2007 09:36:39

Replies

Replied 07 Feb 2008 00:10:00
07 Feb 2008 00:10:00 Christie Applegate replied:
This is how I do it to go to an investor's website. Hopefully it will help you.

<a href="<?php echo $row_Investor['investorweb']; ?>"><?php echo $row_Investor['investorweb']; ?></a>

Reply to this topic