Delete user & file

[crazybrumi]

i got a branching structure inplace swell to not cause error instead itl have an error message set by me.

[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); }

[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]");
    }

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

[subzero]

No its unlink a spelling error for me

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

geez i must be true nub spelling yeah its unlink

[CreativityKills]

no it suplink() haa

[kiLLeR-eyEd_14]

uplink is right ;)

it's unlink..

[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

[crazybrumi]

sub isnt it unlink not uplink if you wna delete

[subzero]

uplink is right ;)

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

[morse]

PHP: unlink - Manual

Subzero might have typed it wrong in a hurry

[subzero]

use this tool

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

uplink is a php deleting tool

also add mysql to delete the sql