Re: displaying hyperlinks in MySQL query results

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



krutec@easystreet.com (Rick Tucker) writes:
[ snip ]
> The first 3 columns return perfectly.  The Vendor URL data, on the other
> hand, is returned as text, rather than hyperlinks.  I've tried tweaking the
> code several different ways with no success.
> 
> The following code is what I started with.  It returns everything I need.
> The HTML table is formatted correctly.  I thought I could use a 'hypertext'
> datatype in MySQL, but from what I see there isn't any such datatype.  And
> I'm so new to PHP I don't know how to isolate the Vendor URL field and
> convert the results to links.  Any help would be appreciated.
[ snip ]

A hyperlink (such as you speak of) is an HTML construct. You can save
one as text in a database, but the contents of the database are still
text. It can be interpreted as hyperlinks by a web browser, but then
it must contains <a>-tags (or similar).

This is as such not really neither a php nor a mysql issue. When you
print the url field, you have to print the html tag you need as well,
like you have done with the other tags you use (<table>, <td> and so
on). eg. printf("<a href=\"%s\">%s</a>", $url, $url);

http://www.blooberry.com/indexdot/html is a nice html resource.

Also, mysql_fetch_array($result) is easier to use, as it gives you an
associative array, you don't need the indexes and it doesn't give much
overhead (or at least, it's not supposed to). I wouldn't use a
foreach() construct in your case, either, it's easier (and should be
more efficient) to use something like
  printf("<tr><td>%s</td><td>%s</td></tr>\n", $data[0], $data[1]);
and so on.


-- 
--Fredrik
... and furthermore ... I don't like your trousers.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux