What is wrong with this href?

Tezread

Can anyone spot what is wrong with the code below. I am trying to display the coursename as a href with the briefdesc of the coursename below: The briefdesc displays but the coursename doesn't.


$user = "root"; 
$host = "localhost"; 
$password = ""; 
$connection = mysql_connect($host, $user, $password) or die ("Couldn't connect to server."); 
$database = "memlms"; 
$db = mysql_select_db($database) or die ("Couldn't select database."); 

$sql = "SELECT course_name, briefdesc, accreditingbody FROM trainingtopics WHERE elearning = 'yes' ORDER BY course_name"; 
//echo $sql."<br>"; 

$result = mysql_query($sql) or die(mysql_error()); 
echo $result."=result<br>"; 

while($row=mysql_fetch_array($result)) 
{ // NOTE this one ABOVE the echo 
//echo "result found!"; 
//echo $row[0];

echo '<a href="details.php?course=', urlencode($row[0]), '">',$row[0],'</a><br><br>'; 
echo $row[1],'</a><br><br>';

}

Tezread

sorry about the lack of tags- I have forgotten how to add them- could someone remind me_ I think it starts with [/php ?

Weedpacket

[php]...[/code]. Or change your preferences to use the interface with the formatting controls.

Or find one of your older posts that does have the tag and view its Edit page 🙂

marshallm

Two things I notice are that you have </a> on the second echo with no corresponding <a> tag, and you're using commas to separate the concatenated elements in your echo statements, where I would use a period.


echo '<a href="details.php?course='. urlencode($row[0]) .'">'. $row[0] .'</a><br><br>'; 
echo $row[1] .'<br><br>';

maxpup979

change this:


while($row=mysql_fetch_array($result)) 
{ // NOTE this one ABOVE the echo
//echo "result found!";
//echo $row[0];

echo '<a href="details.php?course=', urlencode($row[0]), '">',$row[0],'</a><br><br>'; 
echo $row[1],'</a><br><br>';

}

to this:


while($row=mysql_fetch_array($result)) 
{ // NOTE this one ABOVE the echo
//echo "result found!";
//echo $row[0];

echo '<a href="details.php?course='.urlencode($row[0]). '">'.$row[0].'</a><br><br>'; 

}

heh...just like the post above said...whoops...🙂