adding data into mysql database + uploading image + creating thumbnail

[The_Diabolical]

Greetings,

What I'm trying to do is have users upload their event information into a database which would include a flyer. I don't want the image file to go into the database (other than the filename) rather I'd like it to be dropped into a directory. In the same script I'd like to dynamically generate a thumbnail. I have the two scripts and separately they work fine, but I can't get them to work together.

I'm guessing the conflict because the thumbnail script is using $POST and the mysql script is using $SESSION. If so how can I modify them to both use $_SESSION?

The thumbnail script is goes from line 1 - 146 and the mysql portion is the rest.

The results of processing this look something like this.

QUERY TEXT:
INSERT INTO td_events (eventgenre_sel, eventname, eventvenue, eventdate, eventgenre, eventprice, eventpromoter, eventflyer) VALUES ('12', 'spooky times', 'Ironwood Stage & Grill', '2010-12-17 22:36:00', 'DNB', '5000', 'me', '174366-1.jpg')

code

[sneakyimp]

You'll never be able to upload any files if you are using only $_SESSION. You need a form with method=POST to let someone upload an image.

I'm not sure why the SQL code is using session. You could probably replace all those $_SESSION values with constants that you define yourself.