...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) which select out of this table the rows where the file ID is equal to the last uploaded file. If not he will...
$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...
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...
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...
hi, little question,
using frontpage 2000, a page texte with two images (.jpgs).
Afterwards we chose send. The page appears in outlook correctly but on the place of the images a red cross (he refers to images he can't find. How to include the two images. Do we have to past them as attachtments...
I have a little piece of code that writes a file name and afterwards zips this automatically. Not visible but during this he include a hard return in the name of the file.
When uploading this to a webserver a apache server seems this and when a user likes to download the file, he can't find it...
i have an id to solve the question below, but just to know if there are eventually others or better or quicker.
my data is coming from excel (to access)
1. excel1 - colomn1 : idarticles colomn2 : description number records : 100
2. excel2 - colomn1 : idarticles colomn2 : description number...
If you read my first post here, there is not a word about speed, its out of the question. I have a drop down menu and I overwrite this by document.write. As said in the answer (and that was a nice post) is if you overwrite you can't refer to your drop down menu in this way. Ok, but can this be...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.