need help in doing zip (badly need)

[osusano]

the link from outside is like this:

<a href="zip.php?project=project+123">project 123.zip</a>

i dont know if this is possible but maybe if this is possible can u help me here pls just badly needed.

//zip.php
include "connect.php";

$sqlQry = mysql_query("select * from testdata where pName = '$project'");
$numrows = mysql_num_rows($sqlQry);
if ($numrows >0){
while ($hrow = mysql_fetch_array($sqlQry)) {
$filename = $hrow["filename"];
system("/usr/bin/zip /home/test/".$project.".zip /home/test/".$filename);
}
}

well the code is like that and i want to zip the filenames generated from the sql and save it to the variable $project and canit be possible that the $project value has spaces?

[sijis]

i'm a bit confused..
you want to create a zip file based on the filename you get from the database?
or do you want to extract the zip file into your filesystem?

if you want to do my first question, then you'll be better off reading how to use either tar or gzip on your system. Find out how to append to a zip file, once you know how to do that, everything else should be quite easy.
to help you bit, this is what i'm thinking you might have to do.

sql query and get info.
if zip does not exist in filesystem then
create zip and add file to zip
if zip does exist then
add file to zip
continue until query is done.

i hope that helps you in something.