Creating a database system for work

[brown2005]

Hi, I want to have a file on my website that stores paperwork for jobs. so say i have

 

paperwork_file

 

and in this i will have say a file for each customer (using there id)

 

1_file

2_file

3_file

 

then say for customer two (2_file) i would have these items in the file;

 

inventory_item

apprasil_item

jobsheet_item

 

 

if i wanted to be able to view these items can you read what items are in the file and be able to click on them to view them, or would i need to use a  mysql database and <a> to do this?

 

thanks in advance

 

 

 

 

 

 

 

 

 

[trq]

It would be much simpler and likely more efficient to use a database if thats your question.

[brown2005]

It would be much simpler and likely more efficient to use a database if thats your question.

 

yeah i meant like query the database then echo out like

 

where(){

 

echo'<a href=''>file name here</a>';

echo'<a href=''>second file name here</a>';

 

}

[JonnoTheDev]

yeah i meant like query the database then echo out like

Yes, you loop over a result set returned from a database query

$res = mysql_query("SELECT * FROM files WHERE customerId='123'");
while($row = mysql_fetch_assoc($res)) {
  print "<a href=...........
}

You get the idea