I've got an email link that I want to have a subject header, but I can't see to get it to work. I've got

print ("<p>"); 
PRINT "<b1>Username: </b1> "; 
print $row["usern"];
print ("<br>");  
PRINT "<b> Account number: </b> "; 
print $row["ID"]." ";
PRINT "<b> Password: </b> "; 
print $row["password"]." "; 
print "<a href='mailto:info@myemailaddy.com?subject=Reference:  .$row["usern"].'> Apply</a>" ;

but it just gives an error whenever I try to got to the page.
The error I get is

Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/west/public_html/search.php on line 147

On a seperate page I'm trying to delete details from the database. I'm using

}$id = $_GET['ID'];
$ok1 = @mysql_query("DELETE FROM members WHERE " . "ID='$id'");
if ($ok1) {
echo '<p>member deleted successfully</p>';
} else {
echo '<p>Error.' . mysql_error() . '</p>';

to delete that particular field but it just says

Parse error: syntax error, unexpected $end in /home/west/public_html/deletejob.php on line 30

but line 30 is empty. I think that 5'm getting the error because the previous page isn't sending the 'ID'. The previous page is

$result = mysql_query("SELECT * FROM users");
echo "<table width='100%' border='1'>
<tr>
<th>Account number</th>
<th>Username</th>
<th> Password </th>
<th>Email</th>
<th>Joined</th>
<th>Real Name</th>
<th></th>
</tr>";
while($row = mysql_fetch_array($result))
  {
   echo "<tr>";
$id = $users['ID'];
   echo "<td>" . $row['ID'] . "</td>";
  echo "<td>" . $row['usern'] . "</td>";
  echo "<td>" . $row['password'] . "</td>";
  echo "<td>" . $row['email'] . "</td>";
  echo "<td>" . $row['date'] . "</td>";
   echo "<td>" . $row['name'] . "</td>";
  echo "<td><a href='deleteuser.php?id=$id'>Delete user</a></td>";
  echo "</tr>";
  }
echo "</table>";
mysql_close($con);

Thanks

Replace:

print "<a href='mailto:info@myemailaddy.com?subject=Referenc e: .$row["usern"].'> Apply</a>" ;

with:

print '<a href="mailto:info@myemailaddy.com?subject=Referenc e: ' . $row['usern'] . '">Apply</a>';

And on the delete block, use a closing } at the end.

Originally Posted by mgraphic

Replace:

print "<a href='mailto:info@myemailaddy.com?subject=Referenc e: .$row["usern"].'> Apply</a>" ;

with:

print '<a href="mailto:info@myemailaddy.com?subject=Referenc e: ' . $row['usern'] . '">Apply</a>';

Brilliant thanks, that now works

And on the delete block, use a closing } at the end.

Also I added the closing } and I no longer get the error, but it's still not sending the ID.
The code that is supost to send the ID is

PHP Code:

$result = mysql_query("SELECT * FROM users");
echo "<table width='100%' border='1'>
<tr>
<th>Account number</th>
<th>Username</th>
<th> Password </th>
<th>Email</th>
<th>Joined</th>
<th>Real Name</th>
<th></th>
</tr>";
while($row = mysql_fetch_array($result))
  {
   echo "<tr>";
$id = $users['ID'];
   echo "<td>" . $row['ID'] . "</td>";
  echo "<td>" . $row['usern'] . "</td>";
  echo "<td>" . $row['password'] . "</td>";
  echo "<td>" . $row['email'] . "</td>";
  echo "<td>" . $row['date'] . "</td>";
   echo "<td>" . $row['name'] . "</td>";
  echo "<td><a href='deleteuser.php?id=$id'>Delete user</a></td>";
  echo "</tr>";
  }
echo "</table>";
mysql_close($con); 


I think that for both problems I just need to get it to send the information to the next page/email but I don't seem to be able to get that right.

instead of using $users[ID], use:

$id = $row['ID'];

Originally Posted by mgraphic

instead of using $users[ID], use:

$id = $row['ID'];

Okay, it's now sending the ID to the next page. but it's still not deleting the entry from the database, although it is saying

member deleted successfully

The code I've got to do that is:

PHP Code:

if (!@mysql_select_db("west_db")) {
exit('<p>Unable to connect to database.</p>');
}$id = intval($_GET['ID']);
$ok1 = mysql_query("DELETE FROM members WHERE ID =$id") or die(mysql_error());
if ($ok1) {
echo '<p>member deleted successfully</p>';
} else {
echo '<p>Error.' . mysql_error() . '</p>';
}
?> 


URL GET parameters are case sensitive, and since you are passing the parameter ?id=1 (for example), you will need to reflect that in your code. Calling intval($_GET['ID']) will return a zero integer.

$id = intval($_GET['id']);

Thank you so much for your help. It now works perfectly.

You forgot to scape the " in the $row['usern']

$var = $row['usern'];
print "<a href='mailto:info@myemailaddy.com?subject=Referenc e: $var'> Apply</a>" ;