Inserting a href

Anthony1312002

Can anyone tell me how I can create a href link beside each record row in the script below? For example:

ANumber FirstName LastName Action
A081512 Anthony Phillips herf

<?
include ("Header.inc.php");
include ("DBConnection.inc.php");
?>
<html>
<head>

<Title>Retrieving Data from a Database</Title>
<Body>
<?

// Set the Variables for the database access:

$Query = " SELECT * FROM activitytracking WHERE DateOfService BETWEEN '%".$POST[txtStartDate]."%' AND '%".$POST[txtEndDate]."%' GROUP BY SiteID";
$Result = mysql_db_query ($DBName, $Query, $Link);

//print "$Query";

print "<table border=1 align=center >";

while ($Row = mysql_fetch_array ($Result)) {

print "<tr>";
print "<td > $Row[ANumber]</td>
       <td> $Row[FirstName]</td>
	   <td>$Row[LastName]</td>
	   <td> $Row[Department]</td>
	   <td> $Row[TeamLeader]</td>
	   <td> $Row[DateOfService]</td>
       <td> $Row[NumberOfHours]</td>
	   <td> $Row[ActivityType] 
	   <td> $Row[Org]</td></td>
       <td> $Row[Description]</td> 
	   <td> $Row[TimeTakenWhen]</td> 
	   <td> $Row[SiteID]</td>";
print "</tr>";

} print "</table>";

kevinsequeira

<td><a href=whatever_page.php?var1=$var1_value&var2=$var2_value> $Row[Department]</a></td>

reg
kevin

superwormy

Um...

Pretty basic HTML....

Anthony1312002

Thanks for the help guys but I'm not having any success. I'm getting this error. The name of this page is called results.php. As you can see I'm trying to create a href beside each record that will allow me to edit or delete that record. Line 46 is in bold. I've also included the delete query that I'm trying to use in connection with the herf. What am I missing?

Parse error: parse error, unexpected T_STRING in c:\program files\apache group\apache\htdocs\communityservice\results.php on line 46

<?
include ("Header.inc.php");
include ("DBConnection.inc.php");
?>
<html>
<head>

<Title>Retrieving Data from a Database</Title>
<Body>
<?

// Set the Variables for the database access:

$Query = " SELECT * FROM activitytracking WHERE DateOfService BETWEEN '%".$POST[txtStartDate]."%' AND '%".$POST[txtEndDate]."%' GROUP BY SiteID";
$Result = mysql_db_query ($DBName, $Query, $Link);

// run SQL against the DB
$Result = mysql_query($Query);
echo "Record deleted!<p>";
if ($delete) {
// delete a record
$$Query = "DELETE FROM activitytracking WHERE CommID=$CommID";
$result = mysql_query($Query);
echo "Record has been deleted!<p>";
}

//print "$Query";

print "<table border=1 align=center >";

while ($Row = mysql_fetch_array ($Result)) {

print "<tr>";
print "<td > $Row[ANumber]</td>
       <td> $Row[FirstName]</td>
	   <td>$Row[LastName]</td>
	   <td> $Row[Department]</td>
	   <td> $Row[TeamLeader]</td>
	   <td> $Row[DateOfService]</td>
       <td> $Row[NumberOfHours]</td>
	   <td> $Row[ActivityType] 
	   <td> $Row[Org]</td></td>
       <td> $Row[Description]</td> 
	   <td> $Row[TimeTakenWhen]</td> 
	   <td> $Row[SiteID]</td>
	   [b]<td>"<a href=results.php?var1=$var1_value&var2=$var2_value> $Row[Department]</a>"</td> ;[/b]

print "</tr>";

} print "</table>";

superwormy

Strings need to be enclosed in " quotes ", and quotes within strings need to be \" escaped \" quotes.


<?php

print "<tr>"; 
print "<td > $Row[ANumber]</td> 
<td> $Row[FirstName]</td> 
<td>$Row[LastName]</td> 
<td> $Row[Department]</td> 
<td> $Row[TeamLeader]</td> 
<td> $Row[DateOfService]</td> 
<td> $Row[NumberOfHours]</td> 
<td> $Row[ActivityType] 
<td> $Row[Org]</td></td> 
<td> $Row[Description]</td> 
<td> $Row[TimeTakenWhen]</td> 
<td> $Row[SiteID]</td> 
<td><a href=\"results.php?var1=$var1_value&var2=$var2_value\"> $Row[Department]</a></td>"; 

?>

Anthony1312002

Thanks for the help. I've inserted the code and it's working just fine, but I dont know how to link the href with the delete sql statement. This is really my first time trying to program in PHP. Look at what I've done so far. My delete query and the delete href that I'm trying to use are in bold.

<?
include ("Header.inc.php");
include ("DBConnection.inc.php");
?>
<html>
<head>

<Title>Retrieving Data from a Database</Title>
<Body>
<?

// Set the Variables for the database access:

$Query = " SELECT * FROM activitytracking WHERE DateOfService BETWEEN '%".$POST[txtStartDate]."%' AND '%".$POST[txtEndDate]."%' GROUP BY SiteID";
$Result = mysql_db_query ($DBName, $Query, $Link);

if ($delete) {
// delete a record
$sql = "DELETE FROM activitytracking WHERE CommID=$CommID";
$result = mysql_query($sql);
echo "Record has been deleted!<p>";
}

//print "$Query";

print "<table border=1 align=center >";

while ($Row = mysql_fetch_array ($Result)) {

print "<tr>";
print "<td> $Row[ANumber]</td>
       <td> $Row[FirstName]</td>
	   <td> $Row[LastName]</td>
	   <td> $Row[Department]</td>
	   <td> $Row[TeamLeader]</td>
	   <td> $Row[DateOfService]</td>
       <td> $Row[NumberOfHours]</td>
	   <td> $Row[ActivityType] 
	   <td> $Row[Org]</td></td>
       <td> $Row[Description]</td> 
	   <td> $Row[TimeTakenWhen]</td> 
	   <td> $Row[SiteID]</td>
	   [b]<td><td><a href=\"$PHP_SELF?var1=$var1_value&var2=$var2_value\">(delete) $Row[CommID]</a></td>";[/b]

print "</tr>";

} print "</table>";