Need Help getting the URL

[mlobrutto]

It has been some time since I have coded in php and I am having a mental block...
I have this code:

 <?php
include("includes/config.inc.php");
include("includes/connect.inc.php");

$query="SELECT * FROM spokespeople WHERE featured REGEXP '[[:<:]]yes[[:>:]]'LIMIT 3";
$result = mysql_query($query);

$columnes = 3; // Define number of columns our table should have.

//Create the table with images
    echo "<table width=\"100%\" border=\"0\" cellpadding=\"5\" cellspacing=\"4\">";
    for ($i=1; $rows=mysql_fetch_array($result); $i++) {
        $resto = ($i % $columnes);
        if ($resto == 1) {echo "<tr>";}
            echo "<td><div align=\"center\"><a href=\"my-website-url.php?id=".$rows['id']."\"><img src=\"sp_pics/".$rows['photo']."\" alt=\"".$rows['name']."\" width=\"76\" height=\"85\" border=\"0\" /><br /></a>".$rows['name']." <strong>id:".$rows['id']."</strong></td>";
        if ($resto == 0) {echo "</tr>";}
    }
    if ($resto <> 0) {
        $ajust = $columnes - $resto;
        for ($j = 0; $j < $ajust; $j++) {echo "<td>&nbsp;</td>";}
        echo "</tr>";
    }

echo "</table>";

// get value of id that sent from address bar
$id=$_GET['id'];

// Retrieve data from database 
$sql="SELECT * FROM $tbl_name WHERE id='$id'";
$result=mysql_query($sql);

$rows=mysql_fetch_array($result);
echo $rows['javacode'];
?>

And line 15 - where the code is:
a href=\"my-website-url.php?id=".$rows['id'].
I want to GET the URL of the current page where the code is and echo in replace of "my-website-url.php"

The get URL code that I have is:

$url="http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
echo $url;

How do I get this to work???

Thanks

[melsi]

Really don't see any difficulty if I am right. Is this want you want, run this code once and see the source code produced, is this what you want:

<?PHP

$dbq="\"";//these help read code easy

//this array is just for testing purpose
$rows['id']=5;
$rows['name']='John';
$rows['photo']='test.png';

//you could go this way, commas and single quotes
//are always faster than concatenation and double quotes

echo '<td><div align="center"><a href=',$dbq,'http://',$_SERVER['HTTP_HOST'],$_SERVER['REQUEST_URI'],
'?id=',$rows['id'],$dbq,'><img src=',$dbq,'sp_pics/',$rows['photo'],$dbq,' alt=',$dbq,$rows['name'],$dbq,
' width="76" height="85" border="0"><br/></a>',$rows['name'],'<strong> id:',$rows['id'],'</strong></td>'; 

?>

[samuelcook]

mlobrutto;10987622 wrote:

I want to GET the URL of the current page where the code is and echo in replace of "my-website-url.php"

replace my-website-url.php with $_SERVER['PHP_SELF']