[SOLVED] Linking wrong

[mike12255]

im trying to use info from my db to create a link, but its just creating a link to the page its already on, anyone know why?

 

<?php
  $sql = "SELECT * FROM catagories";
		  $res = mysql_query($sql) or die (mysql_error());
		  while ($row = mysql_fetch_assoc($res)){
		  echo "<a href='".$row['name']."'>".$row['wantedname']."</a><br>";
		  }
?>
		  

[wildteen88]

What is the output of that code? Where should the user go when they click the link. You need to be more specific.

[mike12255]

well for example row['name'] of the first object in the db is:

 

../pfd/Martial Arts - Pressure Points - Military Hand To Hand Combat.pdf

 

and row['wantedname'] is:

 

Testing

 

so the first link should be

 

<a href= "../pfd/Martial Arts - Pressure Points - Military Hand To Hand Combat.pdf">Testing</a>

 

however the source its outputting for it is:

 

  <a href="">Testing</a><br>

 

its not linking it to anything

[wildteen88]

Are your sure there is a field called name in your catagories table?

[Andy-H]

<?php

error_reporting(E_ALL);

$sql = "SELECT * FROM catagories";
           $res = mysql_query($sql) or die (mysql_error());
           while ( $row = mysql_fetch_assoc($res) )
          {
           echo "<a href=\"" . urlEncode($row['name']) . "\">" . $row['wantedname'] . "</a><br >\n";
           }
?>

[mike12255]

...wildteen was right.

 

i guess i accidently hit shift when i was making my DB cause name is actually Name