hyperlink a field with MYSQL

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
rfigley
Forum Commoner
Posts: 70
Joined: Sun Apr 21, 2002 7:10 pm

hyperlink a field with MYSQL

Post by rfigley »

I need to hyperlink a couple of fields in a row to another couple of links in the same row. Each row has a record of a member's name, thier e-mail address and their web address. How do I do this? Of course I want to use the e-mail and web addresses as the hyperlinks. I'll be hyperlinking their name and business, respectively.

Thanks
User avatar
hob_goblin
Forum Regular
Posts: 978
Joined: Sun Apr 28, 2002 9:53 pm
Contact:

Post by hob_goblin »

do you have any code already? if you have a script that prints all the info out, i'd gladly put in the code to make it hyperlink the email and web address
rfigley
Forum Commoner
Posts: 70
Joined: Sun Apr 21, 2002 7:10 pm

Post by rfigley »

Yes, here's what I have

Code: Select all

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


          echo "<tr><td> " . $row&#1111;'name'] . "</td><td> " . $row&#1111;'category'] . "</td><td> " . $row&#1111;'business_name'] . "</td><td> " . $row&#1111;'phone'] . "</td></tr>";

    &#125;
Post Reply