need to create a link which deletes a record based on login info.

[webguync]

any ideas on the error?

[webguync]

I fixed the MySQL error, but I now get this error.

 

Undefined variable: temp

 

know why this is?

 

here is the functionwhere that var appears.

 

function clean($value, $db = null) {
    $value = strip_tags($value);
    $value = htmlentities($value);
    $temp = @mysql_real_escape_string($value, $db)
        ? $value = $temp
        : $value = addslashes($value);
    return $value;
}

 

also, I think I am just going to create a file called delete.php and link to that file to delete the record.

 

Here is the code:

 

<?php
session_start();
//DELETE QUERY TO SELECT RECORD TO DELETE BASED ON LOGIN INFO.
$query_delete = "DELETE FROM Caris_log_March2010 WHERE user_id = $user_id AND Caris_roster_March2010.user_id = $user_id";
//echo $query; //for debugging test
$result_delete = mysql_query($query_delete) or trigger_error('Query failed: ' .mysql_error());
if ($result_delete)
{
echo "Delete Successful"
}// end if
else
{
echo "Failed"
} //end else
?>

 

I need to store $user_id in a session. I would like to add it to this function

 

function session_store($data) {
    $_SESSION = array_merge($_SESSION, $user);
}

 

how can I do this?