[font=Courier New][color=#0000cc][font=Verdana][color=#000000]Hya Guys… the script below deletes a file from the server and then deletes its corresponding mySQL entry.
What im trying to do next is sort all the remaing SQL entires from lowest to highest (by track number) and then remnumber them so that there are no gaps:[/color][/font]
[/color][/font]
[font=Courier New][color=#0000cc]
[/color][/font]
[font=Courier New][color=#0000cc]<?
[/color][/font][font=Courier New][color=#ff9900]//DELETE THE PHYSICAL FILE AND ITS DB ENTRY - renumber all tracks
[/color][color=#006600]if (isset([/color][color=#0000cc]$_POST[/color][color=#006600][[/color][color=#cc0000]'deletetrack'[/color][/font][font=Courier New][color=#006600]])){
[/color][color=#0000cc]$filename [/color][color=#006600]= [/color][color=#0000cc]$_POST[/color][color=#006600][[/color][color=#cc0000]'filename'[/color][/font][font=Courier New][color=#006600]];
[/color][color=#0000cc]$tracknum [/color][color=#006600]= [/color][color=#0000cc]$_POST[/color][color=#006600][[/color][color=#cc0000]'tracknum'[/color][/font][font=Courier New][color=#006600]];
[/color][color=#0000cc]$address [/color][color=#006600]= [/color][color=#cc0000]"../../audiofiles/$filename"[/color][/font][font=Courier New][color=#006600];
include ([/color][color=#cc0000]"../../includes/dbconnect.php"[/color][/font][font=Courier New][color=#006600]);
[/color][color=#0000cc]$select [/color][color=#006600]= [/color][color=#cc0000]"DELETE FROM tracks WHERE url = '$filename'"[/color][/font][font=Courier New][color=#006600];
[/color][color=#0000cc]$delete [/color][color=#006600]= [/color][color=#0000cc]mysql_query[/color][color=#006600]([/color][color=#0000cc]$select[/color][/font][font=Courier New][color=#006600]);
[/color][color=#0000cc]unlink [/color][color=#006600]([/color][color=#cc0000]"$address"[/color][/font][font=Courier New][color=#006600]);
[/color][color=#0000cc]$whatsleft [/color][color=#006600]= [/color][color=#cc0000]"SELECT * FROM tracks ORDER BY tracknums ASC"[/color][/font][font=Courier New][color=#006600];
[/color][color=#0000cc]$run [/color][color=#006600]= [/color][color=#0000cc]MYSQL_QUERY[/color][color=#006600]([/color][color=#0000cc]$whatsleft[/color][/font][font=Courier New][color=#006600]);
[/color][color=#0000cc]$rows [/color][color=#006600]= [/color][color=#0000cc]MYSQL_NUM_ROWS[/color][color=#006600]([/color][color=#0000cc]$run[/color][/font][font=Courier New][color=#006600]);
[/color][color=#0000cc]$fixi [/color][color=#006600]= [/color][color=#0000cc]1[/color][/font][font=Courier New][color=#006600];
WHILE ([/color][color=#0000cc]MYSQL_FETCH_ARRAY[/color][color=#006600]([/color][color=#0000cc]$run[/color][/font][font=Courier New][color=#006600])){
[/color][color=#0000cc]$update [/color][color=#006600]= [/color][color=#cc0000]"UPDATE tracks SET tracknums='$fixi'"[/color][/font][font=Courier New][color=#006600];
[/color][color=#0000cc]$doupdate [/color][color=#006600]= [/color][color=#0000cc]mysql_query[/color][color=#006600]([/color][color=#0000cc]$update[/color][/font][font=Courier New][color=#006600]);
[/color][color=#0000cc]$fixi[/color][/font][font=Courier New][color=#006600]++;
}
echo ([/color][color=#cc0000]"File $filename - has been removed!"[/color][/font][font=Courier New][color=#006600]);
[/color][color=#0000cc]$con[/color][color=#006600]->[/color][color=#0000cc]close[/color][/font][font=Courier New][color=#006600];
include ([/color][color=#cc0000]"upload.php"[/color][/font][font=Courier New][color=#006600]);
}
[/color][/font][color=#0000cc][font=Courier New]?> [/font]
[/color]
```php
At the moment all it does is set them to the total number of tracks that are in the db....can anyone help?