Help Assigning an Array Value to an HREF

[zbert]

I can use some help. I want to loop through my array and create a table which I have no problem with. The left two columns will display "Edit" and "Delete" links. My question is this, "How do I apply the $pid value to the Edit and Delete links so that I can pass them to the appropriate functions?"

<?
while($qdata = mysql_fetch_array($result)) {
      $pid	 = $qdata["pid"];
      $fname   = $qdata["fname"];
      $lname   = $qdata["lname"];
      $age	 = $qdata["age"];
      echo "<tr>\n";
      echo "<td nowrap bgcolor=\"$cfgThBgcolor\"><a href=$PHP_SELF?cmd=Edit>Edit</a></td>\n";
      echo "<td nowrap bgcolor=\"$cfgThBgcolor\"><a href=$PHP_SELF?cmd=Delete>Delete</a></td>\n";
      echo "<td nowrap bgcolor=\"$cfgBgcolorOne\">$fname</td>\n";
      echo "<td nowrap bgcolor=\"$cfgBgcolorOne\">$lname</td>\n";
      echo "<td nowrap bgcolor=\"$cfgBgcolorOne\">$age</td>\n";
      echo "</tr>\n";
   }
?>

Thanks for the help.

--zbert

[zbert]

Here's a partial answer to my own question. Now if I could only figure out how to use $PID in my function. My problem is that the value is always that of the last iteration of the loop.

echo "<td nowrap bgcolor=\"$cfgThBgcolor\"><a href=$PHP_SELF?cmd=Edit&pid={$qdata["pid"]}>Edit</a></td>\n";
echo "<td nowrap bgcolor=\"$cfgThBgcolor\"><a href=$PHP_SELF?cmd=Delete&pid={$qdata["pid"]}>Delete</a></td>n";

--zbert

[zbert]

I was able to get things working the way I wanted. I had to change the query string from "pid" to "rcd" because pid was the name of the original variable. So basically I loop through the array and assign pid to rcd for the query string. This gets each record id and allows me to pass it to my edit and delete functions.

echo "<td nowrap bgcolor=\"$cfgThBgcolor\"><a href=$PHP_SELF?cmd=Edit&rcd={$qdata["pid"]}>Edit</a></td>\n";