Recent content by patweb

Default print out is A4, is A5 (the half of A4) also possible. Or can you even print an A4 in a folder format (3 times fold).

Is its possible to run a query on another query ? I have a table import filled with data from uploaded files. On these data are several analyses queries running. I would like to run these analyses queries not on the table import but on a query (select * from import where file_id = $file_id)...

directory

$filename = "http://www.lllll.ch/upload/test.txt"; I use a hard coded url and file name to open this file and insert his content in a table = ok next, i like to get the file under this dir (not longer a hard coded name), the file name is variable, because the clients are uploading this file...

I have the next barrier : tbl format description formatfieldname - 01_SUP (value of this field) - 02_DES (value of this field) - 03_NED (value of this field) formatfieldrequired tbl import 01_SUP (field) 02_DES (field) 03_NED (field) Exactly the same names...

no problem, I found it myself : - file() to get the data and put them in a array - insert to put them in a table.

yep

I have excel files uploaded to my web. These files have fixed columns. I need to open these and the content (number of rows, records is always different) should be inserted in a existing table (fixed colums). What is the best function to open and read the .xls file (fopen ?) and how to insert...

Goal : my clients need to be able to upload .xls files to my website along a form. Thes files can be small but also relatif big. From 1000 kB to 9000 kB (9MB) or more. I used two script. First with HTTP. However he could opload big files. I even changed the php.ini. Secondly my profider...

wow, nice reference. I know the basics about relationships but never to late to sharpen the knowledge (there is a first time for everything - like self-joing one table). pat.

yes, I see, if it is well understand to me, in this way I can maintain my addresses in just one table and I can create a many to many relationschip (form and subform) with a between table containing the IDs.

yes, number 5 could be linked to more then just number#1. Several members can ask for the same brandaddress. Several members itself can ask over a year to many brands.

ok, but one FK won't be enough. Each addressemember can have more then one adressebranch after a while. headform addressemember id 1 subform addressememberbranch fk linked to 1, his own id is 5 addressememberbranch fk linked to 1, his own id is 8 addressememberbranch fk linked to 1, his own...

thanks Leslie, your comparison was matching ! Is it difficult, do you need an extra table, or do you have to make a copy of your addresses table ?

now I have a table addressesmembers and each record in this table can have one to many brandaddresses with are in an additional table. (members, suppliers are looking for some addresses of certain brands). I was thinking, won't it be better, to add the brandaddresses to the table...