Date:	2003-06-09 15:20
Subject:	Problem with query?!
Security:	Public
Mood:	aggravated

Is there something wrong here? Other then me using * (( theres too many rows ))

Database Layout:
id read rDate rEmail rName rHeard game_sc game_scbw game_d1 game_d2 game_d2lod game_w1 game_w2 game_w3 game_w3ft rCurSN rReason

And 'read' is INT(1)
( Collapse )

Any help is apperciated. ^_^

I am switching over my handling of uploaded images in MySql.

They were crunched into a database and outputted with the print command, which was okay with how small the images were and there only being 10 to 30 of them at a time.

The problem is, that the users are seriously computer impaired (salesmen) and are trying to upload jpegs or bitmaps that are around 1024x768 instead of 140x115 gifs, despite the existence of a batch script for photoshop on their computer for converting any new images.

So, I need to find a way to accept any image, and convert it to the proper dimensions and format before it is saved to a destination, that destination would be logged in the database as the image corresponding with that entry.

I already know how to have the uploaded file saved in a destination and how to have the path saved in the database.

The part I am lost on if whether or not I can have this image converted by the server to the proper size and format before it is saved.

Any input would be greatly appreciated.