Three questions:

setropets

First of all, how do you make a
link that will delete something from a database? Second, I have the
following code on it for the mail:

$db=mysql_connect("localhost","setropets_uk_db","------") or die
("cant
connect");
mysql_select_db("setropets_uk_db",$db) or die ("cant change");
$sendmail = "INSERT into Setro_Mail (to, from, subject, message) value
('$to', '$username', '$subject', '$message')";
$sendmail2 = mysql_query("UPDATE basic_users SET inbox=inbox+1 WHERE
user_name='$to'",$db);
if (sendmail) {
echo "You're message has been sent!";
}

It does $sendmail2, but not $sendmail. And it says it was sent
anyway. Third...How can you have it select mutiple things of mail
they have, or multiple pets? I can get it to display one, and then it will show the same thing agian. Please help me!

artic

i do not see where it is using the $sendmail or $sendmail2 in the script. i dont get why either one is running. thats all i saw.

setropets

what do you mean? It says the $sendmail and $sendmail2 at this:

sendmail = "INSERT into Setro_Mail (to, from, subject, message) value
('$to', '$username', '$subject', '$message')";
$sendmail2 = mysql_query("UPDATE basic_users SET inbox=inbox+1 WHERE
user_name='$to'",$db);

You don't see it? hm...

matt_4013

$sendmail = "INSERT into Setro_Mail (to, from, subject, message) value ('$to', '$username', '$subject', '$message')";

You aren't actually running that, it's just setting it into a variable. Try:

$sendmail = mysql_query("INSERT into Setro_Mail (to, from, subject, message) values('$to', '$username', '$subject', '$message')");

To get a link to delete something, I use something like this:

Page1:


// Show the link, with a query string to pass a value (in this case it's msg_id, which I'm using as an example of a unique identifier)

echo "<a href=\"delete.php?msg_id=$msg_id\">Delete this message</a>";

Page2:


if(isset($_GET['msg_id'])) {

// clean up the url passed data, so it's not malicious
$msg_id = addslashes(trim($msg_id));

// Create the query
$sql = "DELETE FROM table WHERE msg_id=$msg_id";

// Run the query
$result = mysql_query($sql, $db);

} else {

// If msg_id isn't set, then send the user back to the index
header("Location: index.php");
exit;

}

Hope that helps,
Matt