[RESOLVED] Few errors

[shqip]

I have a set of urls in a database and I want it so you could click on the "name" and it will send you to the url, how could I do that?

while($row = mysql_fetch_array($result))
  {
  echo "<tr><strong>";
  echo "<td><b>" . $row['url'], $row['Name'] . "</td>";
  echo "</strong></tr>";
  }

I the footer the same text on every page but I get this

All Rights Reserved mywebsite 200 - echo date("Y")

but what I want is this

All Rights Reserved mywebsite 2008 - 2009

my code

$footer= 'All Rights Reserved mywebsite 2008 - echo date("Y")';

[djjjozsi]

<?php

while ( $row = mysql_fetch_array( $result ) ) {
    echo "<tr><strong>";
    printf( '<td><b><a href="%s">%s</a></td>' , $row['url'], $row['Name'] );
    echo "</strong></tr>";
} 

?>

and

$footer= 'All Rights Reserved mywebsite 2008 -  ' . date("Y")'; 

[shqip]

The rights one worked fine after I took away the last" ' "

$footer= 'All Rights Reserved Digitalb Info 2009 - ' . date("Y");

The url worked but some of my data doesn't have a url so I get a url which links back to the current page what could I do about that?

Thanks so far djjjozsi

[djjjozsi]

doesn't have a url 

means that field is empty ?

check that with: if()

[shqip]

Where is this would the "if()" go?

printf( '<td><b><a href="%s"%s%s</a></td>' ,$row['url'] , 'target="_blank">' , $row['Name'] );

[djjjozsi]

if(empty($row['url']))
echo '<td>&nbsp;</td>';
else
printf( '<td><b><a href="%s" target="_blank">%s</a></td>' , $row['url'] , $row['Name'] ); 

[shqip]

Thank you very much djjjozsi

Final code:

  if(empty($row['url'])) 
  echo "<td>" . $row['Name']."</td>"; 
  else
  printf( '<td><b><a href="%s"%s%s</a></td>' ,$row['url'] , 'target="_blank">' , $row['Name'] );