href in mysql databse

10 Message(s) by 7 Author(s) originally posted in php sql

From: Matt Barbadian

Date: Tuesday, August 21, 2007

I have a html link

1. <file system> {hard link} or {symbolic link}.

	2. <hypertext> {hyperlink}.

	(1997-10-22)

in a mysql data

<data, data processing, jargon> /day't*/ (Or "raw data")
	Numbers, {characters}, {images}, or other method of recording,
	in a form which can be assessed by a human or (especially)
	input into a {computer}, stored and {processed} there, or
	transmitted on some {digital channel}.  Computers nearly
	always represent data in {binary}.

	Data on its own has no meaning, only when interpreted by some
	kind of {data processing system} does it take on meaning and
	become {information}.

	People or computers can find patterns in data to perceive
	information, and information can be used to enhance
	{knowledge}.  Since knowledge is prerequisite to wisdom, we
	always want more data and information.  But, as modern
	societies verge on {information overload}, we especially need
	better ways to find patterns.

	1234567.89 is data.

	"Your bank balance has jumped 8087% to $1234567.89" is
	information.

	"Nobody owes me that much money" is knowledge.

	"I'd better talk to the bank before I spend it, because of
	what has happened to other people" is wisdom.

	(1999-04-30)

base field

<data, database> An area of a {database} {record}, or
	{graphical user interface} {form}, into which a particular
	item of data is entered.

	Example usage: "The telephone number field is not really a
	numerical field", "Why do we need a four-digit field for the
	year?".

	A {database} {column} is the set of all instances of a given
	field from all records in a {table}.

	(1999-04-26)

that is getting queried
using PHP. My problem is when the page is rendered, the link displays
the html not an actual clickable link. Any help'd be greatly
appreciated.

Thanks

From: ZeldorBlat

Date: Tuesday, August 21, 2007

wrote in message:

I have a html link in a mysql database field that is getting queried
using PHP. My problem is when the page is rendered, the link displays
the html not an actual clickable link. Any help'd be greatly
appreciated.
Thanks

Tough to say what the problem might be -- you have not provided any of
your code.

From: Captain Paralytic

Date: Wednesday, August 22, 2007

wrote in message:
wrote in message:
> I have a html link in a mysql database field that is getting queried
> using PHP. My problem is when the page is rendered, the link displays
> the html not an actual clickable link. Any help'd be greatly
> appreciated.
> Thanks
Tough to say what the problem might be -- you have not provided any of
your code.

Seconded

From: mbarbs

Date: Wednesday, August 22, 2007

wrote in message:
wrote in message:
wrote in message:
> > I have a html link in a mysql database field that is getting queried
> > using PHP. My problem is when the page is rendered, the link displays
> > the html not an actual clickable link. Any help'd be greatly
> > appreciated.
> > Thanks
> Tough to say what the problem might be -- you have not provided any of
> your code.
Seconded

This is the PHP i'm using to talk

<chat, tool, networking, messaging> A {Unix} program and
	{protocol} supporting conversation between two or more users
	who may be logged into the same computer or different
	computers on a network.  Variants include {ntalk}, {ytalk},
	and {ports} or {emulators} of these programs for other
	{platforms}.

	{Unix} has the {talk} program and {protocol} and its variants
	{xtalk} and {ytalk} for the {X Window System}; {VMS} has
	{phone}; {Windows for Workgroups} has {chat}.  {ITS} also has
	a talk system.  These split the screen into separate areas for
	each user.

	{Unix}'s {write} command can also be used, though it does not
	attempt to separate input and output on the screen.

	Users of such systems are said to be in {talk mode} which has
	many conventional abbreviations and idioms.  Most of these
	survived into {chat} jargon, but many fell out of common use
	with the migration of {user} prattle from talk-like systems to
	{chat} systems in the early 1990s.  These disused
	talk-specific forms include:

	"BYE?" - are you ready to close the conversation?  This is the
	standard way to end a talk-mode conversation; the other person
	types "BYE" to confirm, or else continues the conversation.

	"JAM"/"MIN" - just a minute

	"O" - "over" (I have stopped talking).  Also "/" as in x/y - x
	over y, or two newlines (the latter being the most common).

	"OO" - "over and out" - end of conversation.

	"\" - Greek {lambda}.

	"R U THERE?" - are you there?

	"SEC" - wait a second.

	"/\/\/" - laughter.  But on a {MUD}, this usually means
	"earthquake fault".

	See also {talk bomb}.

	(1998-01-25)

with the mysql database:
<?php

