[Resolved] Function to delete file

flashman84

Hey all,

I'm new to the boards, well new to posting usually I can find a solution by just searching. I am trying to make a function that will delete a file based on an ID that has been passed to it.

I have a database with records and there are 2 fields that are the names of a picture in a folder. If I delete the record I want to also delete the pictures that correspond to it. I attempted to do the following.


function deleteRecord($mid) {

$sql_snap1 = "SELECT snap1 FROM records WHERE rid='$mid'";
$sql_snap2 = "SELECT snap2 FROM records WHERE rid='$mid'";

$snap1 = mysql_query($sql_snap1);
$snap2 = mysql_query($sql_snap2);

chdir("../records");
unlink($snap1);
unlink($snap2);

$sql_rec = "DELETE FROM records WHERE mid=$mid";
$result_rec = mysql_query($sql_rec);

}

The problem is I get this error.

Warning: unlink(): No such file or directory in /home/clanmka/public_html/devel/records_func.php on line 58

Warning: unlink(): No such file or directory in /home/clanmka/public_html/devel/records_func.php on line 59

Can someone please help me figure out how to resolve this! Also all permissions on the folders are set correctly.

Thanks

Mordecai

You need to parse the results to your queries. Look up [man]mysql_fetch_array/man.

flashman84

Not sure I understand that exactly, I changed it to this and get the same errors.


function deleteRecord($mid) {

$sql_snap = "SELECT * FROM records WHERE mid='$mid'";
$result_snap = mysql_query($sql_snap);
$myrow_snap = mysql_fetch_array($result_snap);

$snap1 = $myrow_snap['snap1'];
$snap2 = $myrow_snap['snap2'];

chdir("../records");
unlink($snap1);
unlink($snap2);

$sql_rec = "DELETE FROM records WHERE mid=$mid";
$result_rec = mysql_query($sql_rec);

}

Mordecai

That looks like it should work, but I could be overlooking something. Echo out $snap1 and $snap2--make sure they're the filenames you think they are.

flashman84

Well the files arent there... this is the thing, the error is correct. But I never called the function and therefor didnt pass an ID. I wanted to use this function when I have files to delete but I cant even open the page that inlcudes my functions file because of this error.

Edit:

snap1 and snap2 are actuall blank variables at that point because the sql hasnt run correctly being that an id has not yet been passed

flashman84

Apparently I need a break, in my file i was using if statements to determine what action is being run.... made a mistake and used = instead of ==

works fine now, thanks for the help!