Hyperlink problems. Help?

kennyk

I know this is probably really simple, but it's driving me up a wall. I'm trying to convert one of the results from a DB query into a hyperlink but I kepp getting parse errors.

I've tried every combination I can think of but still get the same out come.

Here's the code:

<?
for($i = 0; $i < $numofrows; $i++) {
$row = mysql_fetch_array($result); //get a row from our result set
if($i % 2) { //this means if there is a remainder
echo "<TR bgcolor=\"white\">\n";
} else { //if there isn't a remainder we will do the else
echo "<TR bgcolor=\"#cccccc\">\n";
}
echo '<TD>' .$row['film_title'].' '.$row['film_details']." <a href=".$row["film_link"].">" Watch'</a></TD>\n';
echo "</TR>\n";
}
//now let's close the table and be done with it
echo "</TABLE>\n";
?>

Any help would be appreciated.

Thanks

Kenny K

laserlight

The problem is that you didnt consider what "Watch" was doing in the middle of your script.

<?php
for ($i = 0; $i < $numofrows; $i++) {
	$row = mysql_fetch_array($result); //get a row from our result set
	if ($i % 2) { //this means if there is a remainder
		echo "<TR bgcolor=\"white\">\n";
	} else { //if there isn't a remainder we will do the else
		echo "<TR bgcolor=\"#cccccc\">\n";
	}
	echo '<TD>' . $row['film_title'] . '<br>'
		. $row['film_details'] . '<br>'
		. '<a href="' . $row['film_link'] . '"> Watch</a></TD>' . "\n";
	echo "</TR>\n";
}
//now let's close the table and be done with it
echo "</TABLE>\n";
?>

hollyspringer

You need quotes around the link. Change:

echo '<TD>' .$row['film_title'].' '.$row['film_details']." <a href=".$row["film_link"].">"

to:

echo '<TD>' .$row['film_title'].' '.$row['film_details']." <a href='".$row["film_link"]."'>"

In words:

echo '<TD>' .$row['film_title'].' '.$row['film_details']." <a href=single_quote double_quote . $row["film_link"] . double_quote single_quote>"

webdes03

<?php
  echo '<a href="'.$row[column].'">Your link text</a>';
?>

<?php
  echo '<a href="'.$row[column].'">'.$row[column].'</a>';
?>

uses your value for the text of the link.