require_once('../../includes/scripts/db_connector.php');
$connector = new DB_Connector();
$result = $connector -> query('SELECT * FROM questions WHERE topic_id
= 0');
echo

1. A {topic group} on {FidoNet}'s {echomail} system.

	Compare {newsgroup}.

	2. A {Unix} command that just prints its arguments.

	[{Jargon File}]

'<span class="title">Questions: Top 5</span>';
echo '<div class="title_rule"></div>';
while($row = $connector -> fetchArray($result)) {
echo '<div class="question">'.$row['question'].'</div>';
echo nl2br('<div class="answer">'.$row['answer'].'</div>');
echo '<div id="faq_bttn" class="faq_more"></div>';
echo '<div class="dotted_rule"></div>';
}
?>

The problem is I have this for example <a href="link.html">Link</a> in
one of the fields in the mysql database. When the page loads it shows
the html <a href="link.html">Link</a> NOT a clickable link.

From: J.O. Aho

Date: Wednesday, August 22, 2007

wrote in message:
wrote in message:
wrote in message:

wrote in message:
I have a html link in a mysql database field that is getting queried
using PHP. My problem is when the page is rendered, the link displays
the html not an actual clickable link. Any help'd be greatly
appreciated.
Thanks
Tough to say what the problem might be -- you have not provided any of
your code.
Seconded
This is the PHP i'm using to talk with the mysql database:
<?php
require_once('../../includes/scripts/db_connector.php');
$connector = new DB_Connector();
$result = $connector -> query('SELECT * FROM questions WHERE topic_id
= 0');
echo '<span class="title">Questions: Top 5</span>';
echo '<div class="title_rule"></div>';
while($row = $connector -> fetchArray($result)) {
echo '<div class="question">'.$row['question'].'</div>';
echo nl2br('<div class="answer">'.$row['answer'].'</div>');
echo '<div id="faq_bttn" class="faq_more"></div>';
echo '<div class="dotted_rule"></div>';
}
?>
The problem is I have this for example <a href="link.html">Link</a> in
one of the fields in the mysql database. When the page loads it shows
the html <a href="link.html">Link</a> NOT a clickable link.

The problem is how you store

[probably from "main store"] In some varieties of Commonwealth
	hackish, the preferred synonym for {core}.  Thus, "bringing a
	program into store" means not that one is returning
	shrink-wrapped software but that a program is being {swap}ped
	in.

	[{Jargon File}]

the value to the database, you most likely used
htmlentities() or a simialr function

1. <mathematics> (Or "map", "mapping") If D and C are sets
	(the domain and codomain) then a function f from D to C,
	normally written "f : D -> C" is a subset of D x C such that:

	1. For each d in D there exists some c in C such that (d,c) is
	an element of f.  I.e. the function is defined for every
	element of D.

	2. For each d in D, c1 and c2 in C, if both (d,c1) and (d,c2)
	are elements of f then c1 = c2.  I.e. the function is uniquely
	defined for every element of D.

	See also {image}, {inverse}, {partial function}.

	2. <programming> Computing usage derives from the mathematical
	term but is much less strict.  In programming (except in
	{functional programming}), a function may return different
	values each time it is called with the same argument values
	and may have {side effects}.

	A {procedure} is a function which returns no value but has
	only {side-effects}.  The {C} language, for example, has no
	procedures, only functions.  {ANSI C} even defines a {type},
	{void}, for the result of a function that has no result.

	(1996-09-01)

on the string

<programming> A sequence of {data} values, usually {bytes},
	which usually stand for {characters} (a "character string").
	The {mapping} between values and characters is determined by
	the {character set} which is itself specified implcitly or
	explicitly by the environment in which the string is being
	interpreted.

	The most common character set is {ASCII} but, since the late
	1990s, there has been increased interest in larger character
	sets such as {Unicode} where each character is represented by
	more than eight {bits}.

	Most programming languages consider strings (e.g.
	"124:shabooya:\n", "hello world") basically distinct from
	numbers which are typically stored in fixed-length {binary} or
	{floating-point} representation.

	A {bit string} is a sequence of {bits}.

	(1999-12-21)

before you stored it, which
makes it to be displayed as it's written and not parsed by the browser

<hypertext> A program which allows a person to read
	{hypertext}.  The browser gives some means of viewing the
	contents of {nodes} (or "pages") and of {navigating} from one
	node to another.

	{Netscape Navigator}, {NCSA} {Mosaic}, {Lynx}, and {W3} are
	examples for browsers for the {World-Wide Web}.  They act as
	{clients} to remote {web servers}.

	(1996-05-31)

as
html-code.--

//Aho

From: mbarbs

Date: Wednesday, August 22, 2007

wrote in message:
wrote in message:
wrote in message:
wrote in message:
wrote in message:
I have a html link in a mysql database field that is getting queried
using PHP. My problem is when the page is rendered, the link displays
the html not an actual clickable link. Any help'd be greatly
appreciated.
Thanks
> Tough to say what the problem might be -- you have not provided any of
> your code.
Seconded
> This is the PHP i'm using to talk with the mysql database:
> <?php
> require_once('../../includes/scripts/db_connector.php');
> $connector = new DB_Connector();
> $result = $connector -> query('SELECT * FROM questions WHERE topic_id
> = 0');
> echo '<span class="title">Questions: Top 5</span>';
> echo '<div class="title_rule"></div>';
> while($row = $connector -> fetchArray($result)) {
> echo '<div class="question">'.$row['question'].'</div>';
> echo nl2br('<div class="answer">'.$row['answer'].'</div>');
> echo '<div id="faq_bttn" class="faq_more"></div>';
> echo '<div class="dotted_rule"></div>';
> }
> ?>
> The problem is I have this for example <a href="link.html">Link</a> in
> one of the fields in the mysql database. When the page loads it shows
> the html <a href="link.html">Link</a> NOT a clickable link.
The problem is how you store the value to the database, you most likely used
htmlentities() or a simialr function on the string before you stored it, which
makes it to be displayed as it's written and not parsed by the browser as
html-code.
--
//Aho

Aho,
How'd you recommend the best way to do this?

From: J.O. Aho

Date: Wednesday, August 22, 2007

wrote in message:
wrote in message:

The problem is I have this for example <a href="link.html">Link</a> in
one of the fields in the mysql database. When the page loads it shows
the html <a href="link.html">Link</a> NOT a clickable link.
The problem is how you store the value to the database, you most likely used
htmlentities() or a simialr function on the string before you stored it, which
makes it to be displayed as it's written and not parsed by the browser as
html-code.

How'd you recommend the best way to do this?

If you use a form to input the data, you may need to use
html_entity_decode() to get rid of all htm encoded characters (you do not want
those)

Before you store data into the database, you want to run

<operating system, programming> The process of carrying out
	the {instructions} in a computer program by a computer.

	See also {dry run}.

	(1996-05-13)

addslashes(), this
prevents problems with " or ' in the strings.

And when you fetched the data from the database, use stripslashes(), before
you echo things out.

--

//Aho

From: mbarbs

Date: Wednesday, August 22, 2007

wrote in message:
wrote in message:
wrote in message:
> The problem is I have this for example <a href="link.html">Link</a> in
> one of the fields in the mysql database. When the page loads it shows
> the html <a href="link.html">Link</a> NOT a clickable link.
The problem is how you store the value to the database, you most likely used
htmlentities() or a simialr function on the string before you stored it, which
makes it to be displayed as it's written and not parsed by the browser as
html-code.
> How'd you recommend the best way to do this?
If you use a form to input the data, you may need to use
html_entity_decode() to get rid of all htm encoded characters (you do not want
those)
Before you store data into the database, you want to run addslashes(), this
prevents problems with " or ' in the strings.
And when you fetched the data from the database, use stripslashes(), before
you echo things out.
--
//Aho

Thanks Aho. But for right now i'm manually entering the data into
mysql.

From: Paul Lautman

Date: Wednesday, August 22, 2007

wrote in message:
wrote in message:
wrote in message:
The problem is I have this for example <a
href="link.html">Link</a> in one of the fields in the mysql
database. When the page loads it shows the html <a
href="link.html">Link</a> NOT a clickable link.
The problem is how you store the value to the database, you most
likely used htmlentities() or a simialr function on the string
before you stored it, which makes it to be displayed as it's
written and not parsed by the browser as html-code.
How'd you recommend the best way to do this?

If you use a form to input the data, you may need to use
html_entity_decode() to get rid of all htm encoded characters (you
do not want those)
Before you store data into the database, you want to run
addslashes(), this prevents problems with " or ' in the strings.
And when you fetched the data from the database, use stripslashes(),
before you echo things out.

Forget the stripslashes!

From: Tom

Date: Thursday, August 23, 2007

wrote in message...

I have a html link in a mysql database field that is getting queried
using PHP. My problem is when the page is rendered, the link displays
the html not an actual clickable link. Any help'd be greatly
appreciated.
Thanks

I'm guessing some special characters we likely converted, such as "<" to "<
or ">" to ">". Might be how it was stored in MySQL, or maybe a function
you're passing the results through before being output.
Tom
--
NewsGuy Takes Usenet

<messaging> /yoos'net/ or /yooz'net/ (Or "Usenet news", from
	"Users' Network") A distributed {bulletin board} system and
	the people who post and read articles thereon.  Originally
	implemented in 1979 - 1980 by Steve Bellovin, Jim Ellis, Tom
	Truscott, and Steve Daniel at Duke University, and supported
	mainly by {Unix} machines, it swiftly grew to become
	international in scope and, before the advent of the
	{World-Wide Web}, probably the largest decentralised
	information utility in existence.

	Usenet encompasses government agencies, universities, high
	schools, businesses of all sizes, and home computers of all
	descriptions.  In the beginning, not all Usenet hosts were on
	the Internet.  As of early 1993, it hosted over 1200
	{newsgroups} ("groups" for short) and an average of 40
	megabytes (the equivalent of several thousand paper pages) of
	new technical articles, news, discussion, chatter, and
	{flamage} every day.  By November 1999, the number of groups
	had grown to over 37,000.

	To join in you originally needed a {news reader} program but
	there are now several web gateways such as {Deja
	(http://www.deja.com/)}.  Several {web browsers} include news
	readers and {URLs} beginning "news:" refer to Usenet
	newsgroups.

	{Network News Transfer Protocol} is a {protocol} used to
	transfer news articles between a news {server} and a {news
	reader}.  The {uucp} {protocol} was sometimes used to transfer
	articles between servers, though this is probably rare now
	that most sites are on the {Internet}.

	{Stanford University} runs a service to send news articles by
	{electronic mail}.  Send electronic mail to
	<netnews@db.stanford.edu> with "help" in the message body.
	[Still?  URL?]

	{(http://www.openmarket.com/info/internet-index/current-sources.html)}.

	{Notes on news
	(http://www.ifi.uio.no/~larsi/notes/notes.html)} by Lars Magne
	Ingebrigtsen <larsi@ifi.uio.no>.

	[Gene Spafford <spaf@cs.purdue.edu>, "What is Usenet?",
	regular posting to {news:news.announce.newusers}].

	(1999-12-17)

Cellular!
Download newsgroup

<messaging> One of {Usenet}'s huge collection of topic groups
	or {fora}.  {Usenet} groups can be "unmoderated" (anyone can
	post) or "moderated" (submissions are automatically directed
	to a {moderator}, who edits or filters and then posts the
	results).  Some newsgroups have parallel {mailing lists} for
	{Internet} people with no netnews access, with postings to the
	group automatically propagated to the list and vice versa.
	Some moderated groups (especially those which are actually
	gatewayed {Internet} {mailing lists}) are distributed as
	"{digests}", with groups of postings periodically collected
	into a single large posting with an index.

	Among the best-known are comp.lang.c (the {C}-language forum),
	comp.arch (on computer architectures), comp.Unix.wizards (for
	{Unix wizards}), rec.arts.sf-lovers (for science-fiction
	fans), and talk.politics.misc (miscellaneous political
	discussions and {flamage}).

	Barry Shein <bzs@world.std.com> is alleged to have said,
	"Remember the good old days when you could read all the group
	names in one day?"  This gives a good idea of the growth and
	size of {Usenet}.

	See also {netiquette}.

	[{Jargon File}]

	(1994-12-13)

MP3's to your Cell or PDA
Free Trial - http://newsguy.com/cell

<networking> {ATM}'s term for a {packet}.

	(1996-08-21)

phone.htm

Next Message: mySql - find and replace.

Blogs related to href in mysql databse

Magazine publishing independent motor news and reviews.
... naruto videos for sale michelle livingston ps 188 kipkay marsupials teen girl holes casey stengel trattoria branica Jack sparrow/will turner epilepsy foundation fl k sallee proxy myspace acuvue oasys php mysql no database selected ...

Our site isn't just for kids.
used cars for under $1000 php mysql no database selected 92 28710355 7 thin woman free porn 966 25703462 orange and white gingham medium weight fabric bt adsl router 96 63351481 airsoft increase rate of fire asbestos los angeles dwp ...

Simplifying Security Management With Check Point's SMART ...
... indians personalized refrigerator magnet south of heaven west of hell hack crack chopper hats gran flamenco punta cana michigan detroit child chairs beam clamps eating habits ohio dog lexus nexus php mysql database leathers 81505 ...

Top 100 OpenOffice.org Search Report
Newsforge publishes a tutorial on Hooking OOo to MySQL. “Did you know that you can connect the OpenOffice.org office suite to a MySQL database? By combining the power of these two open source applications you can do things like . ...

Home of the funny and useful products.
diors farenheit notes naked schoolboys inca peru 92 3036 4954 29 they never love culture pdf annual report free companies ncic database 962 272 401 71 529 evaluations free pictures of bookmarks new hampshire bagppipe band or Natural gas ...

Welcome to my awesome website! Word up, you all.
brazilian clean up tv ad 92 3015 5980 90 9224 077 041 6 recent trends in crisil melissa schafner. e5900b att telephone download of imffilter manager the stock fund that never loses money mysql database dump chuck schaden flex shaft ...