Hello I am designing a way to manage a way to handle large files, namely interviews. So, in fear of overloading MySQL with the interviews, I decided I would make an entry in MySQL pointing to the interview for easier management with a specific id number. Now what I can't figure out to do is create a separate file containing the interview with the same id number placed in the MySQL database. Does anyone have any suggestions? Thanks in advance!
If you want your script to handle the file creation, then look along the lines of [man]fopen/man
Alright I know how to create a file, but it's the filename of it that I am stuck on. I want the filename to match the ID number of the last mysql entry.
Well, just use the id as the filename (i.e. "ID.txt") then.
Or "interviewID.txt" if you are not so comfortable with that.
If you need to know what is the ID of the most recent row inserted, use [man]mysql_insert_id/man
Ooooh ok that's what I needed, thanks a lot, laserlight!
just out of curiousity, why are you worried about overloading mysql with large interviews? I wouldn't think this would cause any problems
