[SOLVED] Echo Link?

[Lambneck]

Hello,

How can I echo a mysql row as a link?

for example, I tried the following but it didnt work:

 

while($row = mysql_fetch_array($result))
{
	echo '<a href=www.mysite.com/display.php">'$row['col_4']'</a>';
	echo "<br />";
}
mysql_free_result($result);
?>

 

any suggestions?  ???

[uniflare]

you are using a literal string, you have two options:

 

concatenate

		echo '<a href="www.mysite.com/display.php">'.$row['col_4'].'</a>';

 

or inline

		echo "<a href='www.mysite.com/display.php'>'$row['col_4']'</a>";

 

make sure any quotes are escaped, eg:

 

		echo "<a href=\"www.mysite.com/display.php\">'$row['col_4']'</a>";

 

hope thsi helps,

[blackcell]

To bounce off this and save a topic, what does literal really mean?

[uniflare]

literal means it does not parse variables or newlines etc in string declerations...

 

example

echo "this line\nis broken";

would output

this line
is broken

--

whereas

echo 'this line\nis broken";

 

would 'literally' output

this line \nis broken

[Lambneck]

hmm, it still didn't work.

this is the code as it is now:

 

if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");

$result = mysql_query("SELECT col_4 FROM {$table}");
if (!$result) {
    die("Query to show fields from table failed:".mysql_error());
}

while($row = mysql_fetch_array($result))
{
	echo "<a href=\"www.mysite.com/display.php\">'$row['col_4']'</a>";
	echo "<br />";
}
mysql_free_result($result);

[zenag]

can u make a try at this....

echo "<a href=\"www.mysite.com/display.php\">'$row[col_4]'</a>";

[Lambneck]

Hey thanks Zenag it worked!

 

[blackcell]

Lambneck, what you have to watch for in php is the way you use double and single quotes together. Double quotes will override everything where singles can be used within double. So I always try to use doubles on everything so if the need arises for singles I can easily add them in without thinking of escaping things. I don't know if this is proper or not but it is the style I have gotten used to.