Newbee needing help.....please

[thehappyappy]

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

[thetestingsite]

For one, where is $users being defined in which is in this line:

$id = $users['ID'];

#2: The following:

$ok1 = @mysql_query("DELETE FROM members WHERE " . "ID='$id'");

should be:

$ok1 = @mysql_query("DELETE FROM members WHERE `ID`='$id'");

and #3:

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

should be:

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

Hope this helps.

[thehappyappy]

Thanks for helping, I'm starting to understand it a bit more - albeit slowly

Originally Posted by thetestingsite

For one, where is $users being defined in which is in this line:

$id = $users['ID'];

I don't quite understand this bit - $users is the name of the the table (
$result = mysql_query("SELECT * FROM users"); ) Is that not right?

#2: The following:

$ok1 = @mysql_query("DELETE FROM members WHERE " . "ID='$id'");

should be:

$ok1 = @mysql_query("DELETE FROM members WHERE `ID`='$id'");

I guess when I get the previous bit right this bit will work?

and #3:

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

should be:

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

Hope this helps.

The email subject now works - thanks

[thetestingsite]

Sorry, didn't see you replied until just now. Anyways, I believe that if you change $users['ID'] to $row['ID'] all should be well. Let me know if you need anything else.

Hope this helps.

[thehappyappy]

yep you're right. Thanks