Re: [Vfs-devel] Code issue in get_file.php3?

[Abdul-Wahid P. <ee...@we...>]

I changed the selection of the file to be id based in version 0.1.1 and
that is the current state of the CVS. I did that for the reason you
mentioned. That is, we may want multiple files with one name (definately
when we introduce directories :) ) so by selecting by the file_id (found
in the new db schemea in 0.1.1) we can have multiple files by the same
name.

I suggest you do one of two things. First, get the latest version out of
CVS, or secondly change file_id=$file to file_name=$file for doing the
testing.

Regards,

Abdul-Wahid



On Wed, 7 Jun 2000, Tony Kirk wrote:

> Hey there Abdul-Wahid,
> 
> Here is the line of code in question.
> 
> $sql = "select file, mime, size from files where file_id='$file'";
> 
> Found on line 13 of the new get_file.php3 you sent out today to be tested.
> Does this line of code work for you on your system? The original
> get_file.php3 had a different line.
> 
> $sql = "select file, mime, size from files where file_name='$file'";
> 
> The first sql statement makes sense to me being used as there may be
> multiple files with the same name. Changing file_id=$file to file_name=$file
> in the new get_file.php3 works of course. But did you want to recode that to
> use the files ID instead?
> 
> Regards,
> Tony Kirk
> 
> 
> _______________________________________________
> Vfs-devel mailing list
> Vfs...@li...
> http://lists.sourceforge.net/mailman/listinfo/vfs-devel
>