Array with hyperlink

[Jay2391]

 

I need to pull some name from a db and as they show they all have a hyperlink that will show each users profile.... i did this but it is not working...any ideas....

 

<?php
   $q= "SELECT * FROM $users ORDER BY id DESC";
   $r = mysql_query($q);
   while($row = mysql_fetch_array($r)){

                                        $id = $row['id'];
		 $location = $row['location'];


      print '<table width="600" border="0" cellspacing="0" cellpadding="0"><tr>

        	  <tr>
              <td width="100" height="12" align="center" valign="middle" nowrap="nowrap" scope="col">
 <div align="left" class="style9"><a href=\"info.php?id=$id\">' .$id. '</a></div></td>
              </tr></table>';	 			 


  
        }
?>

[marcus]

With the hyperlink in place you're using single quotes to try to emit a variable.

 

Either escape the variable in the URL the way you escaped it when calling the text in between, or print the table cell with double quotes and escape those.

[Jay2391]

i do quite got what you said can you give me an example

[Barand]

In you print statement, swap the double quotes and single quotes.

 

$id = 42;

print '$id';        // --> $id

print "$id";        // --> 42