Delete user & file

[crazybrumi]

i want to be able to delete all files in the gallery and downlods on wapdesire v2 can anyone help.

iv tried and tried and tried but its getin me no where and its pissin meoff mnw

[subzero]

use this tool

uplink("pictures/$item[0]"); 

uplink is a php deleting tool

also add mysql to delete the sql

[morse]

PHP: unlink - Manual

Subzero might have typed it wrong in a hurry

[crazybrumi]

$file=mysql_fetch_array(mysql_query("SELECT  filename, path FROM gallery_files WHERE uid='".$who."'"));  $nick=explode("(",$file[0]); $filename=explode("gallery/",$file[1]);  unlink("../gallery/$filename[1]"); 

iv been bessing around with this all yesterday and it only deletes one when i try and make it to delete all it dosnt wana play ball
</span>

[subzero]

uplink is right ;)

[crazybrumi]

sub isnt it unlink not uplink if you wna delete

[syrus]

its quite easy @brumi if u do it like that only 1 record will b deleted. use a while statement but before u end it check if tha file exist then unlink. U could delete both user and file at once, send me that page n sql after work ill fix it up

[kiLLeR-eyEd_14]

uplink is right ;)

it's unlink..

[CreativityKills]

no it suplink() haa

[subzero]

geez i must be true nub spelling yeah its unlink

[kiLLeR-eyEd_14]

no it suplink() haa

i haven't used uplink but ok, i agree with you and subzero.,maybe you have tested it.,but also unlink is working too..That's what i use..From the word itself..Unlink..Means like to remove..Am i right?..unlink or uplink..whatever.,the important is what function will remove the file..Coz for me, unlink() works..

[subzero]

No its unlink a spelling error for me

[kiLLeR-eyEd_14]

No its unlink a spelling error for me

ok fine.,lol..i see..but letter n is far from letter p..mobile or pc..

[crazybrumi]

its quite easy @brumi if u do it like that only 1 record will b deleted. use a while statement but before u end it check if tha file exist then unlink. U could delete both user and file at once, send me that page n sql after work ill fix it up

yup you where right, i just coded and tryed this and it worked.

$sql = "SELECT  filename, path FROM gallery_files WHERE uid='".$who."'";
    $items = mysql_query($sql);
    echo mysql_error();


    if(mysql_num_rows($items)>0)
    while ($item = mysql_fetch_array($items))
    {
     $filename=explode("gallery/",$item[0]); 
     unlink("../gallery/$filename[0]");
    }

[syrus]

yup you where right, i just coded and tryed this and it worked.

$sql = "SELECT  filename, path FROM gallery_files WHERE uid='".$who."'";
    $items = mysql_query($sql);
    echo mysql_error();


    if(mysql_num_rows($items)>0)
    while ($item = mysql_fetch_array($items))
    {
     $filename=explode("gallery/",$item[0]); 
     unlink("../gallery/$filename[0]");
    }

also to avoid some errors in case the file dnt exist u cld use

 if(file_exist($file)){ unlink($link_variable); }