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
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